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?

2182

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

2 6779

what is a test load?

3 16787

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

2277

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

1 6204

how do u implement configuration management in Informatica?

4798

what are business components in Informatica?

2 11174

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

2990

can cubes contain measures ?

2034

can be used COM component in Informatica ?

2065

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

2 4771

when will use SQL override in a lookup transformation?

2298

Two different admin users created for repository are________and_________.

1 3918

Two default user groups created in the repository are____and_____.

2054

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?

1865

Post New ETL Questions

Un-Answered Questions { ETL }

what is the difference between cardinality and Nullability?

3458

Two default user groups created in the repository are____and_____.

2054

What are the three tiers in etl?

1115

what is session partitioning?

1884

Explain etl?

987

SCD2 will work on only dimension tables as well as fact Table?

1402

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1958

if i have a query as flat file how can we load data to target table

1401

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

2621

Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

950

What are the modules in Power Mart?

962

What are cubes and olap cubes?

988

What are the key benefits of ETL Testing?

1055

What are the differences between sql override and update override?

1104

what is different between sequential batch and concurrent batch and which is recommended and why?

4932

For More Un-Answered { ETL } Questions Click Here