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 7853

what is the main role of FI on business

953

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

Satyam,

4 10860




what are the parts of Informatica server ?

GE,

1 3701

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

Accenture,

1203

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 4195

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

3588

what is the use of server?

892




what is the use of server manager?

893

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?

1080

how do u implement scheduling in Informatica?

Cognizant,

1 4839

what is the meaning of upgradation of Repository?

IBM,

2599

what is the indicator file and where it is used?

1 2652

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 ?

1006

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?

2617


Post New ETL Questions






Un-Answered Questions { ETL }

what is the difference steps for data modeling?

1360


how to connect to a flatfile through ftp in informatica

11797


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?

779


how to load the data to fact table?

1490


can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

857






what are the reporting tools and difference between them?

950


tell me few points when u become TL

1342


Difference between flat files and relational sources?

1069


explain the methodology of Data Warehousing?(Polaries)

809


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 ?

1006


what is data modeling?

1215


how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

1296


what are the production issues in datastage?

7666


Difference between flat files and relational sources?

1033


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

1203