DSXchange

Yes, the file is updating columns in a table based on client_id, for example a client can buy many products hence no unqiue field. each column represents a product which why I'm using a matches so its marked with '1' id that client has made a purchase, there are 17 columns in total. Nothing is happe...

I left the job running over the weeknend and came in this morning, it was still running!! The server is in France but this shouldn't be a problem as I've been upadating tables with no trouble at all. In the OCI stage, its update existing rows only. I have a hash file which is my look up for client_i...

Hi, I have a problem when reading from a flat file, it has around 40,000 rows that update a table in oracle. when I try to run the job it only reads 300 rows and takes ages to do anything. I've put it into another flat file to test it and reads all 40,000 rows in one go and blindingly fast. Has anyo...