I want to update a data in the database, overwriting it. But my problem is: I don't want to overwrite a field WITH VALUES with a NULL value. I want to retain the value in a certain field if my update contains null. I am using EXPRESSOR.
Ok here is an example to show you what I meant:
Assuming this is the existing value in the database:
ID
Name
Address
Phone
Sales
Area
Date
1
Reagan
lindenweg 6
123456
1000
Seewil
12/31/2012
And I want to update that with these data using ID field as the key:
ID
Name
Address
Phone
Sales
Area
Date
1
800
1/23/2013
I want my result to be like this:
ID
Name
Address
Phone
Sales
Area
Date
1
Reagan
lindenweg 6
123456
800
Seewil
1/23/2013
I have tried UPDATE MODE in "Write Table Operator" in Expressor but old values are overwritten with NULL values. Can you help me on this? Thanks a lot.
I dont have to many experiences with expresasor, but in other etl tools this kind of cdc needs rather to read both tables, join old with new rows, checking if update is needed calculating new fields values and then updating DB.
