Print Page - Maintain Table after Successful run of ETL build

Title: Maintain Table after Successful run of ETL build
Post by: lifzgud on 24 May 2010 05:53:41 AM

Hi all,
I am new to Data Manager.
I want to maintain an ETL reference table.
There would be four columns.
Division Number ,Distribution List,Last Run Date time,New Run date time.

I am not sure how to implement this ,
As soon as the ETL runs successfully i need to update The Last run date and the new run date columns.
How can this be acheived?

Title: Re: Maintain Table after Successful run of ETL build
Post by: MFGF on 26 May 2010 10:05:42 AM

Typically via a SQL node in a jobstream, or a procedure node using an SQL() function.

Regards,

MF.

COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: lifzgud on 24 May 2010 05:53:41 AM