How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
No Answer is Posted For this Question
Be the First to Post Answer
What Oracle tools can be used to design and build a W/H?
Explain the importance of data warehouse?
What are the key features of chameleon that separates it from other algorithms?
Explain what is the difference between view filter and report filter?
What are the key columns in Fact and dimension tables?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
What is crass reference table?
what is difference between drill & scope of analysis?
Explain in simple terms, the concept of Data Mining.
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
Explain what are necessary tasks to install reportnet software?
What are data modeling and data mining? Where it will be used?