Generated SQL statement for unused columns
Posted: Wed Oct 10, 2012 6:39 am
I'm using DRS stage as a destination to insert or update data. The problem that it generates insert or update statement for every column at the destination table although they're not defined at job!
Example:
1- table has three columns
2- one column only is defined at the job but generated insert statement for the whole three and it puts DEFAULT for the unused columns.
INSERT INTO STG_ADDRESS
(ADDRESS_NAME,STREET_ADDRESS,STREET_ADDRESS2)
VALUES
(:ADDRESS_NAME,DEFAULT,DEFAULT)
How can I get rid of this and limit the generated SQL for the used columns only especially I'm loading tables with almost 500 columns?
Example:
1- table has three columns
2- one column only is defined at the job but generated insert statement for the whole three and it puts DEFAULT for the unused columns.
INSERT INTO STG_ADDRESS
(ADDRESS_NAME,STREET_ADDRESS,STREET_ADDRESS2)
VALUES
(:ADDRESS_NAME,DEFAULT,DEFAULT)
How can I get rid of this and limit the generated SQL for the used columns only especially I'm loading tables with almost 500 columns?