What is the difference between Junk and Confirmed Dimention?
where can be used htat one in Informatica?




Answers were Sorted based on User's Feedback



What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informat..

Answer / prabhu

Junk dimension contains the data which are currently not
useful. we have to keep these data for feature analysis
purpose.
Whereas Confirm dimentions are common for multiple fact
table.

Is This Answer Correct ?    4 Yes 0 No

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informat..

Answer / sarvesh

merge two or more dimensional tables which are having the
low cardinality colomns into a single table is known
as "junk dimensional tables,
two or more fcat tables can be shared with a single
dimensional table is known as "conformed dimension"

Is This Answer Correct ?    2 Yes 2 No

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informat..

Answer / chaitanya

An interesting use for a junk dimension is to capture the context of a specific transaction. While our
common, conformed dimensions contain the key dimensional attributes of interest, there are likely
attributes about the transaction that are not known until the transaction is processed.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer



More Informatica Interview Questions

Do you have knowledge in ralph kimball methodology

1 Answers  


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,


What are differences between Informatica 7.1 and 6.1

3 Answers  


How big was your fact table

0 Answers  


i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   IBM, Emirates,






What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,


How the informatica server increases the session performance through partitioning the source?

1 Answers  


what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,


Slowly changing dimensions, types and where will you use them

0 Answers  


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

0 Answers   Puma,


What is Datadriven?

2 Answers   Informatica,


can every transfomation reusable?how?

2 Answers   Wipro,






Categories