DSXchange

Sandeepch19

Hi, We are planning to host DataStage on Azure cloud as part of data centre exit strategy. Please provide the steps involved in doing that. Below are some of the queries on the same. > Currently we are using DS11.5 ,Do we need to upgrade to 11.7 in order to do that? >Can we install DS server on Wind...

Sandeepch19

when i mentioned root that is a directory that is chosen in the XML composer step. That is where the xml is getting generated .

Sandeepch19

Hi,

We are generating this XML using XML hierarchical stage with old root of ABC but, when we changed the directory to ABC_DE we are getting the mentioned error.

Sandeepch19

Error when changed the target path from ABC to ABC_DE. Checked in Google and couldn't see any solution for this particular issue. main_program: Fatal Error: ErrorDuringDocumentCreation cause = 'java.util.InvalidPropertiesFormatException: org.xml.sax.SAXParseException: The reference to entity "U...

Sandeepch19

There are a lot of moving parts here. Building your "payload" is just one of them. You will need to all the details about calling your service, and whether it is available in REST as well as SOAP. ... The service that we are calling is SOAP web service. Building the Payload is the challen...

Sandeepch19

Hi Rodriguez,

Thank you for the response. Is there any other way where we can send header in a single request and details as a multiple request

Sandeepch19

HI Ernie, I am trying to use XML stage to create the XML with hierarchy and this XML will be fed to web service stage as an input. Once we create the XML we can use XML output stage to send data to web service in a single column(lets say SOAP_OUTPUT) but I am not how much data a single column can ho...

Sandeepch19

Sending hierarchical data through web service via soap request in datastage. To read a relational data from database and convert that into hierarchical data and need to send it downstream as a single or multiple hits. For Ex: Hierarchy in the downstream is Header rowcount totalcredit totaldebit deta...

Sandeepch19

Hi Ernie, It is a single call from ETL to peoplesoft . and Peoplesoft would be one row as a response. but in that row as I said there would be inbuilt peoplesoft fields(such as PSCAMA fields ) but one field(comments column) contains the actual XML. When I trying to make this field as an input column...

Sandeepch19

Hi, We are invoking peoplesoft web service from datastage and the output is in one field in the form of an XML. Lets say for exmple the output of peoplesoft web service is like this >col11 col2 col3 col4 XML is there in col3 and i am trying to make this as a key column to propogate and create an XML...

Sandeepch19

Hi, Need info on rejection handling when using web service transformation stage. Two scenarios would be there >When the web services are down- In this case what is the config setup i have to do >when there's no output for the input ETL provided- i did check rejects in the stage tab but still when th...

Sandeepch19

My Date Validation Logic is like this

Code: Select all

If INDATE <> ""  Then
  If IsValid('Date', INDATE[1,4] : "-" : INDATE[5,2] : "-" : INDATE[7,2]) = 1 Then
     StringToDate(INDATE,"%yyyy%mm%dd")
  Else SetNull()
Else SetNull()

Sandeepch19

Thank Craig.. Its not that i think but i am appending 0's . Isvalid function is also used to check the validity of the data. anyone faced this kind of issue earlier and resolved it?.

Sandeepch19

Do we have any other resolution apart from doing patch update?

Sandeepch19

When I checked in google I came across one solution where we need to update some patch because there is an issue with Pivot Stage in handling TimeStamp.

DSXchange

Search found 36 matches

Datastage on Azure

XML Hierarchical stage

sending hierarchical data through web service via soap rqst

Datastage calling peoplesoft web service

Rejection handling in web service transformation stage

Re: Timestamp issue when using Pivot Stage