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?

2174

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

2 6764

what is a test load?

3 16770

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

2271

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

1 6194

how do u implement configuration management in Informatica?

4791

what are business components in Informatica?

2 11167

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

2989

can cubes contain measures ?

2026

can be used COM component in Informatica ?

2059

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

2 4761

when will use SQL override in a lookup transformation?

2291

Two different admin users created for repository are________and_________.

1 3913

Two default user groups created in the repository are____and_____.

2047

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?

1862

Post New ETL Questions

Un-Answered Questions { ETL }

what are the concerns of OLTP and DSS systems?

2450

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

2014

how many steps are there in etl process?

979

What is a mapping, session, worklet, workflow, mapplet?

985

How to increase performance without changing anything in mapping.( In prod)

1264

What are three tier systems in etl?

1066

how to load the data to fact table?

2703

list and discuss two approaches for updation of target table in Informatica and how they are different.

2107

Give the benefits of data integration suite?

921

how do u identify the changed records in operational data?

2527

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4112

explain the methodology of Data Warehousing?(Polaries)

2017

what is Forward,Reverse and Re_engineering?

2196

what are Lookup caches options? Including persistent caches.

1974

can be used COM component in Informatica ?

2059

For More Un-Answered { ETL } Questions Click Here