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
purpose.
Whereas Confirm dimentions are common for multiple fact
table.
| 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 |
HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
In target table how to display the system time
what is index?how it can work in informatica
in which situations do u go for scds ?
What is the difference between informatics 7x and 8x and what is latest version?
what is dimension table?
What are the disadvantages of Sequence Generator T/R?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
where is the reject loader .
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
hw cn v elimate dublicate values from lookup without overriding sql?