can anyone please guide me on this.
There are a couple of options;
1. Copy-paste the datastore from your source model into a target model (which has the Logical Schema you would have selected in ODI 11g in the interface Overview page). You may change the name of this datastore, then build a 1:1 mapping between these.
2. Use the Common Format Designer - build the target datastore using a diagram, then generate mappings in - this is particularly useful if you are doing many 1:1 mappings.
Thanks for your inputs david,
Is there no option called as "Add to Target" as in ODI 11g.