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

Comments (3)

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.

 
Thanks
Priya.

Add a Comment Add a Comment