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 |
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
What is partitioning? What are the types of partitioning?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What is normalization, first normal form, second normal form, third normal form?
Start a batches with in a batch?
What is aggregate awareness?
What is the main difference between star and snowflake star schema? Which one is better and why?
In microstrategy, how can we direct the sql generated to use a specifc table?
Explain bus schema?
How to handle multi value dimensions?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani