What are cluster analysis in data warehousing?

1108

What is the main difference between schema in rdbms and schemas in datawarehouse?

1093

What is the difference between olap and datawarehosue?

955

What is the function of etl when used in data warehousing?

960

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

996

Why is chameleon method used in data warehouse?

1166

Explain if a flat file cotains 1000 records how can I get first and last records only?

931

What is the 4 + 1 view model as it relates to system modeling?

1040

Explain difference between data ware house & data mart?

990

Explain what is metadata reporter?

975

What is defined as partial backup?

1075

Explain dimension table ?

983

What is bi?

1094

Where the cache files stored?

1012

How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

1077