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 11385

what is the main role of FI on business

1660

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

Satyam,

4 14123

what are the parts of Informatica server ?

GE,

1 5369

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

Accenture,

2153

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 6197

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

4485

what is the use of server?

1767

what is the use of server manager?

1629

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?

1850

how do u implement scheduling in Informatica?

Cognizant,

1 6735

what is the meaning of upgradation of Repository?

IBM,

3316

what is the indicator file and where it is used?

1 4136

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 ?

1700

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?

3347


Post New ETL Questions

Un-Answered Questions { ETL }

Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance

1829


Can anyone explain me a scenario from banking and finance...more precisely a mapping

2084


What are cubes and olap cubes?

604


what are the concerns of OLTP and DSS systems?

1581


when will use SQL override in a lookup transformation?

1905






When do we analyze the tables? How do we do it?

562


Compare etl & elt?

588


Explain do we need an etl tool?

553


Explain about power designer data modeling software?

495


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?

1503


what is session partitioning?

1589


dimension object created in oracle can be imported in designer?how?

2484


what is the difference between cubes and package in cognos

4557


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

2209


diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

2131