What is confirmed dimension and fact?

Answers were Sorted based on User's Feedback



What is confirmed dimension and fact?..

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

What is confirmed dimension and fact?..

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

What is confirmed dimension and fact?..

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

What is confirmed dimension and fact?..

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

What is confirmed dimension and fact?..

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

What is confirmed dimension and fact?..

Answer / rukmini

The dimensions are created once but reuse in multiple times

Is This Answer Correct ?    1 Yes 2 No

What is confirmed dimension and fact?..

Answer / rekha

A DIMENSION WHICH IS FIXED AND REUSABLE IS CALLED CONFIRMED
DIMENSION
EX : TIME

Is This Answer Correct ?    7 Yes 10 No

Post New Answer

More Informatica Interview Questions

SO many times i saw "$PM parser error " .what is meant by PM?

1 Answers  


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

2 Answers   AHM,


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

2 Answers   Wipro,


what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  






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?

3 Answers   HP,


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 ?

3 Answers   HP,


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?

2 Answers  


What are the reusable transforamtions?

1 Answers  


2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

2 Answers   TCS,


What is a design?

1 Answers  


Categories