Aggregator Output
Posted: Tue Dec 15, 2009 8:57 pm
Hi,
I have a job design as follows.
Database--------->lookup------->Xfm1---->aggregator-------->TRGDatabse
In the Xfm1 stage I put a dummy row called Key_Col and default the value to 1. In the aggregator stage I group by the Key_col and count the rows and insert it to the TRGDatabse. Every thing works fine except when I have no records from the input. When the lookup results in no result I need to insert count = 0 in the TRGDatabse. I have tried different options in Aggregator stage but I have not been able to handle this scenario. What is the best way to handle this?
I have a job design as follows.
Database--------->lookup------->Xfm1---->aggregator-------->TRGDatabse
In the Xfm1 stage I put a dummy row called Key_Col and default the value to 1. In the aggregator stage I group by the Key_col and count the rows and insert it to the TRGDatabse. Every thing works fine except when I have no records from the input. When the lookup results in no result I need to insert count = 0 in the TRGDatabse. I have tried different options in Aggregator stage but I have not been able to handle this scenario. What is the best way to handle this?