Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Junk and Confirmed Dimention?
where can be used htat one in Informatica?
- 3 Answers
- 9643 Views
- I also Faced
- E-Mail Answers
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 |
What are the join types in joiner transformation?
What happens if we dont select data driven option?
what is mean by complex business rule ?
HOW DO YOU PARFORM INCREMENTAL LAOD ?
Implementation methodology
wht target override?wht advantages it has compare to target update?
What is an aggregator transformation? it is active why cant it be passive explain?
How to add source flat file header into target file?
How You Pull the records on daily basis into your ETL Server.
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Can you create a flatfile target
what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
Teradata 
