If you are unable to create a new account, please email support@bspsoftware.com

 

Maintain Table after Successful run of ETL build

Started by lifzgud, 24 May 2010 05:53:41 AM

Previous topic - Next topic

lifzgud

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?

MFGF

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

Regards,

MF.
Meep!