Thanks for your Reply, but could you please look into my scenario below..
1)..I have created RowNo() as KEY in one of my Table..
let me call the Table name as Test_Table, in this table i have created the KEY from ROWNO() function.
2).. Am doing the RESIDENT LOAD of the same Test_Table again. naming this as Table_2
so link between the two tables is KEY(generated from ROWNO() function).
will it impact..?
As long as you don't recalculate the RowNo() as Key in the second (resident) load, this should work (sorting or filtering with where clause could mix the associations up).
Maybe you could evaluate the Autonumber, AutonumberHash128 (or 256) if there are combined field combinations that might serve as a key as well. This could look like:
AutonumberHash128(Field1, Field2, Field3) as Key
hope this helps