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 surrogate key? Where we use it?

997

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

992

After we create a scd table, can we use that particular dimension as a dimension table for star schema?

996

What is dimension modeling?

1088

What is the difference between mapping parameter & mapping variable in data warehousing?

989

Where the cache files stored?

1012

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 meetthe condition.

1090

How can we run the graph? How can we schedule the graph in unix?

954

What is the difference between star and snowflake schemas?

1214

What is loop in data warehousing?

1142

How do you create surrogate key using ab initio?

996

What are fact, dimension, and measure?

1336

What are the difference between snow flake and star schema?

1006

How can we schedule the graph in unix?

1000

I have two universes created by two difference database can we join them in designer & report level? How

984

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are the advantages and disadvantages of reporting directly against the database?

982

What is called dimensional modelling?

1111

How can you implement many relations in star schema model?

1002

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

1057

Explain what are the different types of join operations?

973

What is a data profile?

975

What are cluster analysis in data warehousing?

1110

Explain what is analytical or analytic mean?

1017

What are diagrams?

1042

Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

958

What are the other names given to data warehousing?

1098

What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

5648

What are the different types of data warehouses?

1086

What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

1104

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

1159

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