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 8906

what is the main role of FI on business

1136

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

Satyam,

4 11809

what are the parts of Informatica server ?

GE,

1 4191

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

Accenture,

1455

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 4638

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

3941

what is the use of server?

1077

what is the use of server manager?

1094

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?

1287

how do u implement scheduling in Informatica?

Cognizant,

1 5280

what is the meaning of upgradation of Repository?

IBM,

2809

what is the indicator file and where it is used?

1 3034

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 ?

1211

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?

2822


Post New ETL Questions






Un-Answered Questions { ETL }

can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge

763


Can we create Hierarchies in generic datasources?

1446


Explain etl mapping sheets?

82


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

1661


List few etl bugs?

78






How to delete data which is not in source table?

328


what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

1660


when will use SQL override in a lookup transformation?

1476


Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1119


When do we go for the tools in the market?

76


Explain me ETL project architecture in Detail?

1318


how do u implement configuration management in Informatica?

3923


What are the three tiers in etl?

99


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 ?

1211


how do u identify the changed records in operational data?

1643