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.

1958

what is meant by drill through?(Mascot)

1 2874

what are the different Reporting and ETL tools available in the market?

3 12108

explain the methodology of Data Warehousing?(Polaries)

2293

what are the concerns of OLTP and DSS systems?

1962

what is the difference between OLTP database and data warehousing database?

4 7514

what is data modeling?

1912

what is the difference steps for data modeling?

2139

what are the data modeling tools you have used?(polaris)

4215

what is the difference between cardinality and Nullability?

3453

what is Forward,Reverse and Re_engineering?

QualTech,

2251

what is the meant by Normalization and de-normalization?

2718

what are the different Reporting and ETL tools available in the market?

3 13030

explain the methodology of Data Warehousing?(Polaries)

2020

what are the concerns of OLTP and DSS systems?

TCS,

2450

Post New ETL Questions

Un-Answered Questions { ETL }

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

2274

how do u set partition points in the mapping?

2239

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1719

How many steps etl contains?

944

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

2263

Is hadoop a etl tool?

944

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.

2362

What are the types of Data Warehouse applications?

1025

What are cubes and olap cubes?

985

what is session partitioning?

1879

What are three tier systems in etl?

1066

Define slowly changing dimensions (SCD)?

1060

What is tracing level?

1068

Explain about enterprise scalability and roi of data integration suite?

879

What is data modeling and data mining?

975

For More Un-Answered { ETL } Questions Click Here