Problem while updating oracle table through datastage
Posted: Thu Aug 07, 2008 10:40 pm
Hi,
Arrangement_id and Recency_id are there in target table. Arrangement_Id is key column to that table and is populating from source table. Recency_Id is Populating with 0 by hardcoding it in transformer stage.Now Recency_Id is updating with (recency_Id+1) where Arrangement_id=0.
Two server jobs are existing to meet this requirement.
First job: soure-->Transformer--->TargetTable
!---------->hashfile(arrangement_id=0)
Second Job: hashfile---->TargetTable(update TargetTable set Recency_Id=Recency_Id+1 where arrangement_id=0)
Now i want to develop a single parallel job to meet abouve requirement.
I have designed job like:
TargetTable(Lkp)
!
!
Source----->Lkpstage----->Transformer------>TargetTable
In Lkpstage: doing lookup based on Arrangement_id and extracting Recency_id.
In transformer stage: Taken stagevarible with derivation of if Arrangement_id=0 then Recency_id+1 else 0.
and passing this stagevariable to Recency_Id field.
Whenever update happens and Arrangement_Id=0, Recency_id has to increment by 1. But it is incrementing to 1 and 2 only.
Its not incrimenting to 3 or above.
Anybody kindly help me to resolve this issue.
Arrangement_id and Recency_id are there in target table. Arrangement_Id is key column to that table and is populating from source table. Recency_Id is Populating with 0 by hardcoding it in transformer stage.Now Recency_Id is updating with (recency_Id+1) where Arrangement_id=0.
Two server jobs are existing to meet this requirement.
First job: soure-->Transformer--->TargetTable
!---------->hashfile(arrangement_id=0)
Second Job: hashfile---->TargetTable(update TargetTable set Recency_Id=Recency_Id+1 where arrangement_id=0)
Now i want to develop a single parallel job to meet abouve requirement.
I have designed job like:
TargetTable(Lkp)
!
!
Source----->Lkpstage----->Transformer------>TargetTable
In Lkpstage: doing lookup based on Arrangement_id and extracting Recency_id.
In transformer stage: Taken stagevarible with derivation of if Arrangement_id=0 then Recency_id+1 else 0.
and passing this stagevariable to Recency_Id field.
Whenever update happens and Arrangement_Id=0, Recency_id has to increment by 1. But it is incrementing to 1 and 2 only.
Its not incrimenting to 3 or above.
Anybody kindly help me to resolve this issue.