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
Answer / prabhu
Junk dimension contains the data which are currently not
useful. we have to keep these data for feature analysis
Whereas Confirm dimentions are common for multiple fact
|Is This Answer Correct ?||4 Yes||0 No|
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|
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|
Do you have knowledge in ralph kimball methodology
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are differences between Informatica 7.1 and 6.1
How big was your fact table
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.
What is the difference between writing a joiner query in ANSI style and THETA style?
How the informatica server increases the session performance through partitioning the source?
what is the need of session partitioning... how it is useful in real time
Slowly changing dimensions, types and where will you use them
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 ?
What is Datadriven?
can every transfomation reusable?how?