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 8437

what is the main role of FI on business

1039

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

Satyam,

4 11238




what are the parts of Informatica server ?

GE,

1 3933

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

Accenture,

1337

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 4417

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

3784

what is the use of server?

984




what is the use of server manager?

997

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?

1177

how do u implement scheduling in Informatica?

Cognizant,

1 5078

what is the meaning of upgradation of Repository?

IBM,

2712

what is the indicator file and where it is used?

1 2835

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 ?

1116

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?

2719


Post New ETL Questions






Un-Answered Questions { ETL }

How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

1262


what is session partitioning?

981


what is the use of server manager?

997


Difference between flat files and relational sources?

1173


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?

1218






what is pmrep command?

9867


what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

1569


What are the different Lookup methods used in Informatica?

6


What is virtual Data Warehousing?

6


what are the facilities provided by data warehouse to analytical users?

1156


Define slowly changing dimensions (SCD)?

8


flat filevalidation in informatica

1092


Difference between flat files and relational sources?

1150


explain the methodology of Data Warehousing?(Polaries)

922


what is pmrep command?

1322