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?

987

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?

1213

What is loop in data warehousing?

1141

How do you create surrogate key using ab initio?

996

What are fact, dimension, and measure?

1335

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

983

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain why denormalization is promoted in universe designing?

961

What is cubes?

1072

What are the methodologies of data warehousing?

992

What is a relationship?

990

Explain how to export mappings to the production environment?

977

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

962

What is meant by metadata in context of a data warehouse and how it is important?

1204

What is the metadata extension?

1000

what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

2500

How to eliminate duplicate rows from flat file?

940

Briefly state different between data ware house & data mart?

1049

How much data hold in one universe.

994

Ist the schema that a data warehouse system can implements.

941

Database in use is oracle?

1053

How can we determine what records to extract?

1081

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