how solves this problem

Hi!

I have a ETL process that runs on weekly basis which read data froma flat file to an external table.In this process i have defined log file and bad file too, to keep a track of the data transformation

A file has 1000 records that has to be uploaded into a table. After uploading 700 records, process breakdown, now ODI needs to re start upload from the breaking point i.e. upload should start from 701th record.

How i can i roll back this process.

here i am using the sql loader for uploading....

[535 byte] By [Raghava.javaa] at [2007-11-27 7:39:41]

«« Building gcc 4.2 failed
»» Bad file descriptor

# 1

Multiple post<a href=" http://forum.java.sun.com/thread.jspa?threadID=5184374&tstart=0">Answered here</a>

cotton.ma at 2007-7-12 19:20:23 >

top of Java-index,Java Essentials,Java Programming...

# 2

<a href=" http://forum.java.sun.com/thread.jspa?threadID=5184374&tstart=0"> http://forum.java.sun.com/thread.jspa?threadID=5184374&tstart=0</a>

cotton.ma at 2007-7-12 19:20:23 >

# 3

Okay then. Well I guess we were due for another random change since it's been an hour....

cotton.ma at 2007-7-12 19:20:23 >

# 4

Thanks for u r Reply

But we are using with Tool ,i put auto commit,

run time how it possible .

if souposes power will lose then after we can start from 701 right

othere wise total proceudre takes more time .

using with sql loader , is there any chance to put the check points..

Raghava.javaa at 2007-7-12 19:20:23 >

# 5

Return to your other thread please!

cotton.ma at 2007-7-12 19:20:23 >

# 6

Hi , Means what ? I didn't get u can u explain clearly.ThanksRaghava

Raghava.javaa at 2007-7-12 19:20:23 >

# 7

> Hi ,

>Means what ? I didn't get u can u explain clearly.

> Thanks

> Raghava

Please copy and paste the following link into your browser

http://forum.java.sun.com/thread.jspa?threadID=5184374

And then go there. You have two threads for this question and the other one has an answer for you.

cotton.ma at 2007-7-12 19:20:23 >

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

how solves this problem

Java Essentials New Topic

Java Essentials Hot Topic

Java Essentials

All Classified