can u apply SCD2 on flat file tgt? if yes wat is the procedure?
Answer Posted / guddu kumar mehra
We can not update a record in a flat file as we need a Key column to update the record but in flat file we can not have a key column.
So we can not implement SCD type 2 on flat files.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
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
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
r u done any partitions in ur project?
What are active and passive transformations?
What are the informatica performance improvement tips
Difference between Data and Index Caches?
What differs when we choose the sorted input for aggregator transformation?
Is there any target staging area in informatica not staging area
can u give example for factless fact table
How will the document be delivered to me?
What are batches?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the components of Informatica? And what is the purpose of each?
How we can create indexes after completing the loan process?