Interested to Buy Any Domain ? << Click Here >> for more details...
where exactly in dataware house a confirmed dimension can
be created
- 4 Answers
- 12529 Views
- Deloitte, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sandeep.pamarati
A confirmed Dimension, by definition, means a single
dimension table is actually connected to more than one fact
table in your dimensional model.
So, if a dimension table is shared across two fact tables,
for example, then that dimension is called as Conformed
Dimension.
PS: It is NOT Confirmed Dimension but it is Conformed Dimension.
| Is This Answer Correct ? | 15 Yes | 5 No |
Answer / prodyot sarkar
This dimensions are something that is built once in your model and can be reused multiple times with different fact tables. For example consider a model containing multiple fact tables representing different data marts. Now look for a dimension that is common to these facts tables. In this example let’s consider that the product dimension is common and hence can be reused by creating short cuts and joining the different fact tables.Some of the examples are time dimension customer dimensions product dimension.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / sri
conformed dimensions can be created in data staging area as
flat files ready to export.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
How Materialized Views are linked with Oracle DataWare house?
Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---
1 Answers Principal Finance, PT Metalogix Infolink Persada,
Hi Cognos Folks, I have all cognos certification dumps. In fact i am certified in most of the dumps recently. I have cognos material, pdfs, user guides, documents along with dumps. If any one required cognos dumps, please drop me mail at cognos.biuser@gmail.com Thanks, Cognos bi user
What are the various methods of getting incremental records or delta records from the source systems?
Explain difference between view and materialized view?
Explain what is full load & incremental or refresh load?
What is scd1 , scd2 , scd3?
What is up date strategy and what are th options for update strategy?
what is difference between Independent Data Mart Dependent Data Mart 1- 1- 2- 2- 3- 3- 4- 4-
What are data modeling and data mining? Where it will be used?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Teradata 
