How are the dimension tables designed?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between star and snowflake schemas?
What is the function of surrogate key in data warehousing?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
4 Answers IBM, MAHINDRA, Tech Mahindra,
How to pivot row data using informatica?
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?
what are different storage options supported by oracle ?
Explain what are components of reportnet?
how much memory space occupied real time project (roughly)?
What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh
Explain when do we analyze the tables? How do we do it?
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 meetthe condition.
Why is business intelligence (bi) important in data warehousing?