Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am preparing a generic template to process all the rows given in a table(say table has 330 rows).
i) sub-process 1: Read n rows( 0 to 99) from TableA, join with another table in tELTOracleMap -> insert into target TableB
ii) sub-process 2: Read n rows(100 to 199) from TableA, join with another table in tELTOracleMap -> insert into target TableB
iii) sub-process 3: Read remaining rows(>199) from TableA, join with another table in tELTOracleMap -> insert into target TableB
I wanted to use the same job for all 3 sub-process. How do build the where condition to be used in tELTOracleMap.
Thanks.