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 11742

what is the main role of FI on business

1738

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

Satyam,

4 14505

what are the parts of Informatica server ?

GE,

1 5557

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

Accenture,

2311

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 6387

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

4570

what is the use of server?

1844

what is the use of server manager?

1709

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?

1937

how do u implement scheduling in Informatica?

Cognizant,

1 6896

what is the meaning of upgradation of Repository?

IBM,

3387

what is the indicator file and where it is used?

1 4296

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 ?

1784

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?

3427


Post New ETL Questions

Un-Answered Questions { ETL }

What is tracing level?

769


State the differences between shortcut and reusable transformation

632


Explain about etl data integration software?

596


what are the facilities provided by data warehouse to analytical users?

1775


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

1549






What is partitioning? Explain different types of partitioning?

778


What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

772


what is the use of server?

1844


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

957


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

2311


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?

3427


What do you understand by active and passive transformations?

651


how do u extract data from different data sources explain with an example?

1886


how many steps are there in etl process?

654


Explain about the data integration suite features?

585