Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is factless fact schema?

2 5662

What is confirmed dimension?

JPMorgan Chase,

7 13994

What is the capacity of power cube?

2 5751

Difference between PowerPlay transformer and power play reports?

CTS,

2066

What is IQD file?

1 4787

What is Cognos script editor?

2072

What is difference macros and prompts?

1713

What is power play plug in?

3 3647

Which kind of index is preferred in DWH?

1 7900

What is hash partition?

TCS,

3 4014

What is DTM session?

1 7978

How can you define a transformation? What are different types of transformations in Informatica?

TCS,

7 8865

What is mapplet?

1 5277

What is query panel?

1 3175

What is a look up function? What is default transformation for the look up function?

1 3992


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are data modeling and data mining? Where it will be used?

541


What is a staging area? Do we need it? What is the purpose of a staging area?

550


What is conformed fact?

626


What are the reasons to use a chameleon method in data warehousing?

564


How to get the first 100 rows from the flat file into the target?

678






What is surrogate key? Where we use it? Explain with examples.

542


For faster process, what we will do with the universe?

568


Explain what are the advantages data mining over traditional approaches?

680


Why is business intelligence (bi) important in data warehousing?

532


What are the different models used in cluster analysis?

510


Explain differences between star and snowflake schemas?

532


Explain what is a three tier data warehouse?

543


Start a batches with in a batch?

551


Explain the data type of the surrogate key?

567


Why we use repository connectivity?

540