DSXchange

Thanks,

I will try copy stage. At this point there is no need to do anything with BLOB. I just have a new doubt if we want to do some transformation with BLOB how can we split it?

Hi,
Please suggest me how to handle blob column? Its working fine if it is a direct transfer from one table to another table but its throwing error if we use transformer stage. I tried to use to_char(BLOB_Column) but it didn't work out as well. Any input ???

Thanks,

Regards,
Lohith Sama.

Thanks Abhijain,
Could you please provide some more details ? I have datastage on windows server.

Hi,
Is it possible to run a job from an external program like calling a job from Java or from a webpage?

Thanks,

Thanks Ray, One question, I didn't see any difference by selecting key as a partitioning algorithm. Even it returns same rows before also. I used sort stage to sort on key, id and id2 and after that I used remove duplicates. Whats the purpose of using partitioning (hash or modulus) on key. Thank you,

ray.wurlod wrote:Partition by ID. Sort by ID and Pin. Use Remove Duplicates to preserve last record in each group, where groups are defined by ID. ...

Hi Ray,
I can sort id and pin's by using sort stage. How could I get done the partition on ID? Please suggest me.

Thanks,

chulett wrote:Aggregator. Group by the first column, take max() on both of the other two columns. ...

Thanks Chulett,
I am able to group by ID in aggregator state how can I select max() values of pin1 and pin2 ? Please suggest me.

Thanks,

Hi, I have a input like this ID Pin1 Pin2 1 123 0 1 855 1 1 855 2 2 52 0 2 120 1 I need output like this ID Pin1 Pin2 1 855 2 2 120 1 Conditions: Unique ID Pin 1 maximum if you have 2 records with maximum Pin 1 then take maximum Pin 2 Any suggestions? Thanks,

Thanks ArndW. I used filter stage to get the required row.

Hi, I need to get the modified data from source. There is no timestamp at source but there is at target. I am comparing source and target's every column as key in Change Capture stage. But I am getting both previous and current values as two rows. I need only the latest one how can I achieve that? T...

ray.wurlod wrote:Why are you using the Transformer stage? The PXPivot stage can do vertical pivoting such as you require with a lot less effort.

Sure, it can be done with a Transformer stage, but why would ...

Hi Ray,
I am not able to see your message completely.

Sri Vidya, I am getting data from different source. I can't able to use Listagg function. By using pivot enterprise stage and by selecting vertical pivot I am able to do this. But it is asking array size. Array size is not same for all key's and that too I need all the columns data in to one column ...

Thanks Ray,
I am using transformer stage to achieve reverse pivot but it doesn't work for me. I saw so many posts those are based on server jobs and I am looking for parallel (Px) job. Could you please guide me?

Hi all, Can anyone please help me with this issue? Issue: Data in a table is like this Role ID ID2 Var 112627 82839 abcd COPDPI 112627 85899 efgh COPDPI 112627 78209 ijkl PDPI I want to convert it into (descending order by Role) Role ID ID2(var) 112627 [78209],[82839],[85899] ijkl(PDPI);abcd(COPDPI)...

@BI-RMA

Thank you,
Currently I am doing that, I am using stage objects and once if it is successful then I am copying to target from stage objects. I was wondering there is anyway to handle this situation without using stage objects.

Thanks,