Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 10029

what is the main role of FI on business

1419

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

Satyam,

4 12929

what are the parts of Informatica server ?

GE,

1 4768

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

Accenture,

1744

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 5395

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

4219

what is the use of server?

1373

what is the use of server manager?

1389

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?

1582

how do u implement scheduling in Informatica?

Cognizant,

1 5970

what is the meaning of upgradation of Repository?

IBM,

3073

what is the indicator file and where it is used?

1 3564

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 ?

1444

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?

3107


Post New ETL Questions






Un-Answered Questions { ETL }

what is pmrep command?

1738


Explain about enterprise scalability and roi of data integration suite?

286


Two default user groups created in the repository are____and_____.

1443


give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.

1718


Do we need an ETL tool? When do we go for the tools in the market?

337






What are the ETL Testing Operations?

350


What are the differences between sql override and update override?

326


What are the different etl testing categories as per their function?

340


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

1851


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

1284


what is data modeling?

1688


What are the modules in Power Mart?

325


What is the difference between round-robin partitioning and hash partitioning?

354


What is initial load and what is full load?

350


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.

1305