Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9108 Views
- IBM, MAHINDRA, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / mithilesh kumar rai
If a Dimension is shared by all the star schema within the
DWH area, called Confirmed Dimension..
Ex: Suppose Comp_EMP_Master_dim is shared by all the Star
Schema/Fact Table.
here Comp_EMP_Master_dim will called Dimension Table
If a Dimension is shared by some the Star Schema in the DWH,
that is called shared Dimension.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to pivot row data using informatica?
Explain the definition of normalized and denormalized view and what are the differences between them?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
What is your spectra photometer working principles?
Explain a mapping, session, worklet, workflow, mapplet?
What are the key columns in Fact and dimension tables?
What are the tools available for etl?
Explain what is a cube in data warehousing concept?
Difference between PowerPlay transformer and power play reports?
What is difference between query studio and report studio?
What are the main steps to build the data warehouse?
How can you implement many relations in star schema model?
What is an error log table in informatica occurs and how to maintain it in mapping?
What is metadata in context of a datawarehouse and how it is important?
I know of using applysimple, but there are other ways too?
