How to perform SCD Typ1 on FlatFile Target in informatica

I have one Requirement. My Source and Target both are Flat Files. In Target 100 records are already present. from source I'm getting 100 records out of these 100 records 50 records has to be insert and 50 records has to be updated on target. so total record count should be 150 in target

1 answer

  • answered 2021-11-23 15:56 Maciejg

    Flat files do not support updates. You can do a lookup to check if the data is already there and decide not to insert a given row.

    Please rework the question, show what you tried and what issue are you facing. I'll be glad to help.

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum