Answer Posted / rg
factless fact table contains only the keys of the dimension
table.
they do not contain any measures.
whereas fact table contains both dimension table keys and
also measures.
| Is This Answer Correct ? | 32 Yes | 2 No |
Post New Answer View All Answers
What are aggregate transformation?
Why we use repository connectivity?
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?
Explain the difference between filter and conditin?
Explain what are fact, dimension, and measure?
What is the extension of file to save template?
What is the function of etl when used in data warehousing?
What is surrogate key? Explain with examples.
What is operational data store (ods)?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
What is many-to-many dimensional model in datawarehousing ?
Explain dimension table ?
Can any one explain the hierarchies level data warehousing.
Difference between PowerPlay transformer and power play reports?
What are target types on the server?