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 8131

what is the main role of FI on business

996

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

Satyam,

4 11069




what are the parts of Informatica server ?

GE,

1 3833

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

Accenture,

1278

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 4317

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

3695

what is the use of server?

945




what is the use of server manager?

958

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?

1135

how do u implement scheduling in Informatica?

Cognizant,

1 4974

what is the meaning of upgradation of Repository?

IBM,

2665

what is the indicator file and where it is used?

1 2743

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 ?

1071

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?

2669


Post New ETL Questions






Un-Answered Questions { ETL }

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

850


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

1278


how to connect to a flatfile through ftp in informatica

12016


explain the methodology of Data Warehousing?(Polaries)

871


what is pmrep command?

1281






please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

1374


two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

972


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?

1179


What is granularity? Please explain with example

338


what is Forward,Reverse and Re_engineering?

1121


Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

947


Two default user groups created in the repository are____and_____.

1034


Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

1042


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

1407


what is the difference between cubes and package in cognos

3692