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?

2116

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

2 6612

what is a test load?

3 16606

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

2221

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

1 6086

how do u implement configuration management in Informatica?

4729

what are business components in Informatica?

2 11026

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

2901

can cubes contain measures ?

1980

can be used COM component in Informatica ?

2020

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

2 4610

when will use SQL override in a lookup transformation?

2226

Two different admin users created for repository are________and_________.

1 3825

Two default user groups created in the repository are____and_____.

1973

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?

1818

Post New ETL Questions

Un-Answered Questions { ETL }

when will use SQL override in a lookup transformation?

2226

Do we need an etl tool?

941

What is tracing level?

1006

What are the ETL Testing Operations?

987

What is a staging area? What is the purpose of a staging area?

824

What do you understand by active and passive transformations?

879

In Which Transformation We Can Use Having Clause In Informatica?

1164

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

1870

what is granularity in Data ware House?

1654

where we cannot use sorter Transformation. if we use then we will not get correct data?

2139

what is the main role of FI on business

2033

what are the reporting tools and difference between them?

2002

can cubes contain measures ?

1980

What is Data Vault???

2680

what is the difference steps for data modeling?

2046

For More Un-Answered { ETL } Questions Click Here