What is confirmed dimension and fact?
Answers were Sorted based on User's Feedback
Answer / prasad.nallapati
A dimension which links with more than one fact table is
called as Confirmed dimesion.
Is This Answer Correct ? | 13 Yes | 3 No |
Answer / praveen kumar pendekanti
If a dimension exists in more than one fact table is known
as confirmed dimension. For every fact table confirmed
dimension should be there ex:: Time dimension....
Is This Answer Correct ? | 8 Yes | 4 No |
Answer / yes
It's actually a "conformed" dimension...meaning a dimension that has the same "form" over multiple data marts....
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / bebo
a confirmed dimension is a dimension which is used in more
then one datamart...exp time dim or customer dim
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / suresh
Conformed dimensions are either identical or strict mathematical subsets of the most granular, detailed dimension. Dimension tables are not conformed if the attributes are labeled differently or contain different values. Conformed dimensions come in several different flavors. At the most basic level, conformed dimensions mean exactly the same thing with every possible fact table to which they are joined. The date dimension table connected to the sales facts is identical to the date dimension connected to the inventory facts
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / rukmini
The dimensions are created once but reuse in multiple times
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / rekha
A DIMENSION WHICH IS FIXED AND REUSABLE IS CALLED CONFIRMED
DIMENSION
EX : TIME
Is This Answer Correct ? | 7 Yes | 10 No |
SO many times i saw "$PM parser error " .what is meant by PM?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
how do u get the first record from 50,000 records ?
10 Answers TCS, UBS,
Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
Three date formats are there . How to change these three into One format without using expression transformation ?
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
What are the reusable transforamtions?
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
What is a design?