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 10789

what is the main role of FI on business

1552

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

Satyam,

4 13578

what are the parts of Informatica server ?

GE,

1 5097

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

Accenture,

1971

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 5879

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

4365

what is the use of server?

1652

what is the use of server manager?

1528

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?

1745

how do u implement scheduling in Informatica?

Cognizant,

1 6436

what is the meaning of upgradation of Repository?

IBM,

3208

what is the indicator file and where it is used?

1 3911

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 ?

1578

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?

3234


Post New ETL Questions

Un-Answered Questions { ETL }

what is the meaning of upgradation of Repository?

3208


What is initial load and what is full load?

434


Mention few test cases and explain them?

477


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

1962


Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1380






What is a materialized view log?

453


What do you understand by active and passive transformations?

469


SCD2 will work on only dimension tables as well as fact Table?

896


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

2416


what are the reporting tools and difference between them?

1509


How can we use external procedural logic in informatica?

440


explain the methodology of Data Warehousing?(Polaries)

1718


What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

573


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 ?

1578


Explain the difference between etl tool and olap tools?

464