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 11113

what is the main role of FI on business

1601

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

Satyam,

4 13885

what are the parts of Informatica server ?

GE,

1 5248

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

Accenture,

2066

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 6062

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

4430

what is the use of server?

1712

what is the use of server manager?

1584

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?

1804

how do u implement scheduling in Informatica?

Cognizant,

1 6608

what is the meaning of upgradation of Repository?

IBM,

3274

what is the indicator file and where it is used?

1 4032

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 ?

1641

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?

3288


Post New ETL Questions

Un-Answered Questions { ETL }

what are Lookup caches options? Including persistent caches.

1407


Explain about hash partitioning?

520


How etl testing is different from database testing?

499


what is the difference steps for data modeling?

2055


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

1785






hoe to access second value in mapping parameter if it is having more than one value ?????????????

1102


When do we analyze the tables?

511


What is fact? What are the types of facts?

513


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

1477


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?

1525


what are the reports developed in sap bw project and what is the requirement for developing it?

1752


when will use SQL override in a lookup transformation?

1847


how do u really know that paging to disk is happening while u are using a lookup transform?

1537


how do u handle performance issues in Informatica . where can u monitor the performance ?

4240


what happens if the info.server doesn't find the session parameter in the parameter file?

1519