For one column dattype is varchar and data is like 2008-10-20k , after transformer 5 records are rejecting, but from source(seq stage) all records are coming , m getting warning
APT_CombinedOperatorController(1),0: Data string ' ' does not match format '%yyyy-%mm-%dd': an integer was expected to match tag %yyyy.
data string does not match format
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 59
- Joined: Wed Dec 31, 2008 5:49 am
Re: data string does not match format
Raviravireddy25 wrote: 2008-10-20k
what is that K for??
did you try looking through your source data to figure out any abnormality?
does it look fine there.
if your row count on the source is lesser than 9999 are you able to view data on the source file through datastage?
cheers
VM
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Is the "k" date suffix meant to be part of the data or is it erroneous? You have to process it in either case.
Disable operator combination to learn the actual source of the error.
Disable operator combination to learn the actual source of the error.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.