DSXchange

Hi Ernie, While still waiting for my membership upgrade to Premium member, I want to clarify the below Instead of using the Schema library manager to import the metadata for JSON -TaskBaseline (as it is failing due to file size), I used the assembly editor in Hierarchical data stage to create the ou...

Since I am unable to figure out using WebServices client stage , now I changed to Hieararchical datastage. I followed the steps in this url 'http://informationintegrationblog.blogspot.com/2014/08/how-to-invoke-rest-web-services-from.html'. But I am getting only zero rows. When I tried to test using ...

Thanks for your prompt response, craig. 1) I have the metadata structure appearing in web services explorer and also in Table definition. Just I ran the job with metadata structure file, it ran fine without any error and it showed 1 processed row with all the fields populated with null values as we ...

I have a quick question. When we are getting the WSDL file, it should have both the metadata structure and the data inside it. Am I correct? Because when I checked for WSDL file example, it is mentioned it should have all the elements like definitions, type, message, porttype, Binding , ports and se...

Thanks for your prompt response, Erni. I will get back to you on this.

Thanks for your prompt response, Erni. I am not a premium member. I will take premium membership and go through your comments

I got the WSDL URL link and downloaded the metadata structure. Now the webservices explorer option is available

Scenario- Pull the data from url and load into sequential file Job Design- WebServices Client---->Sequential File steps 1) Got the WSDL file 'https://dart.service-now.com/incident.do?WSDL' and imported the table definition . Table definitions ---> WebServices ---> able to see the getRecords_IN, getR...

Scenario- I have a Json files with size of 717 mb and above. When I trying to do the 'Import New Resource' using the below , it throws an error of 'TaskTime'.json UPLOAD FAILED.Internal Error. Using Schema Library Manager ---> New library option -->> TaskTime-Import New resource---> Select the file ...

I am using 'Web services Client' as a data source to get the data from URL. 1) When I click Import--> Table Definition --> Web Services WSDL Definition---> typed the URL---> Asking to open / save the file. 2) I opened the file ---> Selected all the contents -->' Import' is disabled and nothing appea...

Solved the problem. Steps Followed 1) Stage Variable - svCreatedDate(Varchar)- Left( Right( In_CostConstraintScenarios.CreatedDate,15),10) 2) Created one more Stage variable 'svCD' as Integer with value 'AsInteger(svCreatedDate)' 3)Transformer1 stage TimestampFromTimet(svCD)-Varchar---> CreatedDate ...

Thanks, Guys for your response. This is what I did below ,but I am facing problem 1) Created a Stage variable(Varchar) to take 10 digits Left( Right( In_CostConstraintScenarios.CreatedDate,15),10)=svCreatedDate o/p of Transformer is 1498685212 2) In Transformer stage, I gave TimestampFromTimet(svCre...

Thank you, Guys. I will check the link provided by you and get back to you

I have a input.json file which has a 'CreatedDate' column with value like below "CreatedDate":"\/Date(1498684373427)\/", - Job design Hiearchical stage---> Transformer--> Oracle stage 1) 'CreatedDate' is coming as 'Varchar' while creating the metadata in Schema Library manager 2)...