DSXchange

Thank You All.

I am planing to execute the SSIS package from Execute Command stage and see ...

This is a kind of unique requirement

Please let me know any solutions ....


Thanks
Chilli

Hi All,

How to call SSIS package from DataStage ?


Thanks
Chilli

Hello All, Please help me to Improve the Performance writing the data using with CFF stage . I have designed my job as below. Source DataSet--->Transformer--->Target - CFF (Complex Flat File) This Job processing on Node 4 ,and there are 150 Fields in the Target . It is processing 4400 records per se...

Hi All,

I have source values like 111; I want to convert in to HEXADECIMAL format (i.e F1 F1 F1), please let me know how to convert.

Thanks
Chilli

This is the error i am getting now..

main_program: APT_PMsectionLeader(2, node2), player 45 - Unexpected exit status 1.

Hi All,

I am using CFF stage in PX 8.1. I am able to view the data from CFF stage ,but when i am writing to file i am getting the error below.

APT_CombinedOperatorController(0),0: Fatal Error: Throwing exception: APT_BadAlloc: Heap allocation failed.

Please help me...

Thanks
Chilli

Thanks Sainath... Data format was wrong..now its working.

All, I am trying to extract the data from .dat file. I am getting ASCII Data file from Mainframe and it contains 7 records.I am unable to view 3 records. I am using below selections in Complex Flat File stage in PX Record Type : Fixed Data Format :Txt Characterset :ASCII Can you explain me what are ...

Hi Friends,

Can any body tell me how to avoid warnings in server jobs.

Thanks
Chilli

ray.wurlod wrote:You can get days between two dates (DaysFromDateSince() function). The rest should be arithmetic. However, you need to document your business rules thoroughly, and will probably need a custom functi ...

Thanks Ray

Hi Guys,

How to get duration of Months ,Days And Years Between 2 Dates.Example i have requirement like : start date 09/01/2008, expiry date 01/05/2009.

Please help me...Thanks

Chilli

Hi,

Is any one worked on Pivot Stage-Vertical ?

Please let me know on which version you worked and how to do Vertical Pivoting.

Thanks
Chilli

Hi All,

Can any body used SAP IDOC pack , please tell me how to use and what IDOC objects were used from R/3 to Datastage.

Please help me ..

Thanks,
Chilli