ETL Interview Questions
Questions Answers Views Company eMail

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

3 5874

what is data modeling?

1898

what is the difference steps for data modeling?

2077

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

1545

what is the difference between cardinality and Nullability?

2508

what is Forward,Reverse and Re_engineering?

1726

what is the meant by Normalization and de-normalization?

2 7704

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

2005

how do u decide whether u need to do aggregations at database level or at Informatica level?

1 3601

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

1 3223

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1 3784

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?

2428

how do u really know that paging to disk is happening while u are using a lookup transform?

2041

how do u set partition points in the mapping?

Quintiles,

1794

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

1 2930


Post New ETL Questions

Un-Answered Questions { ETL }

What do you understand by the term ‘transformation’?

522


what is session partitioning?

1459


In Which Transformation We Can Use Having Clause In Informatica?

823


what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

1686


When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

536






How many steps etl contains explain with example?

479


What are the types of Data Warehouse applications?

515


What is full load & incremental or refresh load?

683


what is the use of server manager?

1604


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

6924


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

549


What is the difference between project backlog and product backlog?

1026


What is etl process? How many steps etl contains?

594


When do we go for the tools in the market?

548


How to delete data which is not in source table?

832