SQL Server Enterprise Stage - Reject Records
Posted: Wed Aug 13, 2008 2:45 am
Hi Folks,
I have installed Datastage v8 on Windows platform. I have kept the backend as SQL Server 2003. I am currenlty trying to insert/update records into the table. Please find below the scenario :
1) A new record is to be inserted if the Primary key column has a new incoming value( this is the usual Insert statement)
2) When an update has happened on the non-key fields of the table, another record is to be written into the same table with the updated values( I guess the 2 could be tracked using timestamp fields).
3) If the same Input record comes in without any change to any of the key or non-key values, the record should error out to an Error table.
The error table should also have records that have Incorrect value in the respective fields(NUll, Ddatatype mismatch etc...)
I have heard and Implemented Error tables concept in Teradata and Oracle. Can anybody guide me through this concept (maintaining history in SQL Server tables) ?
Thanks,
Chandru
I have installed Datastage v8 on Windows platform. I have kept the backend as SQL Server 2003. I am currenlty trying to insert/update records into the table. Please find below the scenario :
1) A new record is to be inserted if the Primary key column has a new incoming value( this is the usual Insert statement)
2) When an update has happened on the non-key fields of the table, another record is to be written into the same table with the updated values( I guess the 2 could be tracked using timestamp fields).
3) If the same Input record comes in without any change to any of the key or non-key values, the record should error out to an Error table.
The error table should also have records that have Incorrect value in the respective fields(NUll, Ddatatype mismatch etc...)
I have heard and Implemented Error tables concept in Teradata and Oracle. Can anybody guide me through this concept (maintaining history in SQL Server tables) ?
Thanks,
Chandru