DSXchange

Finally it works perfectly now.
Thanks for everyone who had input for this topic.

If anyone in future wants to know the exactlly steps, I could post those in the forum.

Thanks,

Thank you, everyone for your input. This case has been solved in single node only which means the input data has not properly partitioning in term of leting all grouped data in same partition. I have to modify the job and give the proper partition set up. Anyway, thanks for everyone's help and will ...

Thanks, Chetan. This issue has been solved. It has taken too long to solve this case. Because I have never realized that it needs only ONE node for the job. I also added more stage variables. Is it possible to to use mutiple nodes instead of one node? Does anyone know why can not use mutiple nodes? ...

Thank you very much for your reply.
Do you have any sample of

Use KeyBreak detection logic using stage variables to concatenate DESC field and use lastrowingroup function to get the last row.

Thanks,

Thank you, James.

You are right.
Both ways are good for this case.

I have done key break detection method and also Loop for horizontal pivot but not Vertical pivot.
Do you have any sample of this vertical looping?

Thanks,

Hi There, I have a request of produing outputs from inputs both listed below. The key columns for source is the first 3 columns and the target is first 2 columns. Indeed, I don't know how Seq_Num could be, some cases it is over a thousand. I think the solution for this case is to use Loop in Transfo...

Old topic, but just stumbled upon this when searching for a resolution to the same problem. I found a different / better solution for our purposes though. Since DS chokes on the DB2 date on attempted load, I found that this 'fixed' the issue for me... Within the DB2 query I placed this: SELECT CASE ...