Import set not updating old records

[Anu Singh1]

Hi Team,

I am doing import to the custom table and I am trying to coalesce multiple fields during import. I want to update every record where this field matches. Import seems to update the first matching record but not the old records if the same coalesce value matches. In my source table data is coming through schedule job which get data from REST end point...so the source data keep updating every time this schedule run.

Attaching screenshot for your reference..

I have put coalesce on Application, DB Name, Environment and role. Kindly help me to fix this issue and share your thoughts.

[Sai Kumar B]

Hi Anu,

As @Ankur Bawiskar mentioned please divide data into 10K as partitions.

Regards,

Sai Kumar

[asifnoor]

What exactly you want to update in the old records? if there is any data to change or jus tthe sys_updated_on field to be changed?

If data to chang, then export the data into xls.. make changes and then import it again.

[asifnoor]

Could you let me know your requirement clearly

[Ankur Bawiskar]

@Anu Singh 

Either take the approach mentioned by Sai or you can update the from script if they are less in number

Regards
Ankur

[Anu Singh1]

Hi,

Do I need to write on before Transform script?