This content has been marked as final. Show 5 replies
You can use the MDL export/import utility for this, but as you are importing into the same repository you will end up with importing into the same project again.
So for this you can follow the workaround as:
->Take export of the required mapping from the project OWB_B
-> Rename the Project OWB_B to some thing like OWB_B_1(or any other name), note that you have to rename both logical and physical name of the project
-> Rename the project OWB_A to OWB_B and if you import the MDL all the objects will be imported to OWB_B then you can rename back the project to OWB_A
-> Finally rename the project OWB_B_1 to OWB_B (to its original name).
Thanks for your suggestions. Will renaming the projects change the UID of OWB objects and thereby cause instability? Is there any other way to achieve it without renaming?
I have worked with Informatica powercenter where metdata import is easy whereas in OWB it has some limitaions :(
In addition to the points given by Pnreddy you can try the following
Export mdl from project_a
Open the mdl file ( it is ia zipped file) using text editor and find the project_a reference there , replace it with project_b.
Now import the mdl in OWB , objects will coming into project_b.
Thanks all your replies. Finally found another solution which is quite straight forward and it worked for me. I am sharing this if it is useful for u.
1) Go to 'Project Navigator
2) Select the mapping you want to copy
3) right click and select copy
4) select and expand the project in which you want to copy the mapping
5) select the module in which you want to paste
6) right click and select paste
7) save the changes