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 7731

what is the main role of FI on business

930

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

Satyam,

4 10758




what are the parts of Informatica server ?

GE,

1 3646

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

Accenture,

1174

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 4142

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

3525

what is the use of server?

866




what is the use of server manager?

872

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?

1057

how do u implement scheduling in Informatica?

Cognizant,

1 4751

what is the meaning of upgradation of Repository?

IBM,

2580

what is the indicator file and where it is used?

1 2605

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 ?

971

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?

2587


Post New ETL Questions






Un-Answered Questions { ETL }

how do u identify the changed records in operational data?

1370


what is session partitioning?

842


what are the reporting tools and difference between them?

928


what make u disappointmnets in u r career

1101


what are the concerns of OLTP and DSS systems?

1200






how do u really know that paging to disk is happening while u are using a lookup transform?

1269


Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

1308


two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

882


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

3525


what are Lookup caches options? Including persistent caches.

706


Identifying the bottlenecks in various components of Informatica and resolving them.

779


how do u implement configuration management in Informatica?

3655


how many maximum session supports to multiload in teradata ??

926


how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

832


explain the methodology of Data Warehousing?(Polaries)

783