Print Page - How to update/insert rows to a target table in Datamanager

Title: How to update/insert rows to a target table in Datamanager
Post by: SSNCOG on 21 May 2009 04:06:50 AM

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

Title: Re: How to update/insert rows to a target table in Datamanager
Post by: emma on 28 May 2009 03:09:40 PM

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

Title: Re: How to update/insert rows to a target table in Datamanager
Post by: SSNCOG on 05 Jun 2009 12:04:26 AM

Hi thanks for reply.

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

Thnaks,
SSNCOG

COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: SSNCOG on 21 May 2009 04:06:50 AM