I have EMPNO,DATE,COUNT columns in my source file and for me the problem is I want to increase my count based on the occurance of the transaction in a particular week for any day.
source file---> sort stage(empno) and create clustered key column is true
--->transformer (check emp no and clustered key column is zero i.e c=c+1)--->target file
It's documented and the name is closer to Key Change Column rather than cluster anything, from what I recall. It will contain a 1 for the first record in the 'key group' or a 0 otherwise.
-craig
"You can never have too many knives" -- Logan Nine Fingers