ETL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

ETL Interview Questions

Questions Answers Views Company eMail

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?

2135

what is the difference between normal & bulk loading? and which one is recommended ? why?

2 6633

what is a test load?

3 16646

How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

2232

what is the difference between shortcut of an object and copy of an object? compare them?

1 6108

how do u implement configuration management in Informatica?

4743

what are business components in Informatica?

2 11056

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

2921

can cubes contain measures ?

1992

can be used COM component in Informatica ?

2029

what is the advantage of persistent cache? when it should be used?

2 4643

when will use SQL override in a lookup transformation?

2244

Two different admin users created for repository are________and_________.

1 3852

Two default user groups created in the repository are____and_____.

1990

A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

1832

Post New ETL Questions

Un-Answered Questions { ETL }

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

2134

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.

2020

What is a mapping?

946

What are the ETL Testing Operations?

1000

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

1026

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?

2183

what is Forward,Reverse and Re_engineering?

2143

What is lookup table in etl testing?

1129

when will use SQL override in a lookup transformation?

2244

What are the types of Data Warehouse applications?

960

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

1148

Compare etl & elt?

955

what is the difference steps for data modeling?

2540

What is staging area referring to?

1071

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

2921

For More Un-Answered { ETL } Questions Click Here