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 9337

what is the main role of FI on business

1254

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

Satyam,

4 12355

what are the parts of Informatica server ?

GE,

1 4429

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

Accenture,

1573

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 4965

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

4052

what is the use of server?

1201

what is the use of server manager?

1217

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?

1409

how do u implement scheduling in Informatica?

Cognizant,

1 5528

what is the meaning of upgradation of Repository?

IBM,

2936

what is the indicator file and where it is used?

1 3253

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 ?

1315

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?

2940


Post New ETL Questions






Un-Answered Questions { ETL }

Difference between flat files and relational sources?

1399


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

2081


what is the difference between cubes and package in cognos

4029


what are the session parameters? How do u set them?

1133


can cubes contain measures ?

1265






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

1655


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

1083


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

1175


How many types of transformations supported by sorted input?

215


what is the meaning of upgradation of Repository?

2936


when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

1414


what is the difference steps for data modeling?

1707


What is tracing level and what are the types?

192


how to load the data to fact table?

1797


What is lookup table in etl testing?

165