DSXchange

I assume you ment to ask why can't I use ANSI with a "WINDOWS-1255" XML header. Of course I do can use "UTF-8" header with ANSI and DS works fine but then the file will not open correctly in the browser wich makes it a little more difficult to QA the Data. The reason I can not us...

Hello, I am trying to read xml files but manage to do so only if the header encoding is UTF-8 and the file itself is defined as ANSI encoded if I try to save the xml file as UTF-8 in the encoding checkbox on the notepad editor (the xml header remains UTF-8) the job finishes with a warning about unkn...

Hi, We are trying to read files wich we get from MF by FTP process The problem is that these files contain a lot of unreadble characters which produces the following warning: nls_read_fixedwidth() - NLS mapping error, row 14306 (approx), data = " ???? ???? ? After fixing the unreadble character...

I did try the method you suggested but strangly enough got quite poor results. I'm assuming maybe it's because too many rows needs updating. for this test I cretated A source table with 1 milion rows derived from the 20 milion target table and made the flowwing changes: 1. half of them I changed an ...

however i do need a lookup hased file to determine whic rows to update and wich rows to insert. i created a job with 1 milion rows input than needs to be upserted in table A containing 20 milion rows. to do this i also created a hashed lookup file containing all records already existing in table A. ...

WHAT IS THE BASE WAY TO PREFORM UPSERT TO A TABLE? I TRYED DOING A DIRECT UPSERT VIA "UPDATE OR INSERT" AND DISCOVERED IT TO BE NUCH SLOWER THEN PREFORMING A LOOKUP USING A HASH FILE. HOWEVER I CAN NOT SAY FOR SURE IF LIMITING THE HASH FILE TO NEWER ROWS CAN MAKE THE PROCCESS MORE EFFICIAN...