DSXchange

Hello, Jobs are doing Truncate and Load Sqlldr ctrl files look like OPTIONS(DIRECT=TRUE, PARALLEL=TRUE, SKIP_INDEX_MAINTENANCE=YES) LOAD DATA CHARACTERSET WE8ISO8859P1 INFILE 'ora.136.645058d.fifo.0' "FIX 180" APPEND INTO TABLE dct3_wls.DCT_DELIVERY_ADDITIONAL_PLC Ofcourse there are 5 load...

Hello, We are using Oracle Enterprise Stage to load Oracle 10g from DS7.5.2. We have two Oracle Schemas and webservices use one and other is used to refresh data. Once this is done, Webservices switch to using this schema. Issue - time and again we get Oracle errors like below SQL*Loader-951: Error ...

Hi Ray, Can you explain how to make it generic? If for eg the table has to check 5 other tables data before load on some key combinations, should we go to DB dictionary to get the keys, dynamically create sql, then use Universe stage .... and reject missing . Or do you suggest to actually implement ...

Hi Chulet
But isn't that exactly what Ray is suggesting me to do Thanks
Pavan

Hi Ray Correct me if i am wrong. you are saying that push the Referential Integrity on the Database and be systematic in the way you fill the Primary Tables and go ahead with filling the child tables Same Pit falls Our POC on pushing referential integrity checks on the database doesn't seems to be w...