Search found 17 matches
- Wed May 31, 2006 9:44 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Data type from varchar2 to decimal
- Replies: 7
- Views: 3195
Data type from varchar2 to decimal
Hi Gurus, I have a column in my source(oracle) which is of Varchar2 data type.It is a column which has two constant vaues TRUE and FALSE. But in the target(Oracle), same column's datatype is decimal.When i tried loadingi am getting Nulls. Please give your valuable suggestions to overcome this issue....
- Tue May 30, 2006 1:26 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Flat file to be used which has NEWLINE entry problem
- Replies: 1
- Views: 1193
Flat file to be used which has NEWLINE entry problem
I have a flat file and I am trying to load it into a hashed file. The problem I am facing is due to numerous Enter key strokes or new lines made by the data entry guys, resulting in misplaced columns. How should I go about this issue?
thanks in advance
thanks in advance