DSXchange

Hi Devesh, I have tried your scenario.The desired output can be achived through the help of a datastage job sequence and a parallel job. The steps are as below- In job Sequence- 1. Execute command1- cat PathName/FileName | nawk -F"|" '{print $1}' | sort -u | wc -l The above command will op...

In that case, as Ray suggested it is possible through range lookup available in the latest version.

Hi Informdaya, I have tried the above scenario by taking two transformer, one after the source and another after the reference.In both the transformer stage I have used following steps- 1. Stage variables- StgVar1=Seq(Field(InputColumn,"-",2,1)[1,1]) StgVar2=Seq(Field(InputColumn,"-&q...