Page 1 of 1

DATA STAGE

Posted: Sun Mar 25, 2007 6:32 am
by dsonly
Good Morning every one

i facing a stange thing in a server job,

there is a sequence job running properly but as inserting to the target table the first raws values inserted properly while the other raws values inserted as zero's value

pls any friend has an explanations for that reply

thanks

Posted: Sun Mar 25, 2007 8:11 am
by ray.wurlod
The only possible explanation is that whatever you are doing is inserting the zeroes.

With such a vague description (and even vaguer subject) it is impossible to diagnose more accurately than that. The computer does precisely what your programming tells it to do.

Therefore, if you need more focussed help, please outline the design of your job, what stage types you are using, and especially what transormation expressions you are using.

Draw a "picture" of your job design enclosed in Code tags. For example:

Code: Select all

SeqFile ----->  Transformer  ----->  Oracle
                    ^
                    :
                    :
                HashedFile

Use the Preview button until you get it correctly aligned and formatted, then submit.

Posted: Sun Mar 25, 2007 8:12 am
by chulett
Any explanations from that? Err... no. :?

Sequence jobs don't insert data into tables. We'd need to know a lot more about the nature of the Server job it runs that actually does the dirty work and a better explanation of your problem. So, job design? Target, source? What are your 'raw' values?

In other words, there's not nearly enough information for anyone to help you without taking total guesses. And please work on your thread subjects - 'DATA STAGE'? What else would we talk about here? Leprechauns? :wink: