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 6753

what is a test load?

3 16762

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

2269

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

1 6184

how do u implement configuration management in Informatica?

4784

what are business components in Informatica?

2 11157

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

2982

can cubes contain measures ?

2024

can be used COM component in Informatica ?

2057

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

2 4752

when will use SQL override in a lookup transformation?

2288

Two different admin users created for repository are________and_________.

1 3907

Two default user groups created in the repository are____and_____.

2038

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?

1854

Post New ETL Questions

Un-Answered Questions { ETL }

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

1258

how do u implement configuration management in Informatica?

4784

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

2034

What are the ETL Testing Operations?

1046

give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.

2349

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?

2226

What is Data Vault???

2739

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2885

explain the methodology of Data Warehousing?(Polaries)

2288

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

1190

What are your responsibilities as an etl tester?

1152

What is a lookup table in etl?

1184

what is an ETL or ETT? And what are the different types?

7493

How to delete data which is not in source table?

1334

What is abap? What are idocs?

963

For More Un-Answered { ETL } Questions Click Here