handling null data in change capture stage
Posted: Wed Feb 06, 2008 3:03 am
Hi,
I have a job where i am comparing an oracle table and a sequential file. I have a key column and 2 columns (change values) for which the change needs to be detected. I updated the table with the records in sequential file. So, i deally when i run the job for the second time, all the records should be considered as "copy" records.
But few of them came out as edit records. When i checked the change_code, this "edit" is happening only for records where one of the "change_Values"(i.e columns where there is a change should be detected) is null.
The columns are null in the table as well as the file. But they are considered as "Edit"
Is there any way where we can handle this null issue.
I have a job where i am comparing an oracle table and a sequential file. I have a key column and 2 columns (change values) for which the change needs to be detected. I updated the table with the records in sequential file. So, i deally when i run the job for the second time, all the records should be considered as "copy" records.
But few of them came out as edit records. When i checked the change_code, this "edit" is happening only for records where one of the "change_Values"(i.e columns where there is a change should be detected) is null.
The columns are null in the table as well as the file. But they are considered as "Edit"
Is there any way where we can handle this null issue.