Input_Lnk
Parent_code child_code CHILD_SK PARENT_SK
00.1 1
ABC.20 ABC 2
ABC.20 CDE.20 3
ABC.20 EFG.20 4
BDE.20 ABC.20 5
I am using stage varaible to get parent_sk like below
in stage varaible i said
Input_Link.child_code StageVar
In Transformer to populate PARENT_SK i said
IF (Input_Lnk.Parent_code= StageVar) THEN Input_Lnk.CHILD_SK ELSE 1
i am getting all parent_sk as 1
i should have get
Parent_code child_code CHILD_SK PARENT_SK
00.1 1 1
ABC.20 ABC 2 5
ABC.20 CDE.20 3 5
ABC.20 EFG.20 4 5
BDE.20 ABC.20 5 5
stage variable question
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
Parent_code child_code CHILD_SK PARENT_SK
00.1 1
ABC.20 ABC 2 null
ABC.20 CDE.20 3 null
ABC.20 EFG.20 4 null
BDE.20 ABC.20 5 null
Code: Select all
Parent_code child_code CHILD_SK PARENT_SK
00.1 1 null
ABC.20 ABC 2 5
ABC.20 CDE.20 3 5
ABC.20 EFG.20 4 5
BDE.20 ABC.20 5 null
StageVar:
Input_Link.child_code StageVar
Transformer:
IF (Input_Lnk.Parent_code= StageVar) THEN Input_Lnk.CHILD_SK ELSE 1
i am getting all parent_sk as 1
stage variable question
Based on the way I understood your question and input data, no Parent Code is matching with Child code, so it goes to ELSE part of your code and prints 1 which is correct.