DSXchange

1. What level of 'user defined' are you looking for? Depending on your definition, it could be almost every stage, almost no stages or anything in between. 2. There is very little we can do with just 'some warning error'. If you would like more help, please post the full contents of the specific err...

I'm curious too what the need is for just getting the top three by LOCATION, DEPT. It does sound like reporting, which - as said above - is done better by other tools designed for that purpose. If you must do it in DS, there are multiple ways to go about it. For instance: Sort by LOCATION (asc), DEP...

<duplicated>

Sort the data by using sort stage(join key column) and derive the key change column. Have a constraint (keychangecolumn=0)in transformer before writing the dataset. We can avoid one-to-many relationship. The other option is to sort and remove duplicates on the lookup stream prior to performing the ...