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
- 9656 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 |
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
If the records doesnt satisfy the filter condition where will it go?
How can we get two output ports in un-connect transformation?
how may sources can be used in a mapping at a time?(limit)
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Is there any model difference between ODS and DWH
Which is the t/r that builts only single cache memory?
Three date formats are there . How to change these three into One format without using expression transformation ?
Explain the mapping variable usage example in informatica
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
How to load the source table into flat file target(with columns) in informatica?
Describe two levels in which update strategy transformation sets?
Teradata 
