DSXchange

scenario: 1. I have a counter that creates instance one by one... 2. There is a errohandlingjob that is called if any instance fails... 3. for every instance parameters that are passed are same but there value differs as the instace picks value from some xyz table. Problem: 1. Say the parameter that...

DSguru2B wrote:By parametrizing the names.

ok that will generate 3 diff ctl file..
what about the data file

how these ctl file can be used to load table in lesser time..

How many records are we looking at? Cant a single instance take care of the load? Use different names for different instances for the control file. Is SP.txt the data file? final load will load 2billion records... How to use different names for different instances for the control file yes SP.txt is...

My job for inserts using OraBulk stage ran smoothly without any error But when i created multiple instances(3) of the same job and ran the job, my job's 2 instances aborted one due to lock on SP.ctl file and other due to lock on SP.txt file.. :?: is there a way to run the job with multiple instance ...

chulett wrote:

47shailesh wrote:DUMMY column is not used any where nor it is present in the DB.

Which is - as noted - more than likely your problem. Did you even try what I suggested?

thankx chulett for the previous solution, it worked unable to run the job immediatly after the reply due to some dependencies.. :D

Target SQL - Insert /*+ append*/ into <column name> from view There is nothing more to describe in job design Sure there is. Can we get a little more precise in our description of the target SQL, espcially seeing as how that's where the problem lies? :? You don't insert without selecting from somew...

Start over. Please supply the following: - Source metadata - Source sql - Target metadata - Target sql - Job Design. Source- ORA OCI one column -> DUMMY <type varchar> Source sql - SELECT 1 FROM DUAL Transformer doing no transformation Target - ORA OCI one column -> DUMMY <type varchar> Target SQL ...

An insert is a DML statement. It will be a logged activity. A bulk load is not the same as insert. So you want to test the inserts. Take the same sets of data and test it out. It does not depend upon how many years of data you have. It depends upon a lot of factors like record byte size, netword tr...

You might want to explain how you are doing a 'bulk load' from an OCI stage. I also don't understand why the true Bulk Loader stage wouldn't "serve your purpose"? :? sir i have a insert query in the Target OCI, that does the bulk insert. i want to load data on condition say for 2 years on...

i have designed a job in DS using 2 OCI and a transformer. Source OCI does SELECT 1 FROM DUAL and has a dummy column named "Dummy" Target OCI has a Insert SQL that does the bulk insert in target table. I used Dummy column as i do no want to use OraBulk stage as it wud'nt serve my purpose i...

Transformer_0: ORA-01858: a non-numeric character was found where a numeric was expected. :? Tha'ts not an error I would expect to come from a problem with a DATE field. Dollars to doughnuts it's coming from a different field you are populating - one defined as a NUMBER of some precision. thanks Si...

Transformer_0: ORA-01858: a non-numeric character was found where a numeric was expected.

in additio can you help me understandand how to use iconv/oconv with some example.

:?: :?: i have designed a job to insert a data into a table: the problem that i face is that it displaying error "non- numeric found where numeric expected".. i m stucked up there... even the i have to set the date column as varchar else it is displaying error.. i have column types as deci...

Yes

Yes