Re: used oracle partition with variable on Talend Data Integration
This is actually not the way how to retrieve data from a partitioned table. You should select the main table with a where clause which use the partition criteria (mostly a date or something like that). I would never try to address a partition directly because you do not have any advancement from it. Oracle take immediately the correct partition of you use a matching where clause. If you try to address the partition directly you have to know what partitions exists and iterate over them. You would do a task what Oracle can do much better and more reliable.