DSXchange

Hi Team,

we have a difficult scenario. please help us.

Input:

Key colmn1 column2
1 A X
1 A Y
1 B Z
1 B Z




Output :

Key Col1 Col2
1 A,B X,Y,Z

Hi, My Dimension ID from teradata table is varchar38. I have to find the max(dimension ID) in aggregator stage I am converting varchar38 to decimal38 in transformer, and doing max(dimensionID) in aggregator stage. after the agg stage, My output is coming as some junk integer. I tried stringtofloat.....

THank you, I used the system variable in transformer stage @INPARTNUM which gives the partition number for the partition keys, al dept10, dept20 values are assigned partition number as 1. So, I am not able to understand this ?

Could you please explain chulett, thank you

Thank you all for replying. I have my default config. File as above with two nodes, I did not select any node constraint option in my job( it means running on all available nodes). I gave system variable @partition number to an output column, I only see partition '1', for dept 10 and 20 values, I am...

Hi, A default configuration file running on a windows PC with one CPU usually has one node. Can we split that into two nodes by giving something like below? if i have key column value deptno with values like below, will hash partition sends dept 10 values on one node and dept 20 values on another no...

Thank you very much, Thanks a ton

DSXchange members helped me a lot.

Thanks again.

Thanks Chulett,

how will i know what the first record is, so i can have a different value for previousvalue? is there any technique? please let me know

Thank you all for replying,
so, when comparing the values in transoformer,
for the first incoming row to transformer, the initial value for the "previousvalue" should be assigned something that will not match with the first incoming row.

Am i correct? Please let me know. Thanks.

Thanks for the reply. I got the output correct with the below formula. Intial value = 0 for IsDup Initial value =0 for currentvalue ( which is different from firstvalue in source) If DSLink2.deptno = currentvalue then 1 else 0 = IsDup DSLink2.deptno= currentvalue. but, i do not want to initialize cu...

Could you please tell me the logic how to compare two values in transformer?

Please tell me the logic, I am not able to get it, thank you

Thank you for clarifying, But what initial value should I put in for the previous value?

Ray, Chulett told me to switch the order of the stage variables, so i put it as now i gave as If DSLink2.deptno = Lastvalue then 1 else 0 = Isdup DSLink2.deptno= Lastvalue constraint : Isdup=0 i still not able to remove duplicate values? could you please help? to remove the duplicate values, the com...

can anyone please let me know the logic to compate two values using stage variables?

col1

100
100
200
300
200
400

what will be the initial value of the Lastvalue in the below logic?

If DSLink2.deptno = Lastvalue then 1 else 0 = Isdup
DSLink2.deptno= Lastvalue

constraint : Isdup=0