I have to create same types of mapping for more than 60 table. structure of the table is different by the logic for the mapping is same.Do you have any idea how we can achieve it, I am searching for a kind of resuable component?
You can look into using "PowerCenter Mapping Architect for Visio" to help you do this. Create a template of the logic and re-usable components and then parametize the source and target.
Retrieving data ...