Thursday, 7 January 2016

Explain these terms Session, Worklet, Mapplet and Workflow ?

Mapplet : It arranges or creates sets of transformation
 Worklet: It represents a specific set of tasks given
 Workflow: It’s a set of instructions that tell the server how to execute tasks
 Session: It is a set of parameters that tells the server how to move data from sources to target.

Explain what are Schema Objects?

Schema objects are the logical structure that directly refer to the databases data. Schema objects includes tables, views, sequence synonyms, indexes, clusters, functions packages and database links

Explain what is data purging?

Data purging is a process of deleting data from data warehouse. It deletes junk data’s like rows with null values or extra spaces.

What is Bus Schema?

For the various business process to identify the common dimensions, BUS schema is used. It comes with a conformed dimensions along with a standardized definition of information

Explain what staging area is and what is the purpose of a staging area?

Data staging is an area where you hold the data temporary on data warehouse server. Data staging includes following steps
 Source data extraction and data transformation ( restructuring )
 Data transformation (data cleansing, value transformation )
 Surrogate key assignments

How you can extract SAP data using Informatica?

With the power connect option you extract SAP data using informatica
 Install and configure the PowerConnect tool
 Import the source into the Source Analyzer. Between Informatica and SAP Powerconnect act as a gateaway. The next step is to generate the ABAP code for the mapping then only informatica can pull data from SAP
 To connect and import sources from external systems Power Connect is used

Explain what is the difference between OLAP tools and ETL tools ?

The difference between ETL and OLAP tool is that
 ETL tool is meant for the extraction of data from the legacy systems and load into specified data base with some process of cleansing data.
 Example: Data stage, Informatica etc.
 While OLAP is meant for reporting purpose in OLAP data available in multi-directional model. Example: Business Objects, Cognos etc.