Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

I am running a job with 1000 records.. If the job gots
aborted after loading 400 records into target... In this
case i want to load the records in the target with 401
record... How will we do it??? This scenario is not for
sequence job it's only in the job Ex: Seq file--> Trans-->
Dataset..

Answer Posted / sree

by using look-up stage we can get the answer..
there are two tables like 1000 records(source) table and 400
records(target) table.

take the source table as primary table and 400 records table
as reference table to look-up table

reference table
.
.
.
source............. look-up......... target

Is This Answer Correct ?    10 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If you want to use a same piece of code in different jobs, how will you achieve this?

1274


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3644


What a datastage macro?

1054


What is active and passive stage?

1410


Can you explain players in datastage?

1185


What is "fatal error/rdbms code 3996" error?

1259


What are orabulk and bcp stages?

1119


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2054


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2855


What are the different common services in datastage?

1276


What is orabulk stage?

1043


What are the stages in datastage?

1081


What all the types of jobs you developed?

1175


Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1541


sed,awk,head

1459