by using look-up stage we can get the answer.. there are two tables like 1

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..

Question Posted / sree

9 Answers
31091 Views
Cognizant, IBM, TCS, Virtusa, I also Faced
E-Mail Answers

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

What are the some differences between 7.x and 8.x version of datastage?

1267

How a routine is called in datastage job?

1128

Describe link sort?

1019

How do you run datastage job from the command line?

1100

What are routines in datastage? Enlist various types of routines.

1103

What is the purpose of interprocessor stage in server jobs?

2237

What is orabulk stage?

1058

What is quality stage?

995

Why we use surrogate key?

1243

What are the components of datastage?

1131

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

1165

CHANGE CAPTURE

1313

What is aggtorec restructure operator?

1463

What is apt_config in datastage?

1148

What is a ds designer?

1075