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 11216

what is the main role of FI on business

1619

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

Satyam,

4 13938

what are the parts of Informatica server ?

GE,

1 5290

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

Accenture,

2084

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 6102

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

4445

what is the use of server?

1728

what is the use of server manager?

1599

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?

1816

how do u implement scheduling in Informatica?

Cognizant,

1 6654

what is the meaning of upgradation of Repository?

IBM,

3288

what is the indicator file and where it is used?

1 4065

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 ?

1663

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?

3306


Post New ETL Questions

Un-Answered Questions { ETL }

How can we use external procedural logic in informatica?

525


What is a mapping?

552


Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you 

1342


How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

778


What is a staging area? What is the purpose of a staging area?

481






Explain about the data integration suite features?

467


what are the concerns of OLTP and DSS systems?

1553


how do u set partition points in the mapping?

2092


What are the names of the layers in etl?

524


what is granularity in Data ware House?

1160


how do use session mapping parameters ?(in which transformation)

1432


Explain different types of partitioning?

611


please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

2020


what is the difference steps for data modeling?

2069


how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

1543