Loop logic in 7.0
Posted: Thu Mar 15, 2007 12:46 am
I have a set of records coming from the source. For each record I should 6 columns whether any column is NULL. One record should be passed to output if one column is NULL. Suppose if we have all 6 columns NULLfor the same incoming record,then I should pass 6 records( same as source record) to target.
What is the best way to do this.
I thought of having 6 o/p links from transformer and in each constraint, I will checking for one column. So I will be having target stages.
But I think this approach is not correct. Is there any way to this.
What is the best way to do this.
I thought of having 6 o/p links from transformer and in each constraint, I will checking for one column. So I will be having target stages.
But I think this approach is not correct. Is there any way to this.