Explain what is type 2 version dimension?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Warehouse General Interview Questions

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

0 Answers  


Write a short note on data warehousing & three-Tier Warehouse architecture in detail.

1 Answers  


suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?

3 Answers   Oracle,


Explain what are the mapping paramaters and maping variables?

0 Answers  


What are the difference between snow flake and star schema?

0 Answers  






What is "method/1"?

0 Answers  


What are parallel querys and query hints?

0 Answers  


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 347 what is hybrid slowly changing dimension?

0 Answers  


What is difference between Business Objects and Hyperion Essbase? Please help me

1 Answers   Cap Gemini, TCS,


"A dimension table is wide but the fact table is deep," explain the statement in your own words.

0 Answers  


Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?

0 Answers  


Is there any rownum object from which we can do this?

0 Answers  


Categories