Date conversion when using Oracle Enterprise stage as Target
Posted: Fri Mar 26, 2010 3:57 am
My target is Oracle 10g database.Here is the code snippet.
Dataset----->T/F------->OracleEnterpriseStage
I have a varchar field from input dataset which is to be loaded as Date in Oracle target.
1)I kept StringToDate(<lnkname>,"%yyyy-%mm-%dd") in transformer---All records are rejected silently with job finish status
2)I inserted user-defined query with TO_DATE(orchestrate.<lnkname>,'YYYY-MM-DD').-----Job aborted with error 'ORA-1858: a non-numeric character was found where a numeric was expected'----
3)I removed date conversion and made query as Auto-generated----Records rejected
I tried with ODBC connector but no luck
Remaining tables which doesn't have any date fields in the tables are loading perfectly.
Are there any limitations for OracleEnt stage?Which is the better stage(ODBC Connector or Oracle EE) for loading the date fields without any contention?
I have gone through some posts relavant to the problem but I couldn't find solution.
Please advice.
Dataset----->T/F------->OracleEnterpriseStage
I have a varchar field from input dataset which is to be loaded as Date in Oracle target.
1)I kept StringToDate(<lnkname>,"%yyyy-%mm-%dd") in transformer---All records are rejected silently with job finish status
2)I inserted user-defined query with TO_DATE(orchestrate.<lnkname>,'YYYY-MM-DD').-----Job aborted with error 'ORA-1858: a non-numeric character was found where a numeric was expected'----
3)I removed date conversion and made query as Auto-generated----Records rejected
I tried with ODBC connector but no luck
![Sad :(](./images/smilies/icon_sad.gif)
Remaining tables which doesn't have any date fields in the tables are loading perfectly.
Are there any limitations for OracleEnt stage?Which is the better stage(ODBC Connector or Oracle EE) for loading the date fields without any contention?
I have gone through some posts relavant to the problem but I couldn't find solution.
Please advice.