In the Transform script ON COMPLETE, how to get target's records?

[____39]

I want to update target table's many records, use for or while? how to write script? thank you!

[Chetan Mahajan]

See ref Vid how to import data : https://www.youtube.com/watch?v=rpOyFv19E4E

[Chetan Mahajan]

do you want to give some unique number for each INSYID for every record at time of insertion ?

[Chetan Mahajan]

Do you want to populate a unique number in INSYSID ? or do you want to populate current sys_id in INSYSID ? 

[____39]

I want to populate a unique number in INSYSID , if i use target.u_insysid = 1,it only updated a record, I just want to know how to updata all target records in the Transform script ON COMPLETE? thank you!