DSXchange

The Hex data file needs to have different records and different data types same positions of the record. source is a list of affiliates ,For every Affiliate we need to create 2 records of different lengths and that the data type of the field at pos 26 of header record is character but the data type ...

Hi, I Have a job which runs 22 times for 22 different tables. So, I didn't define any column names, I just used RCP. I have a table with 350000+ rows. When I try to run the job with that table as Source, the job fails with following error in Source Oracle Connector after extracting 192000+ rows. SRC...

This is what I did,

Created Index on Column which I was using to update the table in where clause.

It fixed the issue.

Thanks for the suggestions though.

Hi, I am copying, ID(Primary KEY), EMP_ID, NAME, ADDRESS from Table EMP to a DATASET. Then I am doing a lookup on DATASET from a different file with columns EMP_ID,NAME,ADDRESS. When ever the EMP_ID matches, I am sending ID,NAME,ADDRESS to an Oracle Connector and trying to update NAME and ADDRESS ba...

0x5c is a hex char which your default NLS is unable to read. Check your XML source file data once. To make sure your Job is fine, you can download an example XML and XSD and try running the job with that.

Thank You Shane. I added a Sort between Pivot and DataSource and changed "allow duplicates" to false in Sort stage, so I don't need another remove duplicates. I partitioned the data in sort stage and kept it as same in Pivot. It worked like charm. Thank You again.

My job structure is something like this, DataSource>Remove Duplicates>Pivot Stage>Transformer>TargetDB I have 3million records to process. My pivot stage is taking 90mins to do that. I have 8 input columns to Pivot stage out of which 2 need to be pivoted vertically. In the beginning I grouped by all...

Hi Spuli, First you need to include the xsd as a library and then use it in XML stage in XML Parser step>Document root. Here is the step to step explanation of same, https://www.ibm.com/developerworks/data/library/techarticle/dm-1103datastages/ I had a tough time getting help on XML too. I hope you ...

Hi, I am writing a select query in oracle connector. Ex: Select A,B from tab1; Do I need to write metadata in same order as that in the select statement? A Varchar Etc... B Varchar Etc... As of now, I didn't face any problem different order. But I think I read it some where that it needs to be in sa...

You can just append 00:00:00 to the existing string

input.Column_Name:' 00:00:00'

Then use StingToTimestamp() function to convert it to timestamp

StringToTimestamp(input.column_name:' 00:00:00', "%dd-%mmm-%yyyy %hh:%nn:%ss")

Hi, I am taking an XML as input in an XML stage. Then I parsed it, validated it and composed it. But there is a discrepency in Source and Target. My input root element looks like this, <ROOTELEMENT xmlns:soapenc="http://xmlsoap.org/soap/encoding" xmlns:wsdl="http://xmlsoap.org/wsdl/&q...

Hi, I am taking an XML as input in an XML stage. Then I parsed it, validated it and composed it. But there is a discrepency in Source and Target. My input root element looks like this, <ROOTELEMENT xmlns:soapenc="http://xmlsoap.org/soap/encoding" xmlns:wsdl="http://xmlsoap.org/wsdl/&q...

Login to your Unix server (where DataStage server) is installed and go to bin directory of DataStage. dscc.exe /H hostname /U username /P password project_name /J jobname Note: The job name can be * to compile all the jobs in the Project. Never tried it myself, so g read you datastage folder and che...

My Source and target are XML. In source Null values are not shown. In target I should show NULL columns too.

Yes I am reading XML file. In the source XML file all NULL columns are hidden. To show the null columns in target XML, i updated the XSD with nillable="true" option for all columns and took it as document root in XML Composer in the XML stage. But still I can't see Null fields in target XML.