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 8579

what is the main role of FI on business

1066

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

Satyam,

4 11352




what are the parts of Informatica server ?

GE,

1 4008

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

Accenture,

1367

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 4483

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

3839

what is the use of server?

1013




what is the use of server manager?

1018

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?

1214

how do u implement scheduling in Informatica?

Cognizant,

1 5145

what is the meaning of upgradation of Repository?

IBM,

2737

what is the indicator file and where it is used?

1 2885

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 ?

1141

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?

2743


Post New ETL Questions






Un-Answered Questions { ETL }

what is the difference steps for data modeling?

984


Which transformation we use to convert 'NA' to 'Not Available'

315


When do we go for the tools in the market?

11


In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

17


Explain about hash partitioning?

17






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

1449


State the differences between shortcut and reusable transformation

18


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

1018


what are the data modeling tools you have used?(polaris)

1015


what is session partitioning?

1009


what is granularity in Data ware House?

375


How can we use external procedural logic in informatica?

9


How etl testing is different from database testing?

21


How to fine tune mappings?

17


Can we create Hierarchies in generic datasources?

1368