Problem with flat Files related to date field
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 107
- Joined: Wed Sep 29, 2004 10:15 am
Problem with flat Files related to date field
Hi
Can any one share me the knowledge how to handle date field extracting from flat files.
Here i am getting error like
"Transformer_3: ORA-01830: date format picture ends before converting entire input string"
Actullay my source is in yyyy-mm-dd HH:MM:SS.SSS
target table format is oracle format.
by the conversion functions i am getting the data converted into the format of oracle but it is throwing warning and data is not populating into target table
Thanks inadvance
RK
Can any one share me the knowledge how to handle date field extracting from flat files.
Here i am getting error like
"Transformer_3: ORA-01830: date format picture ends before converting entire input string"
Actullay my source is in yyyy-mm-dd HH:MM:SS.SSS
target table format is oracle format.
by the conversion functions i am getting the data converted into the format of oracle but it is throwing warning and data is not populating into target table
Thanks inadvance
RK
-
- Participant
- Posts: 107
- Joined: Wed Sep 29, 2004 10:15 am
The autogenerated SQL puts to_date functions on your DATE or TIMESTAMP data type columns. If your data matches the format token in the SQL, everything works. I suspect your source data is ready to load, just verify. You won't have to do any DS functions to change the data.
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
Remove "HH:MM:SS.SSS"of the date or change target
Try changing your datetype in the target stage to timestamp. If you don't want the "HH:MM:SS.SSS" part trim the source before loading it into the target.
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: