Step:1) Go to Transformer and take two stage variables like sv and sv1
sv1=sourceName sv= if sourceName=sv1 then sv+1 else 1
write this in stage variables and do the hash partition in transformer and take extra column(like Num1) in transformer stage and mapping the sv (stage variable) in that particular column
Ans)
ReplyDeleteFIle----->Tfm---->Filter-------------->2 Target Files
Step:1) Go to Transformer and take two stage variables like sv and sv1
sv1=sourceName
sv= if sourceName=sv1 then sv+1 else 1
write this in stage variables and do the hash partition in transformer
and take extra column(like Num1) in transformer stage and mapping the sv (stage variable) in that particular column
Step2)
and then go to filter stage write two condition
condition1: Where: Num1=1
Output:0
condition2: Where: Num1<>1
Output:1
can be done more easily..
ReplyDeleteJust remove the filter and put condition in the constraints of transformer.