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 8770

what is the main role of FI on business

1112

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

Satyam,

4 11614




what are the parts of Informatica server ?

GE,

1 4120

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

Accenture,

1421

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 4570

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

3918

what is the use of server?

1049




what is the use of server manager?

1064

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?

1263

how do u implement scheduling in Informatica?

Cognizant,

1 5225

what is the meaning of upgradation of Repository?

IBM,

2787

what is the indicator file and where it is used?

1 2978

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 ?

1184

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?

2792


Post New ETL Questions






Un-Answered Questions { ETL }

What are the names of the layers in etl?

64


list and discuss two approaches for updation of target table in Informatica and how they are different.

1223


Mention few test cases and explain them?

75


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?

1294


what is the use of server?

1049






What is virtual Data Warehousing?

64


What is the difference between round-robin partitioning and hash partitioning?

74


what is pmrep command?

1508


Explain the key challenges that you face while performing etl testing.

63


How many steps etl contains explain with example?

50


what is the use of structures?how many nodes can u create in a structure?

1251


how would u estimate the size of Aggregator transform data and index cache?

1391


What is etl process. How many steps etl contains explain with example?

45


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

1338


how would u estimate the size of Aggregator transform data and index cache?

1022