Hi,
Sorry if this is a repetitive post, I have searched and couldn't find any thing.
I have a situation where I am extracting data from Oracle table with more than 200 columns and loading into an another Oracle table with same structure. I need to select all the columns. I have to do some transformation before loaind the data. I am facing an issue in defining more than 200 columns in SELECT Quey as well as INSERT Query (the column definition in Oracle Conector Stage). Is there any way:
> to define the columns in a better and faster way
> Can I use SELECT * function to select all the columns and dynamically define the columns in the table?
Thanks
Yugee.
Oracle Tables with many columns
Moderators: chulett, rschirm, roy
Look into Run-time Column Propagation (RCP) in the Parallel Job Developer's Guide.
It allows you to read a table using SELECT * without defining the column names in advance. You can reference the columns you DO want to modify at any time. When you output the table it will write out ALL the columns even if you have not explicitly defined them.
It is VERY useful for tables with numerous columns. RCP must be enabled by the Administrator for the project before it will work. I do NOT recommend making it the default for all links (another option) because that can cause issues.
It allows you to read a table using SELECT * without defining the column names in advance. You can reference the columns you DO want to modify at any time. When you output the table it will write out ALL the columns even if you have not explicitly defined them.
It is VERY useful for tables with numerous columns. RCP must be enabled by the Administrator for the project before it will work. I do NOT recommend making it the default for all links (another option) because that can cause issues.