record not in output

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
dnat
Participant
Posts: 200
Joined: Thu Sep 06, 2007 2:06 am

record not in output

Post by dnat »

Hi,

I have the job design like this

input file-->aggregator1-->aggregator2-->join1

inputfile2-->join1

the above two are joined in join1 stage

when i check the monitor it shows that the output is coming out of aggregator 2, but as the input of join1.

in the log it is not showing anything that it is dropped.

what could be the reason.
Pagadrai
Participant
Posts: 111
Joined: Fri Dec 31, 2004 1:16 am
Location: Chennai

Re: record not in output

Post by Pagadrai »

dnat wrote: when i check the monitor it shows that the output is coming out of aggregator 2, but as the input of join1.
in the log it is not showing anything that it is dropped.
Hi,
can you explain more clearly the quoted sentence.
Also, check if you have any warnings in the log.

Cant help much as the problem is unclear.
dnat
Participant
Posts: 200
Joined: Thu Sep 06, 2007 2:06 am

Post by dnat »

In the director monitor, when i check for each stage


aggregator2-- >>Out dslink2 shows count 1
join1-- <<In dslink2 shows count 0

ideally aggregator2 ouput is join1's input and both should be same right.
Pagadrai
Participant
Posts: 111
Joined: Fri Dec 31, 2004 1:16 am
Location: Chennai

Post by Pagadrai »

Hi,
can you explain what are the columns that you are using to join the two inputs ?
Are there any matching records in your two sources to start with ?

Instead of seeing the director, please tell us your problem in terms of logic rather than the record count.
Post Reply