DSXchange

Hi guys, My job is a simple job with a Source(Oracle DB) , a transformer and Target(oracle Db). From source, i am getting 2 columns. In transformer, i will pass only one column(col1) and in constraint i am giving the IsNull(Col2). The Col1 is Varchar(15) both in source and target. But for some reaso...

The Transformer should not have mapping for the column in which you are populating the NEXTVAL value.
so, your transformer should have only mappings for 7 columns excluding the column in which you will be passing the NEXTVAL value.

Hi Guys,

I am getting a string in the format dd-mm-yy which i want it to convert it to yyyymmdd format. Can somebody help me.
Cheers!!!!

Yeah Ray, i found it later.. thanks anyway..

Hi Guys,

I like to convert CR and LF which is coming in a particular column to Empty string.

I tried the following but it was not converted.
Can somebody help me with this.

Cheers!!!

There is no time field. There is only one Timestamp column. I also checked the timestamp column, i did not find such a data ("00:00:00")

Hi guys, I am trying to run a custom query in Oracle stage. The query is running fine in SQL developer. So, i gave Tablename (1 of the 4 source tables). GenerateSQL is No. Then i gave the Custom query in User-Defined SQL. And Pre 4.2 User-defined as 'Yes'. My metadata is matching the select clause. ...

Hi Guys, Altogether i am pivoting 7 columns. One of the column is a Timestamp Column. Because of the Timestamp column pivoting, i am getting this Warning. Data string '00:00:00' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': the value for tag %yyyy has fewer characters than expected. If I remove...

Thanks Ray, thats all i am looking at

Hi Guys,

I need to convert DSJobStartTimeStamp to integer.

Currently am using the below code to convert it. Is there any better way to do it?

Cheers!!!!

Sorry guys, the issue was with the XML.
The input was not a valid file.
Now i am able to parse it..

I am also new to XML... I don know whether we can create it. But yes we can read it. emp_cd,last_name,first_nam are called attributes. They can be read it using XMLReader. In derivation part, you need to mention the XPath of them which will be /empload/entry/@emp_Cd /empload/entry/@first_nam /emploa...

Hi Guys, I need to Read XML file and put it to different Columns. My I/P is <?xml version=""1.0"" encoding=""UTF-8"" standalone=""no""?> <pricing-model> <qualifier> <next> <collection-name>items</collection-name> <element-name>item</element...

Make sure that the receiving field is large enough for the data you're sending to it. ... Yeah Ray, i gave 999999999 as Length. It failed with Abnormal Termination Error. One more thing i forgot to mention. I created two similar jobs. One in parallel and one in server with same metadata. Server job...

Hi Guys, I need to read a clob column and load it to Target Table. I am using Oracle Stage and used the Datatype as LongVarChar. When i gave empty string to Length i was able to read the CLOB column and load it successfully to a file. But when i tried to replace the file to the Target table, i am no...