I have a table which has multiple partions and these may increase in future too. Now I want it to use in ODI 12c interface, But till ODI11g we need to reverse engg. only with specified partition No. using RKM and we will use same specified parition No. in interface property window.
But Now I want to read the data from a table based on the partition No. Which I will pass at run time by using variable.
How can we do this please let me know