need to capture the data which is having the blank field in the Updated field column in the Incremental load

[Anonymous]

Hi Guys,

we Have implemented the incremental load in the Application and it is working fine ,But user is requesting to include the data which is having blank value in the updated field column,

Could please help us how to capture the blank field.

it is Very Urgent we need to update to user!!!!

michaelwad‌loveisfail‌jimhalpert‌afd‌erika‌bgh‌nick2009‌theresaa‌hod‌

[adityaakshaya]

Hi,

You can do that using isnull function over that field and flag it. I can give you exact steps if you can help me to understand about the incremental load you are using.

Are you only loading the delta data load or updating the previous records too.

Regards,

Akshaya

[jonathandienst]

You are asking for how to modify a loadscript. I suggest that you post the script to that you can get useful suggestions.

Is Updated the field used for controlling the incremental load?