I am trying to insert data in to tabel which already has some data from .csv file.
in the oci stage after defining the columns ,if i click view data error is comming for the last column ORA-00904: "PID_TYPE": invalid identifier.
for test if change the columns order then also the error comming for the last column ORA-00904: "DATA_LABEL": invalid identifier
u guys have any idea what's wrong.
thanks for help.
ORA:00904 Error
Moderators: chulett, rschirm, roy
You have to import the table definitions using DS Manager, then load those definitions into the OCI stage. In your transformer, map the incoming values from the file to the equivalent columns in the outbound link going to the OCI stage.
You MUST use the target tables definitions as loaded by DS. Never attempt to 'freehand' metadata, nor assume that metadata doesn't matter. IT DOES. DataStage relies on you using the appropriate metadata, that way it can adjust the data for the source/target.
You MUST use the target tables definitions as loaded by DS. Never attempt to 'freehand' metadata, nor assume that metadata doesn't matter. IT DOES. DataStage relies on you using the appropriate metadata, that way it can adjust the data for the source/target.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Charter Member
- Posts: 199
- Joined: Tue Jan 18, 2005 2:50 am
- Location: India
Its Oracle error,
ORA-00904: string: invalid identifier
Cause: You tried to execute an SQL statement that included an invalid column name or the column name is missing.
Solution: Import proper metadata into your Oracle stage, directly from the DataBase, Instead of free hand typing. As every body has suggested.
ORA-00904: string: invalid identifier
Cause: You tried to execute an SQL statement that included an invalid column name or the column name is missing.
Solution: Import proper metadata into your Oracle stage, directly from the DataBase, Instead of free hand typing. As every body has suggested.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Charter Member
- Posts: 199
- Joined: Tue Jan 18, 2005 2:50 am
- Location: India
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Yep talk2shaanc. You are correct. My words were to be read as the 'alias' used in the tablename not matching that of those prefixed in the column names.
I do not have Oracle here. So it is not possible to try the combination.
The first point of focus must be to make the SQL work (with hardcoded insert values) in any other client such as SQLPlus or TOAD.
I do not have Oracle here. So it is not possible to try the combination.
The first point of focus must be to make the SQL work (with hardcoded insert values) in any other client such as SQLPlus or TOAD.