Problem with Datatype

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ramu1
Participant
Posts: 14
Joined: Mon May 12, 2008 12:47 am

Problem with Datatype

Post by ramu1 »

Hi Experts,

As i am extracting the data from my Oracle source (used DRS stage) to my
target table (Oracle,DRS stage) for varchar fields, i am getting NULL values .

And if i am extracting the data from my Oracle source (DRS stage) to my
target (Sequential file) , I am getting first value of the field.

Can you please suggest me an appropriate solution for above specified Issues.

Thanks in Advance,
Ramu.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Issues, plural? Not without a great deal more detail about them. 'Getting NULL values' isn't necessarily an 'issue' unless you explain to us why it is, what transformations you are doing, stages between the DRS stages and what errors you are seeing. Also please don't make us guess what 'first value of the field' means, me I have no idea and am unwilling to speculate. Details!

Examples are always good to help illustrate things like what you are expecting versus what you are actually seeing.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply