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 6767

what is a test load?

3 16772

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

2274

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

1 6198

how do u implement configuration management in Informatica?

4791

what are business components in Informatica?

2 11169

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

2989

can cubes contain measures ?

2028

can be used COM component in Informatica ?

2059

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

2 4763

when will use SQL override in a lookup transformation?

2294

Two different admin users created for repository are________and_________.

1 3914

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?

1864

Post New ETL Questions

Un-Answered Questions { ETL }

Explain me ETL project architecture in Detail?

2371

Is hadoop a etl tool?

944

what is pmrep command?

11582

What is staging area referring to?

1131

What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

1001

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

2691

what are the production issues in datastage?

10420

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2041

What are the differences between sql override and update override?

1100

what is the use of server?

2196

Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance

2236

What is data cleaning?

942

What are the names of the layers in etl?

1001

In Which Transformation We Can Use Having Clause In Informatica?

1242

Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

3024

For More Un-Answered { ETL } Questions Click Here