DSXchange

I had a similar issue with "special" characters in XML. The xml would not open using IE and would not parse using the xml stage, so I decided based on our requirements to convert the non-standard xml characters to blanks. Since the xml was generated from a application that allowed users to...

Well, we finally found something that worked. I changed all the stages after the java adapter to run sequentially, instead of the default(parallel). I'm not sure why, but I'm thinking it has to do with memory usage.

Regardless, it's working now.

Thanks to all.

Jason

Thanks for your input guys. I'll try the suggestions.

Thanks,
Jason

Hello all. I just wanted to see if anyone else has had any experience and pointers when working with DataStage and SalesForce.com. Here is the scenario: We have an instance of SalesForce.com that we're wanting to get data from and push data to on a nightly basis. Our current job design consists of t...

I did something similiar, but I used uvsh to identify the jobs that were candidates for deletion. From that list, I manually deleted the jobs from the project using DataStage Manager. I'm sure there are other ways of doing this, but the dsjob -info will give you a start, and then from that list, gra...

Anyone ever used Message Filtering Options in the MQ plugin? I have a requirement to filter based on a string that's in the PutName column on the queue. Under the Message Filtering Options tab, I've check apply filtering and put my string under Original Application Name. Example: 'TINCT' When I try ...

We have a solution:

Based on the input, the xpaths should be defined as
/rows/row[@field="ColumnName1"]/text()
/rows/row[@field="ColumnName2"]/text()
/rows/row[@field="ColumnName3"]/text()

on the Output tab in the xml Input

Thanks,
Jason

Could one of you elaborate a little more about using custom stylesheets with this sort of input file:

<value name="SEGMENT">1</value>

where SEGMENT is the column name and 1 is the value of that column?

Thanks,
Jason

Dealing with xml, I've found that there can be attributes and elements inside a well-formed xml file. Well, this is what I came across. Another application wanted to send me an xml file in the following format: <Rows> <Row Field='ColumnName1'>10</Row> <Row Field='ColumnName2'>Bob</Row> <Row Field='C...

I had a similar problem, and this was the solution that was recommeded relating to xml file size.

viewtopic.php?t=113623&highlight=xml

Hope it helps.

Jason

I think we can probably just use the 9.2.0.5 libraries instead of 10g on the client side. That's exactly what we do. ... Actually, I just found out that our DataStage Support and Oracle DBA's do not want both libraries on the server at the same time. I guess we just won't have the Load functionalit...

First I would say, Post this under the correct Forum since it is a EE related design. Actually, I've designed a job using both the external source stage and the sequential file stage. I would probably stick with the sequential file stage. You just need to pass the path name of the actual xml file, a...

Thanks chulett. I think we can probably just use the 9.2.0.5 libraries instead of 10g on the client side. That should help. I still don't understand why i'm getting data loaded to the table successfully.
It's all good.

Jason

Okay, I have two issues, and I think we've resolved one, but I wished to share to see if anyone else came across this. First, Oracle client is 10g, Oracle Database is 9.2.0.5. This is a problem according to Oracle: "the client version must be the same or earlier than the server version, and bot...

Instead of using ls command, use the find command and pipe it to your input.