Update CSV file

Anonymous — Sat, 16 Nov 2024 05:11:01 GMT

Hi Guys,

Is it possible to achieve SCD2 type using csv file.

As in CSV would be the source and target. When i load the delta(Csv file), it should ideally insert new records and update existing records.

Regards

Re: Update CSV file

vapukov — Wed, 24 Jul 2019 11:47:03 GMT

Hi,

not effective, but yes it possible with 2 tMap:

first tmap use LEFT JOIN and update rows from the source file
second tMap use INNER JOIN and append rejected rows to file - possible it will be collision (file already opened), so will need to add one more step - store data to the temp file, then append target from temp

regards, Vlad