DSXchange

Hi All, I've designed a job which handles 80 million data.The jod design flow is as mentioned below Oracle(Source) --> Transformer --> Sort --> Aggregator --> Oracle(Target) As of now the job is taking 31 Minutes for execution. The business logic involved in this job is,the transformer assigns value...

Thank you

Regards,
Balakrishna

please explain me in detail where actually in aggregator stage do we have the option

Hi all,
Can we perform Max function present in the Aggregator stage on the Varchar data.If so please explain me the procedure how to preserve the datatype as the output datatype of a Max function is Double by default.


Regards,
Balakrishna

Please correct me if i' wrong

All the columns have data types as Varchar and when i use them in Aggregator the output of Max is of datatype double.Do we have any data type preservation technique in Aggregator

Can you please explain the same in detail

ok fine here goes the requirement I have a key column (KEY1 and KEY2).For a particular record only one value exist under a single column.I need to group the records based on the key column(KEY1) and we need to merge the multiple records for that particulat Key column to a single record with the Colu...

Hi all, I have a requirement which needs to be handled in the datastage. i/p KEY1 KEY2 COL1 COL2 COL3 COL4 COL5 COL6 COL7 1 1 NULL NULL NULL MFS NULL NULL NULL 1 2 A7C NULL NULL NULL NULL NULL NULL 2 1 NULL MFG NULL NULL NULL NULL NULL 2 2 NULL NULL XXX NULL NULL NULL NULL 2 3 NULL NULL NULL NULL IP...

I've searched using the Vertical Pivot literal but there were many threads,where everyone is replying to search for the topic as it was already discussed many times,but i couldn't really find one which solves my logic.I found a solution where the number of records per key are fixed but that's not th...

I've searched using the Vertical Pivot literal but there were many threads,where everyone is replying to search for the topic as it was already discussed many times,but i couldn't really find one which solves my logic.I found a solution where the number of records per key are fixed but that's not th...

Will you please explain how to acheive the Vertical Pivot logic using the Datastage.

Hi all, I have a requirement to convert the rows present in a source table to Columns. For ex: Id Name Value 1 Jhon 3 1 Sam 5 2 Serena 1 2 William 7 2 Jose 9 3 Paul 5 3 Fedy 4 and the required output is **1st record** Id Jhon Sam 1 3 5 **2nd record** Id Serena William Jose 2 1 7 9 **3rd record** Id ...

Hi, I'm getting an error in the transformer as mentioned below. "TRANS_WORKORDERID,0: Operator terminated abnormally: received signal SIGSEGV" Where TRANS_WORKORDERID is the name of the Transformer. Please throw some light on the details of the error and why it occurs. Regards, Balakrishna

Thank you Teja.It's working