ETL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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 12978

what is the main role of FI on business

2050

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

Satyam,

4 15697

what are the parts of Informatica server ?

GE,

1 6266

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

Accenture,

2643

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 7172

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

4879

what is the use of server?

2145

what is the use of server manager?

2067

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?

2182

how do u implement scheduling in Informatica?

Cognizant,

1 7691

what is the meaning of upgradation of Repository?

IBM,

3707

what is the indicator file and where it is used?

1 4958

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 ?

2070

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?

3727

Post New ETL Questions

Un-Answered Questions { ETL }

how do u implement configuration management in Informatica?

4742

How to increase performance without changing anything in mapping.( In prod)

1217

what are the cubes developed in a sap bw project and what is the requirement for developing it?

2026

Explain what are the various etl tools in the market?

897

What are the different Lookup methods used in Informatica?

873

can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

2123

What is a mapping?

946

What is partitioning? Explain different types of partitioning?

1170

Compare etl & elt?

955

what is data modeling?

2276

State the differences between shortcut and reusable transformation

1008

Can we create Hierarchies in generic datasources?

2338

What is cube grouping?

1009

where are the log files generally stored.Can you change the path of the file.what can the path be?

2384

Two default user groups created in the repository are____and_____.

1990

For More Un-Answered { ETL } Questions Click Here