DSXchange

Hi All,
When data is getting copied from table to hashfile its exceeding more than 2GB capacity because of which ds job is failing.
Can you please let me know how to increase 2GB size.

Thanks in Advance,

I have the date value in the oracle source database table for the column(varchar datatype) I have value either as "0000/00/00 00:00:00" or "00/00/00 00:00:00". When I select these records and try to insert into a target database table when I try to insert into the column(date dat...

using pivot stage which column i need to take as key column

source file is like this: EMPID~cpframeA~cptypeA~cpformatA~cpisleA~cpliteralA~cptermA~cpframeZ~cptypeZ~cpformatZ~cpisleZ~cpliteralZ~cptermZ~lpframeA~lptypeA~lpformatA~lpisleA~lpliteralA~lptermA~lpframeZ~lptypeZ~lpformatZ~lpisleZ~lpliteralZ~lptermZ~tryframe~trytype~tryformat~tryisle~tryliteral~tryter...

Can you please give me an idea how to use the triggers in my job design for datastage server?

I am running job in Datastage server 7.5 version Table_lookup Stage: select Column1,Column2 from tablename; SequenceOracle Stage: select seqname.nextval as Column1 from dual; SequentialSourceFile--------> Trans1 Table_lookup Stage-------->HashLookupFile------->Trans1 SequenceOracle Stage -----------...

I am getting the following error when i run the job in datastage: when i run for 10 records its processing fine but when i run for 40 records its throwing me the following error: DataStage Job 923 Phantom 10979 Program "JOB.121662655.DT.1515019057.TRANS2": Line 65, GCI subroutine called wi...

My xml looks like below: <soap> <orderid>AB1234</orderid> <orderdate>20090808</orderdate> <eDateLst> <eDate><name>ABC</name><value>20090817</value></eDate> <eDate><name>CDE</name><value>20090827</value></eDate> <eDate><name>EFG</name><value>20090837</value></eDate> <eDate><name>GHI</name><value>2009...

when i am trying to run with multiple links for the xml tags like : <servicechar><name>AAA</name><value>111</value></servicechar> <servicechar><name>BBB</name><value>222</value></servicechar> <servicechar><name>CCC</name><value>333</value></servicechar> <servicechar><name>DDD</name><value>444</value...

I am running the DS jobs in Datastage server 7.5 version. If i am running for one xml record, then I had put the interprocess stage before entering into the XMLInput Stage but the output of xml input stage goes into three different links with different logics and at the end i need to do lookups on t...

Hi,
But I need to split the xml record coming in a sequential file into different fields based on xsd structure and put into a sequential target file.
Is there any other way of processing xml record?

I am not doing Validation in xml input stage. It was unchecked earlier only. I used Interprocess stage between sequential file and xml input stage like: SequentialFile----Interprocess----Transformer------Interprocess-----XMLInputStage-----. from xml input stage I am passing to three different with t...

I have a sequential file with 50000 xml records in it. I m splitting the xml tags into columns and putting into a sequential file like Sequential file------XML input stage----transformer---target sequential file. Its taking me more than 5hours to process. Can you anyone let me know how can I improve...

I have done validation part including xml stage component also. but when i read this eDate tag i m getting 2 rows and i need to merge these 2 rows into a single row for processing.

I get an single xml with name tags as below: <eList> <eDate> <name>AAA</name> <value>20090613 00:00:00</value> </eDate> <eDate> <name>BBB</name> <value>20090614 00:00:00</value> </eDate> <eDate> <name>CCCC</name> <value>20090615 00:00:00</value> </eDate> <eDate> <name>DDDD</name> <value>20090616 00:...