Now there are couple of things here 1) Id1 will be generated (Something like max+1 from TestTable1) 2) Id2 is from some other table, say TestTable2
I think this is not feasible in mload but I am sure we can do in BTEQ. How is it possible in BTEQ? Basically we have to do lookup and generate max+1 value for a table. Your comments will be appreciated!!!