DSXchange

Then what stage I have to Use to get the answer?

If Col3_1 and Col3_2 cant be summed Because they are Strings then How to achieve the Output using Aggregator?

Do you want a concatenated string for Col3_1 and Col3_2?

No I don't want to Concatenate the Columns, Need to sum it. Is there any options to do that in Aggregator?

Hey Friends, I have an Input File as follows; KeyID EmpId1 EmpId2 Col3_1 Col3_2 101 1043 0 A 0 101 0 1059 0 B 101 0 0 0 0 101 0 0 0 0 102 0 0 0 0 102 0 0 0 0 103 1043 0 Y 0 103 0 0 0 0 104 0 1059 0 Z 104 0 0 0 0 104 0 0 0 0 104 0 0 0 0 Using Aggregator Stage I mentioned; 1. In the group - KeyID 2. I...

How to change normal Lookup to Sparse Lookup?

Hi friends, My Input Source Id,Name,Age A1307420,Arun,25 A1307421,Venkat,26 A1307422, ,27 In the third row Second column I have a Space which is a null value, I need an Output as follows Using Transformer stage especially using Null handling functions like Isnull, Isnotnull, Nulltovalue, etc. Id,Nam...

Hi friends,

What is the use of Pools in configuration file and how to assign it?

Thanks in advance..

Regards,
Rajasingam

Hi.
Is it possible to take a reject in parallel transformer?

Thanks in advance,

Rajasingam