DSXchange

I have requirement to trim the 'Phone_number' columns. Input(source) output(target) PHONE_NUM-Char(15) PHONE_NUM-Varchar(15) When I used the function Trim(PHONE_NUM), it trimmed the leading and trailing spaces, but the job failed with an error below "1. Error code: 12899, Error message: ORA-128...

Spoke with the architect regarding this surrogate key generation. They are ok with that as they are unique , eventhough not in sequence.

So I am going ahead with Surrogate key generation in Transformer.

Thanks for your support , Priya and Craig

Thanks for your reply, Craig.

Hi , My requirement is to populate the sequence number from 1 to the column 'SK'. For eg- today we have 10 records and sk column should have '10' as value for the last record inserted. Next day when 5 records are appended to the database , next SK value should be 11 to 15. I have used 'Surrogate Key...

Thank you, Ernie.

Thank you, Craig.

I will try with User Variable activity and get back to you.

Thanks for your response,Craig. Yes , sequencer is involved to run the job. As I am giving the url 'https://dart.service-now.com/api/now/table/incident?sysparm_query=sys_updated_on%3E=[b] 2017-08-01 [/b]^ORDERBYsys_updated_on&sysparm_display_value=all" in the Hierarchical stage -->EditAssem...

I am able to pull the date from URL if 'https://dart.service-now.com/api/now/table/incident?sysparm_display_value=all' using Hierarchical stage. Now the requirement is to get previous day data from the url "https://dart.service-now.com/api/now/table/incident?sysparm_query=sys_updated_on%3E=[b]2...

I resolved this problem using Hierarchical stage. Though the above java error is coming, I am able to pull the data from URL after I made changes in the 'Edit Assembly' option 1) Used the web services client stage--> web services option ---> download the datafile ( json) file to my desktop and creat...

As I am unable to progress with webservices client stage, I used the Hierarchical stage to get the data from URL.

Thank you , Ernie. I will go through the articles posted here.

Eventhough I downloaded the WSDL file to my desktop, I am unable to get the data from the URL provided (to pull the data.)

Don't understand the root cause for this problem. Do we need to give hostname, portname in the Proxy for web client services stage? Please let me know.

The problem is resolved. As mentioned by chulett and Ernie, I took 1 record out of huge json file (277775 records) with metadata structure like below and saved in as TaskBaseline.json --------------------------------------------------------------------------------------- [{ "__metadata": {...

Thank you, Chulett. Got it, I will try and get back with the result

Thanks for your reply, Erni.

What do you mean by ' cut down the 717mb file to one set of properties'. Sorry I didn't understand. Please let me know.