IKM Oracle Multitable Insert with Filters:
Today we are going use IKM Oracle Multitable Insert with filters. This is normally used to load data from one source to multiple target table. Thanks to OdiExperts.com team for writing a beautiful article on this.
Well I got to know from the comments section that many people are interested to implement their own filters in interace with the IKM Multi Insert. Now if you will add filter to each of interface, do you think it will work out? Nope 🙂 . The process will load correct data to 1st target table but not to the rest tables. Why is it so ????
Lets apply a small trick.
Source table: EMP
Target tables: EMP_TGT1,EMP_TGT2,EMP_TGT3
Create following interfaces as given.
LKM: if required select desired LKM
IKM: IKM Oracle Multitable Insert
CKM: CKM oracle
Reverse engineer all 4 tables and do the normal mapping.
Now create a package and connect them sequentially. Next run the the package.
As you can see there is one filter in the select query which is the filter in 1st interface. Here it wont select data for rest interface. Any how we need to delete this filter so that it will select all data and it will use respective filter at the time of loading.
Duplicate your IKM oracle Multitable Insert. Then go to the Define Query tab. Now scroll down and remove the filter (Query.append( odiRef.getFilter(i) +nl);) as given in screenshot and then save it.
Now execute your package.
Now you can see the data loaded to corresponding target table as per your filters respectively.
Thats all for today 🙂
Comments are welcome.