Load Problem

dssiddu · Post by **dssiddu** » Tue Nov 15, 2005 11:31 pm

hi all

i have one qry....

i have a data of 1 Cr Records,, while loading this data after 50k records job aborted.. So what i have to do for remaing records.

1- Re run the job once again or
2- Load the remaining records -in this case how will go about this..

Adv Thks

ray.wurlod · Post by **ray.wurlod** » Wed Nov 16, 2005 2:02 am

Not enough information.

What stage types are you using? What is the source? Are there any constraints in the source select statement that limits the row count to 5 crore? What is the "rows per transaction" setting? Do any error/warning messages from Oracle appear in the job log? Are you using OCI stage or bulk loader? Reset the job in Director - does a message "from previous run..." appear?

Raghumreddy · Post by **Raghumreddy** » Wed Nov 16, 2005 11:44 am

Hi
Solutions
1. You can delete the records loaed from the target and reruns the job again

2. put one more hash file to store the record count and use that as refeence when you are loading the data in second Run. (Ex: if you load 50000 then the hash file data will be 50000 as number and when you rerun the same data check for the INROWNUM < Hashfile data then skip. else take it to target.)

3. Set Transaction sife to a number to Commit. So that job wont fail.

HTH
Thanks
Raghu

ketfos · Post by **ketfos** » Wed Nov 16, 2005 11:58 am

Hi Dssidhu,
What is meant by 1 Cr Records.

Pl clarify.

Thanks
Ketfos

chulett · Post by **chulett** » Wed Nov 16, 2005 12:19 pm

It's a unit of measure - short for 'crore' or 100 lakhs.

http://en.wikipedia.org/wiki/Crore

ray.wurlod · Post by **ray.wurlod** » Wed Nov 16, 2005 3:31 pm

Common on the sub-continent (India, Sri Lanka, Pakistan, Bangla Desh). "Lakh" and "crore" are counting units, just like you use "thousands" and "millions"

One lakh = 100,000 (but usually written 1,00,000).

One crore = 100 lakh = 10 million (usually written 1,00,00,000)

ketfos · Post by **ketfos** » Wed Nov 16, 2005 7:01 pm

Thanks Craig and Ray for sharing this mystery of terms and numbers.

Ketfos

rleishman · Post by **rleishman** » Wed Nov 16, 2005 7:32 pm

Well, if the measure of achievement is that "You learn something new every day", I can go home early. Which is convenient, because I have a crore stuff to do.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 16, 2005 8:04 pm

To become a rich man you must have lakhs of lakhs of rupees.

manteena · Post by **manteena** » Thu Nov 17, 2005 1:48 pm

Just millions of grnads........

DSXchange

Load Problem

Load Problem

Re: Load Problem