where exactly in dataware house a confirmed dimension can
be created
- 4 Answers
- 11335 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / dipti a
Conformed Dimension is the dimension table which is shared between 2 or more fact table. From reusability perspective its very important. Such type of dimensions one can see it in Galaxy schema / fact constellation schema.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain can report net connect multiple datasource at a time in report creation time?
Explain what is batch and describe about types of batches?
What is data cleaning? How can we do that?
How to stop a batch?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What are the advantages and disadvantages of reporting directly against the database?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
Explain a relation schema and a relation?
Can you pass sql queries in filter transformation?
What is difference between query studio and report studio?
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?
Can we take backup when the database is opened?
Name a few sectors which use data warehousing?
Explain what is the limit to the number of sources and targets you can have in a mapping?
What are components of report studio?
