Error with Oracle connector stage
Posted: Tue Apr 12, 2011 12:39 pm
Hi
I need to add new column(Today_Day)(field type is Date) in transformer, I am using CurrentDate() fuction.
This column (Today_Day) is not available in the source file.
(Today_Day) type is Date I specified in the transformer
In the target oracle table (Today_Day) filed type is Date.
I am using Oracle connector stage to load the data
Write mode is INSERT
Generate Sql At Run time
Data is not loading into oracle table
Ds job is running fine but displaying error in Director is below
Oracle_Connector_1,0: [IIS-CONN-ORA-001060] The input schema column Today_Day is not used and the connector is configured to stop when unused columns are detected in the input schema. (CC_OraUtils::matchDataFields, file CC_OraUtils.cpp, line 6,377)
Can someone can suggest me
Thanks
Srini
I need to add new column(Today_Day)(field type is Date) in transformer, I am using CurrentDate() fuction.
This column (Today_Day) is not available in the source file.
(Today_Day) type is Date I specified in the transformer
In the target oracle table (Today_Day) filed type is Date.
I am using Oracle connector stage to load the data
Write mode is INSERT
Generate Sql At Run time
Data is not loading into oracle table
Ds job is running fine but displaying error in Director is below
Oracle_Connector_1,0: [IIS-CONN-ORA-001060] The input schema column Today_Day is not used and the connector is configured to stop when unused columns are detected in the input schema. (CC_OraUtils::matchDataFields, file CC_OraUtils.cpp, line 6,377)
Can someone can suggest me
Thanks
Srini