what is confirmed fact?

Answers were Sorted based on User's Feedback



what is confirmed fact?..

Answer / akash

I am not aware of conformed fact but conformed dimension
tables exist.
A conformed dimension is one which is used by more than one
fact table. A classic example of conformed table is a
dimension table which has date fields.

Please let me know if conformed facts exist and their
definition.

Is This Answer Correct ?    3 Yes 8 No

what is confirmed fact?..

Answer / sanjay

A fact which can be used across multiple datamart is called
as confirmed fact. Confirmed fact allows having the same
name in different table.

Is This Answer Correct ?    8 Yes 14 No

Post New Answer

More Informatica Interview Questions

how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

2 Answers   emc2,


Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

3 Answers   Syntel,


How to load the data from a flat file into the target where the source flat file name changes daily?

1 Answers   Informatica,


What is meant by active and passive transformation?

1 Answers  


Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

8 Answers   HP,


my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

3 Answers   Satyam,


what are the difference between Informatica 7.1 and 8.1?

6 Answers  


Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj

2 Answers  


in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

5 Answers   Cap Gemini,


can u any challenge your project?

1 Answers   HP,


How many repositories can be created in informatica?

1 Answers  


What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).

1 Answers   CTS,


Categories