Datasets in ODI12c
Hi,
I have 3 data sets (union all) in oracle Procedure form and i need to convert those 3 data sets into Mappings in ODI12c with necessary transformations. Here i have a question
1) I want to cut down 3 data sets into one data set in ODI mappings so what is best approach i can follow. Can we create reusable mappings with original mapping and use that reusable mappings into one mapper.
Please help me in understanding best approach in order to minimize the 3 data sets into one data set in ODI.
Thanks,
Pavan Kumar