Unusual date conversion
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
Unusual date conversion
Hi,
My source is a File and contains a varchar field which actually stores date in the basic format YYYY-MM-DD.
In the transformer I didn't use any conversion methods for date conversion since the date is in default datastage format. Well this worked perfectly until I validated the data.
For spaces, some random date e.g 2009-07-28, 2010-05-04 etc is getting generated. What could be the reason for this ?
My source is a File and contains a varchar field which actually stores date in the basic format YYYY-MM-DD.
In the transformer I didn't use any conversion methods for date conversion since the date is in default datastage format. Well this worked perfectly until I validated the data.
For spaces, some random date e.g 2009-07-28, 2010-05-04 etc is getting generated. What could be the reason for this ?
Thanx and Regards,
ETL User
ETL User
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
-
- Participant
- Posts: 117
- Joined: Wed Feb 06, 2013 9:24 am
- Location: Chennai,TN, India
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India