What is confirmed dimension?
Answers were Sorted based on User's Feedback
Answer / ram
A Dimention table which can be shared by 2 or more fact
tables. for example time dimention which we can use in in
any fact table. is known as confirmed dimention
| Is This Answer Correct ? | 10 Yes | 4 No |
Answer / guest
a dimension which is shared by all fact tables that is
confirmed dimension.
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / pratap gangula
A confirmed dimension is a dimension which can be joined with more than one fact table and can be reused in other data marts as well.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / uma
an intermediate table(dummy table) to join 2 star schemas
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / raji
which is maintaining more than one fact table is called
confirm dimension. which is reusable dimension.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / santhosh kumar n
a dimension which can be shared by multople fact tables is
known as conformed dimension. this concept is from galaxy
schema.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ramjanaki
Confirmed Dimension is, which can be reusable across
multiple data marts.
| Is This Answer Correct ? | 3 Yes | 8 No |
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
Explain what is partitioning? What are the types of partitioning?
What is the difference between ods and oltp?
Explain what is the extension of file to save template?
What are the steps involved in designing a fact table?
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I
3 Answers IBM, Ness Technologies,
What is the difference between snowflake and star schema?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
How to create different types of templates?
What is a cube in data warehousing concept?
What is informatica architecture?
Why null values are mapped as 0 in fact tables?