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.
Explain me what are conformed dimensions?
What is execution plan?
Explain which are the olap tools available that are supported by oracle?
Why do we use DSS database for OLAP tools?
What is ?Data Warehousing??
Explain about core dimension,
Explain difference between snow flake and star schema.
What is operational data store (ods)?
Explain in simple terms, the concept of Data Mining.
What is Sequence clustering algorithm?
What are Data Marts?
Store (and count) non-fact records?