topic Re: used oracle partition with variable on Talend Data Integration in Talend Studio

used oracle partition with variable on Talend Data Integration

Anonymous — Tue, 17 Dec 2013 19:54:31 GMT

Hi xdshi,
I'm new on Talend and I would like to query a Big Oracle Table by using partition name with variable
How I can do that.
thanks in advance.

Re: used oracle partition with variable on Talend Data Integration

Anonymous — Wed, 18 Dec 2013 02:11:54 GMT

Hi,
Is there any case/example for your requirement? More information will be preferred.
Here is related forum about oracle partition https://community.talend.com/t5/Design-and-Development/resolved-Manage-Partition-Truncate-Partition/td-p/109747
Best regards
Sabrina

Re: used oracle partition with variable on Talend Data Integration

Anonymous — Wed, 18 Dec 2013 11:30:01 GMT

Hi,
I want to run this below query on Talend by using variable instead of putting the name of the partition:
select * from USAGE partition (D20131211_USG)
how it's possible ?
thanks

Re: used oracle partition with variable on Talend Data Integration

Anonymous — Wed, 18 Dec 2013 11:37:19 GMT

for example how I can proceed if I need to query the table partition per partition and insert the data to another table in
Talend Data Integration

Re: used oracle partition with variable on Talend Data Integration

Anonymous — Wed, 18 Dec 2013 20:26:00 GMT

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.