Search found 17 matches

by vivek
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....
by vivek
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