How to update/insert rows to a target table in Datamanager

[SSNCOG]

Hi,

I am new to DM and Know only basics and can created simple pass through builds.I have folloeing requirement.Could any one help me in detail regarding the issue.

issue:

I have a table "table1" and has the columns Consumer,region,country,city,address,phone,email.City,address,Phone,email may change in future.I have a flat file(xls or csv) source to load in to target table.
When next time job runs, rows that were updated should reflect in target table, at the same time new row should insert into taret table.

Can any one help me to build this logic for flatfile source as well as Database source table.

Thanks for your help in advance.

SSN

[emma]

Is that a type 2 dimension what you have to load ?

[SSNCOG]

Hi thanks for reply.

I waslooking for both Type 1 and 2.I got the logic to impliment both type of dimension.

Thnaks,
SSNCOG