• Add a Comment
  • Edit
  • More Actions v
  • Quarantine this Entry

Comments (4)

1 siva sundeep bairu commented Permalink

Tony, post was good. Think we can check the LastRowInGroup in next 3 Stage varaibles and set them accordingly. Also we can have single SV for total value.


2 Deepti Ramachandran commented Permalink

Hi Tony,

The information in the blog was useful. I had a couple of questions though.
1. When will the transformer cache be cleared? After every group?
2. Here a single column defines a group. When my input data has ProdCategory and ProdSubCategory, I have hash partitioned on both these columns and specified LastRowInGroup(ProdCategory). Then I expect the function to return TRUE only when there is a change in ProdCategory and it needs to ignore the changes in ProdSubCategory. But, this is not happening. Even if I mentioned the primary hash key to the LastRowInGroup function, it detects changes to the secondary column as well. Is this expected?

3 Devi Priiya Deepak commented Permalink

Hi Tony,
I have a small clarification reg looping implementation in Transformer stage. Can we set @iteration value other than 1?
For instance, i need to loop the data between two columns start=10 and end=40, here if i use @iteration parameter, it is giving output as 1, 2, 3, 4..... 40.. But expecting value is 11, 12, 13.. 40. Could you please share your comments to set @iteration value to other than 1.


4 Rahul Tirumala commented Permalink

Very nice and clear post. Thank you.

We can remove 2 of the variables.
1) IsBreak : Where ever we have used it we can replace it with "LastRowInGroup(DSLink2.ID) or LastRow()"
2) RowAtBreak : We can remove this variable and change the loop condition to "@ITERATION <=NumSavedRows and (LastRowInGroup(DSLink2.ID) or LastRow())"

Add a Comment Add a Comment