ETL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

ETL Interview Questions

Questions Answers Views Company eMail

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.

2032

what is meant by drill through?(Mascot)

1 4299

what is pmrep command?

2437

what happens if the info.server doesn't find the session parameter in the parameter file?

2 5048

Can u access a repository created in previous version of Informatica?

DELL,

1 5533

Eliminating of duplicate records without using dynamic lookups

1 4294

what are Lookup caches options? Including persistent caches.

1 4699

Difference between flat files and relational sources?

2306

what is session partitioning?

1879

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

5 16319

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

1932

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1 4193

what is pmrep command?

1 11576

what happens if the info.server doesn't find the session parameter in the parameter file?

1 5490

Can u access a repository created in previous version of Informatica?

1860

Post New ETL Questions

Un-Answered Questions { ETL }

What is a materialized view log?

997

what is the difference steps for data modeling?

2596

what is granularity in Data ware House?

1723

What is tracing level and what are the types?

958

what is pmrep command?

2431

Explain the use lookup tables and Aggregate tables?

977

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

998

Which transformation we use to convert 'NA' to 'Not Available'

1268

Explain what is etl process? How many steps etl contains explain with example?

893

When do we analyze the tables? How do we do it?

960

Define slowly changing dimensions (SCD)?

1060

Explain the difference between etl tool and olap tools?

908

how would u estimate the size of Lookup transform data and index cache?

2128

When do we analyze the tables?

967

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

1401

For More Un-Answered { ETL } Questions Click Here