This content has been marked as final. Show 4 replies
I believe you canot use them as they are intended to be used inside KM.1 person found this helpful
already documented here. http://docs.oracle.com/cd/E14571_01/integrate.1111/e12645/odiref_reference.htm
Hi,1 person found this helpful
Use a variable as your resource name in your datastore, then refresh this variable , or pass it as a start up parameter, this gives you dynamic source / target object names, only really works if you have the same set of columns across all your iteration you want to run it for though.
This was really informative,that target and source datastores can be a variable,I never knew that.
But as u said ,iterations cannot be possible with this ,since its certain that the structure is not going to be same.
I had gone through this document,and from other sources also got a same answer that it cant be used.But is there a way it can be done?
Actually we have many number of the small tables with just 10 records to be brought into the warehouse.The idea is to instead of doing it via an interface , why not try with a control table with an just the relevant entries and a procedure as above posted code.
Some ideas would help.