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 11220

what is the main role of FI on business

1619

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

Satyam,

4 13941

what are the parts of Informatica server ?

GE,

1 5291

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

Accenture,

2084

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 6102

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

4446

what is the use of server?

1729

what is the use of server manager?

1600

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?

1817

how do u implement scheduling in Informatica?

Cognizant,

1 6656

what is the meaning of upgradation of Repository?

IBM,

3289

what is the indicator file and where it is used?

1 4065

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 ?

1664

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?

3306


Post New ETL Questions

Un-Answered Questions { ETL }

In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

535


what are the reporting tools and difference between them?

1583


What is tracing level? How many types of transformations supported by sorted input?

534


Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you 

1342


Define Dynamic push down optmization?

1905






Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

1548


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

2555


What is a lookup table in etl?

582


1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?

1839


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?

3306


Do we need an etl tool?

546


What is grain of fact?

534


when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

1747


What are various etl tools in the market?

515


what is the meant by Normalization and de-normalization?

2227