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 11979

what is the main role of FI on business

1824

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

Satyam,

4 14759

what are the parts of Informatica server ?

GE,

1 5690

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

Accenture,

2417

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 6565

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

4646

what is the use of server?

1909

what is the use of server manager?

1798

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?

2010

how do u implement scheduling in Informatica?

Cognizant,

1 7043

what is the meaning of upgradation of Repository?

IBM,

3489

what is the indicator file and where it is used?

1 4422

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 ?

1857

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?

3492


Post New ETL Questions

Un-Answered Questions { ETL }

what are the concerns of OLTP and DSS systems?

2190


Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1814


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

1713


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

1687


What is etl process?

693


Explain different types of partitioning?

770


what is the difference steps for data modeling?

1772


how do u set partition points in the mapping?

2274


Explain about round-robi?

855


Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

1938


can be used COM component in Informatica ?

1805


Explain do we need an etl tool?

702


what is Forward,Reverse and Re_engineering?

1896


what is the difference between cardinality and Nullability?

3041


what is pmrep command?

11109