Compilation error : Job contains cyclic or linear dependenci
Posted: Tue Jan 26, 2010 3:30 pm
http://picasaweb.google.com/dganeshm/DS ... 0178227890[/img]
Please see the URL above to see the design of the job. What I am trying to do is that ..
DSLink32 will give me the total number of rows passing through it, for which I am DSLinkRowCount in the transformed (Transformer_27) and use the Max function in the aggregator , call it TOT_COUNT
DSLink44 has a constraint : I am trying to get the number of rows which will satisfy the contraint, and use the @OUTPUTROWNUM and followed by MAX in the aggregator, call it MATCH_COUNT.
And these two counts , should now be loaded into a single table as a single record, so I am try combine the output of these aggregators, since aggregator doesn't support reference link , I tried to use a Hashed file stage and then give it as input to Transformer, but am getting a compilation error...
Can someone help me with this, is there a easier way to do this..
Please see the URL above to see the design of the job. What I am trying to do is that ..
DSLink32 will give me the total number of rows passing through it, for which I am DSLinkRowCount in the transformed (Transformer_27) and use the Max function in the aggregator , call it TOT_COUNT
DSLink44 has a constraint : I am trying to get the number of rows which will satisfy the contraint, and use the @OUTPUTROWNUM and followed by MAX in the aggregator, call it MATCH_COUNT.
And these two counts , should now be loaded into a single table as a single record, so I am try combine the output of these aggregators, since aggregator doesn't support reference link , I tried to use a Hashed file stage and then give it as input to Transformer, but am getting a compilation error...
Can someone help me with this, is there a easier way to do this..