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
- 8937 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
Explain some of modeling tools available in the market?
What is the difference between Datawarehouse and OLAP?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
Explain what are fact, dimension, and measure?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
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 347 what is hybrid slowly changing dimension?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
What is metadata in context of a datawarehouse and how it is important?
How to pivot row data using informatica?
Explain datawarehousing?
What are the advantages of query studio compared to report studio?
What is difference macros and prompts?
What is a functional dependency f said to be minimal?
What is the difference between constraind base load ordering and target load plan?
Explain difference between view and materialized view?
