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 a mapping, session, worklet, workflow, mapplet?

1106

What are the different types of join operations?

1002

Explain what is a three tier data warehouse?

975

Explain piconet?

961

Which are the olap tools available that are supported by oracle?

935

What is the difference between olap and datawarehosue?

955

Explain what are the different types of join operations?

973

Explain the different types of data warehousing?

991

Explain what are non-additive facts in detail?

1035

What is is a star schema?

1174

Explain what is a view as it relates to system modeling?

987

Explain what are slowly changing dimensions?

1024

I know of using applysimple, but there are other ways too?

960

Explain what are the various methods of getting incremental records or delta records from the source systems?

967

Why denormalization is promoted in universe designing?

987

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain ddl (data definition language)?

1006

Explain the different types of data warehousing?

991

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

954

What are diagrams?

1042

can anybody mail me the FAQS for hyperion essbase amd planning

5646

How do we design a universe?

938

What are non-additive facts in detail?

995

Explain grouped cross tab?

2626

What is a real-time data warehouse?

998

Explain bus schema?

973

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

996

What is the purpose of cluster analysis in data warehousing?

1008

Explain the difference between dw and bi?

1048

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

981

Where do we use semi and non additive facts?

992

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