I have SQL Source which is not having any type of keys all over database. i have to migrate that data to Oracle.
Source Master table is having more than 52 lac records, it's taking hours to read data as there is no key defined on source.
Think Partitioning source wud be best option to read the data.
I'm curently using Informatica8.1.1, when i double click my session--In Mapping Tab, Partition view is not available which should be beside Transformation view.
Do i need to enable any option so that i can view Partition view???
Kindly help
Source Master table is having more than 52 lac records, it's taking hours to read data as there is no key defined on source.
Think Partitioning source wud be best option to read the data.
I'm curently using Informatica8.1.1, when i double click my session--In Mapping Tab, Partition view is not available which should be beside Transformation view.
Do i need to enable any option so that i can view Partition view???
Kindly help