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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

r u done any partitions in ur project?

1378


What are the informatica performance improvement tips

587


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 ?

1715


While migrating the data from one environment to another environment how would you manage the connections?

599


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

571






What do you mean by worklet?

602


What is informatica etl tool?

528


What is a stored procedure transformation?

589


Where is metadata stored?

596


How we can create indexes after completing the load process?

583


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

609


can any one give some examples for pre sql and post sql(Except dropping and creating index).

3479


Explain the features of connected and unconnected lookup.

517


How to extract sap data using informatica? What is abap? What are idocs?

529


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

649