Data Warehouse General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Warehouse General Interview Questions

Questions Answers Views Company eMail

What is factless fact schema?

2 6800

What is confirmed dimension?

JPMorgan Chase,

7 16464

What is the capacity of power cube?

2 6696

Difference between PowerPlay transformer and power play reports?

CTS,

2517

What is IQD file?

1 5615

What is Cognos script editor?

2554

What is difference macros and prompts?

2307

What is power play plug in?

3 4776

Which kind of index is preferred in DWH?

1 8654

What is hash partition?

TCS,

3 5332

What is DTM session?

1 9274

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

TCS,

7 11066

What is mapplet?

1 6540

What is query panel?

1 3917

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

1 5168

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are the differences between star and snowflake schema?

1105

Fact table is in normalized or de-normalized form?

960

How to drill through from a powerplay cube to reportnet?

937

What is surrogate key? Explain with examples.

1158

Explain the importance of data warehouse?

1013

Explain what is full load & incremental or refresh load?

984

What are the data marts?

975

What is conformed fact?

1092

What are non-additive facts in detail?

995

What are loops in Datawarehousing?

997

Explain about core dimension,

984

Explain can report net connect multiple datasource at a time in report creation time?

925

What is mean by aggregate aware?

1084

Store (and count) non-fact records?

931

Give some difference between oltp and olap.

1008

For More Un-Answered { Data Warehouse General } Questions Click Here