Update CSV file

[Anonymous]

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

[vapukov · Accepted solution]

Hi,

not effective, but yes it possible with 2 tMap:

1. first tmap use LEFT JOIN and update rows from the source file
2. 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