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
Error with Oracle connector stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 38
- Joined: Sat Dec 29, 2007 9:58 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I'm trying to do an update to a table but the transformer that is before the Oracle Connector stage does not receive data (because a constraint in a transformer stage) so the job fails and shows the next error message:
The input schema column ALL_VEH_CNT 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,464)
It is correct to do not let pass data in the transformer stage but I want to end the job without error messages and I have not seen the option in the "Usage section" for uncheck or something to avoid this errors.
Please, could you be more specific Ray.wurlod?
Thank you.
Regards,
The input schema column ALL_VEH_CNT 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,464)
It is correct to do not let pass data in the transformer stage but I want to end the job without error messages and I have not seen the option in the "Usage section" for uncheck or something to avoid this errors.
Please, could you be more specific Ray.wurlod?
Thank you.
Regards,
Re: Error with Oracle connector stage
Hi,
In the connector there is option under properties. "Drop Unmatched fields" select this to yes.
Thanks,
Chetan.C
In the connector there is option under properties. "Drop Unmatched fields" select this to yes.
Thanks,
Chetan.C