Explain what is type 2 version dimension?
No Answer is Posted For this Question
Be the First to Post Answer
Explain which columns go to the fact table and which columns go the dimension table?
Explain Process flow in data warehouse??
What are the steps involved in creating dimensional modeling process?
What is critical column?
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.
What is static and local variable?
What is scd1 , scd2 , scd3?
What is the difference between data warehouse and operational systems?
What is the difference between er modeling and dimensional modeling?
What is "method/1"?
what is table partitioning? How it is useful to warehouse database?
In a star schema, are foreign key constraints between facts and dimensions neccessary?