Partition Issue

[srini.dw]

Hi Guys,

The job design is

Code: Select all

                               Seq
                               | 
                               v
DataSet -> Column_Generator -> Lkp -> Copy -> Oracle connector

When I run the job in 2 nodes, Iam getting the count matched between src and target.

But when running the job in 1 node, the count is coming less.
Partition I have kept Same in all the stages. Lkp reference is kept as Entire.
Key columns in Oracle connector are ID, AEID, ECODE.
Key column in dataset is ArchiveID.

Any thoughts or help would be appreciated.

Thanks,

[ArndW]

If you view the performance statistics in your DataStage developer, where are the row counts shown different? Are you losing the rows in your lookup stage or elsewhere? Also, what is your action the lookup stage for unmatched rows?

[srini.dw]

Thanks for the reply.

In the Oracle connector, update query was not correct, have corrected it and re-run the job. Its working fine now.

Thanks,