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

Explain what is the difference between stop and abort?

1045

What are components of report studio?

1055

What are the mapping paramaters and maping variables?

1032

What are the advantages of query studio compared to report studio?

893

Explain what is the extension of file to save template?

977

What is the limit to the number of sources and targets you can have in a mapping?

1108

Explain the difference between filter and conditin?

964

Explain how to export mappings to the production environment?

977

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

926

Explain the versions of reportnet?

988

Explain what are the advantages of query studio compared to report studio?

1025

Explain what is the limit to the number of sources and targets you can have in a mapping?

1005

Explain what is the difference between powerplay transformer and power play reports?

1159

Explain what are the mapping paramaters and maping variables?

1070

Explain the differences between normalizer and normalizer transformation?

1023

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain what is the difference between olap and datawarehosue?

1090

What are the key columns in Fact and dimension tables?

980

What is the difference between drill through and masterdetail reports?

1162

Explain what is ods (operation data source)?

990

Compare and contrast aggregates & indexes

3776

what is parallel query?

2084

Fact table is in normalized or de-normalized form?

962

What is ods (operation data source)?

997

Explain some of modeling tools available in the market?

968

How to load the time dimension?

1010

What is data analysis?

958

Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

1060

What are steps we have to follow in designing the userfriendly universe?

978

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?

962

What is execution plan?

1202

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