Answer Posted / vensh
Dimension table is nothing but a table which contains detailed description about the data except any values...
Fact table mainly contains the facts nothing but the values that is related to the data in the dimension table and by using the primary key in dimension table and the foreign key in the fact table we will map the dimensional table and the fact table
Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
Who needs data warehousing?
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.
What is data stream and data adaopter?
What do you mean by static and local variable?
What are data modeling and data mining?
Explain the different types of data warehousing?
Explain is fact table?
Explain what are non-additive facts?
Explain about core dimension, balanced dimension, and dirty dimension?
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.
What is a data warehousing?
What is a linked cube?
What is the data type of the surrogate key?
Where the data cube technology is used?