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 8683

what is the main role of FI on business

1080

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

Satyam,

4 11461




what are the parts of Informatica server ?

GE,

1 4056

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

Accenture,

1390

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 4522

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

3871

what is the use of server?

1033




what is the use of server manager?

1045

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?

1239

how do u implement scheduling in Informatica?

Cognizant,

1 5176

what is the meaning of upgradation of Repository?

IBM,

2764

what is the indicator file and where it is used?

1 2930

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 ?

1165

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?

2764


Post New ETL Questions






Un-Answered Questions { ETL }

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?

1268


what do u do when DB time takes more?in sap bi

1234


Difference between flat files and relational sources?

1218


Compare ETL & Manual development?

45


how do u set partition points in the mapping?

1234






Define slowly changing dimensions (SCD)?

43


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

1607


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

1231


what are the types in error loging?

1064


Explain do we need an etl tool? When do we go for the tools in the market?

42


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

28


where we cannot use sorter Transformation. if we use then we will not get correct data?

1238


can cubes contain measures ?

1113


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

40


State the differences between shortcut and reusable transformation

43