Split the incoming records into partitions
Guru's,
I have a table with around 17,000 records each day to get processed through informatica. All these records are distinct in every attribute and the status of the records will be in 'PENDING_CLEAR'.
My requirement is to read these records into 8 partitions (if possible equal partitions) so that i could run in 8 partitions in informatica.
I have the below options available in informatica
1. Pass through
2. Key range and
3. Database partioning.
Option 2 and Option 3 are not possible, since the data base is not partitioned and i will not be able to provide the key ranges, since the primary key on the table is an auto-increment number.
In pass through i will be reading the same 17000 records across all the pipelines and its a challenge to handle it in infomatica.
Any suggestions of paritioning the records using sql??
Thanks a lot for your time.