DSXchange

Iam using a RCP for a Change capture stage. Based on the Chagne_Code decide what should go to the Action flag (A_FLG) column. ('Add','Delete','Copy' etc) in transformer. Action flag columns is present in both inputs. I get this warning in the Transformer, when I try to assign the value to the Column...

Thanks AndrW! It worked!.

Hello, This might have been discussed already. But I couldn't find anything close to my need. I have the following. "|||abc|||def|hg" I wanted it to be converted into "abc|def|hg" I think I can remove the leading and trailing Pipes using Trim with 'B". I have remove the dupl...

There should be some simple method or direct function available for sure, which Iam not able to find it readily. I can always go with If-Then-Else. But wanted to check, for other optimized options. If there is any negative number, I expect 0. Any positive can be send to the output directly. Eg: -2 -...

Thanks Prasoon!

Does it mean, it will not sort the grouped (Partitioned) data?

I just partitioned, say 5 fields in previous stage. I need to sort 5+1 fields now. Can give Sort for the new filed and Dont Sort (Previously Grouped) for the rest of the 5 fields?

Tried searching the forum but not able to find the exact answer Iam looking for. I need to know, what is " Dont Sort (Previously Grouped) " mean? What I understand is, if the keys are partitioned in some of the previous stages, this mode will be the right option for those. So I can specify...