I have a problem with my lookup logic. I am not able to implement the lookup logic in the job. The lookup code is given below.
In that code i have two sourcesLookup OU to get OU_ID by condition
If Mid(FI_HOST_YYYYMMDD.TO,6,3) = 'นท.' Then
Concatenate('บน.', Concatenate(Mid(FI_HOST_YYYYMMDD.MORP,2,1), '.', Right((FI_HOST_YYYYMMDD.MORP),1)) ) = OU.ALS_NM1
and Right((OU.ALS_NM1),1) <> '.'
Else
Concatenate( '(', Mid(FI_HOST_YYYYMMDD.TO,6,3), ')' ) = Right((OU.ALS_NM1),5)
End IF
1) FI_HOST its a file
2) OU its a table.
The output of this logic(OU_ID) goes thru Hashed file into Trnsf stage. Please help me how to develop this logic in DataStage Server job.
Thanks in advance.