ETL Interview Questions
Questions Answers Views Company eMail

When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.

3 11990

what is the main role of FI on business

1824

what are variable ports and list two situations when they can be used?

Satyam,

4 14768

what are the parts of Informatica server ?

GE,

1 5690

how does the server recongnise the source and target databases.Elaborate on this

Accenture,

2417

list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys

2 6566

what is different between sequential batch and concurrent batch and which is recommended and why?

4650

what is the use of server?

1913

what is the use of server manager?

1805

A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

2012

how do u implement scheduling in Informatica?

Cognizant,

1 7045

what is the meaning of upgradation of Repository?

IBM,

3491

what is the indicator file and where it is used?

1 4428

1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

1857

Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

3492


Post New ETL Questions

Un-Answered Questions { ETL }

What is full load & incremental or refresh load?

946


Explain about power designer data modeling software?

609


when will use SQL override in a lookup transformation?

2041


what do u do when DB time takes more?in sap bi

1950


What do you understand by active and passive transformations?

714


What is staging area referring to?

768


how do u set partition points in the mapping?

1967


how many steps are there in etl process?

718


what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

1872


what is an ETL or ETT? And what are the different types?

7186


How many types of transformations supported by sorted input?

889


Can we create Hierarchies in generic datasources?

2101


Is apache nifi an etl tool?

704


What is lookup table in etl testing?

929


What is initial load and what is full load?

680