DSXchange

chulett wrote:Record terminators, like a line-feed in the middle of your data.

Yeah thanks for the information.. On further analysis found that the file is fixed length even though it contain comma as delimiter.
So processed it as Fixed length file itself..

Thanks for the information though.

Hi Guys,

I want to replace only the first and last occurance of a string.

For the first occurance i am using Ereplace command.
But i am not able to find out how to do it for the last occurance.
Cheers

I already did and since it was only four words I've opened my post. First of all thanks for opening your post. I did not get pre qualify part of it. You mean to say do a lookup with the target table and create two links. one for update and one for insert? Could you please clarify.. Thanks once again.

Your file is breaking the rules. If strings are delimited by double-quote, they can't contain double-quote. Get the provider of the file to get it right - either use a different delimiter character ... Ray, there is a option in the Columns tab of the Sequentail stage "Contains Terminators"...

Nope, it's simply the fact that all colums in the stage must be bound into the query. Each must mention all four, so if you don't want to update all fields you'll need to pre-qualify your actio ... Yeah chulett i agree, but i want the update to be running only for those records which already have t...

If i am giving this Custom Query, it is working fine. UPDATE EDW.REL_CATALOG_HEADER SET col1=:2,D_CRT=TO_TIMESTAMP(:3, 'YYYY-MM-DD HH24:MI:SS'),D_UPD=TO_TIMESTAMP(:4, 'YYYY-MM-DD HH24:MI:SS') WHERE KEYCOL=:1; INSERT INTO EDW.REL_CATALOG_HEADER (keycol,col1,D_CRT,D_UPD) VALUES (:1,:2,TO_DATE(:3, 'YYY...

Hi Guys, I have 5 columns in a table. Out of them, 2 cols are CreateDate and UpdateDate. The data which will be inserted will be upsert. In the update statement, when i use only the UpdateDate column, the job is aborting. But when i am using InsertDate column along with the UpdateDate column, the jo...

Hi Guys, I have an issue in reading a file. File is a Comma Delimited File with Quotes on Data. But the issue is some Data in one of the column is having " (1") and comma. "PENCIL GRIPS, 5PK ", "Econ VW Binder White 1" ", I need to insert the data as it is to the T...

Thanks for your help chulett.

You mean to replace "T" with " " and then convert it to Timestamp. But i gues there is no Replace Function in Parallel job.

Really appreciate your help.

Cheers!!!

Hi Guys, My source is a flat file. I have a timestamp column coming as Varchar. THe data is in the format 2011-02-02T14:05:35. I need to load it to Timestamp Column. I am using the below transformation in Transformer. StringToTimestamp(Link1.Col1,"%YYYY-%MM-%DDT%hh:%mm:%ss") But i am getti...

I increased the Buffer Size to 10485760 by adding the env variable $APT_BUFFER_MAXiMUM_MEMORY and also added the env variable $APT_BUFFER_FREE_RUN to 1. But still the job is getting the same error.

Can you somebody help me with this.

Hi Guys, I am getting the below error. APT_CombinedOperatorController,0: terminate called after throwing an instance of 'APT_BadAlloc' APT_CombinedOperatorController,0: /bin/echo: write error: Broken pipe The Job is running fine if i am running the job for fewer records. Can somebody guide me as how...

I am trying to read XML file using the Sequential file stage. Why? An XML file is not a "sequential" file in the sense that the Sequential File stage understands reliably. Technically they are one long stream of characters with no individual records. Why not use the stage that was meant t...

Hi Guys, I am trying to read XML file using the Sequential file stage. I am giving a Record delimiter as </Transaction> (closing Transaction Tag). But for some reasons, after 10 records the job is throwing error that delimiter is not present. But i am able to see the delimiter. In fact, i did a grep...

Hi Guys, I have designed a job which was running fine with a particular XML file. Now I have got a similiar XML file . The job is failing with the below error. Src,0:Error reading on import. Src,0:Consumed more than 100000 bytes looking for record delimiter; aborting Src,0:Import error at record 75....