Answer Posted / tamil
There few columns like, Invoice Number in Invoiceing Module
and Track number in Logistic modules and Vin Number in Car
manufacture module and some descriptions we can not
maintain in the dimensions since there could be huge number
of unique values. Insteade of mainitaing it in the
dimension, we would need to be place it in the associated
fact table for reporting purpose.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are the restrictions of union transformation?
What is a surrogate key?
Explain constraint based loading in informatica
Please let me know how to make Data masking in informatica..
What is an active transformation?
What is the function of union transformation?
What are the new features of informatica 9.x in developer level?
Where is metadata stored?
What is meant by active and passive transformation?
Informatica settings are available in which file?
How to load the data from people soft hrm to people soft erm using informatica?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
what is $$$$?
How can we remove the duplicates from flat file source?