Explain what is type 2 version dimension?
No Answer is Posted For this Question
Be the First to Post Answer
Explain if a flat file cotains 1000 records how can I get first and last records only?
Write a short note on data warehousing & three-Tier Warehouse architecture in detail.
suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?
Explain what are the mapping paramaters and maping variables?
What are the difference between snow flake and star schema?
What is "method/1"?
What are parallel querys and query hints?
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?
What is difference between Business Objects and Hyperion Essbase? Please help me
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
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?
Is there any rownum object from which we can do this?