Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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 / rajesh.k

Answers were Sorted based on User's Feedback



I am running a job with 1000 records.. If the job gots aborted after loading 400 records into targ..

Answer / 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

I am running a job with 1000 records.. If the job gots aborted after loading 400 records into targ..

Answer / phani kumar

With the help of available Environment variable as
APT_CHECKPOINT_DIR, we can run the job for remaining records.

This is available in Datastage Administrator like.....


With Datastage Administrator - project-wide defaults for
general environment variables, set per project in the
Projects tab under Properties -> General Tab -> Environment
variables.

Here, we can enable the this checkpoint variable. Then, we
can load the remaining records........

Is This Answer Correct ?    6 Yes 3 No

I am running a job with 1000 records.. If the job gots aborted after loading 400 records into targ..

Answer / bharath

in datastage administrator we can enable add check point on failure option we can start from 401 record....

Is This Answer Correct ?    7 Yes 5 No

I am running a job with 1000 records.. If the job gots aborted after loading 400 records into targ..

Answer / shar

ok now we have an reject job with stages like
seq--tx--dataset1 lets say job1

now take job2 (job) dependency from job1 to job2) in that
get the data from seq use tx as input 1 (primary) and dataset2 as secondary (ref) in which we use path of dataset1 file this as second input. now connect these inputs to lookup stage and reject the unmatched records connect the reject link to dataset3 in which file name should be same as dataset1 with update policy = append.



thats it dude.

Is This Answer Correct ?    2 Yes 0 No

I am running a job with 1000 records.. If the job gots aborted after loading 400 records into targ..

Answer / abc

our design: src-->tfm-->data set.
to load the records from 401, just set the option Use Existing(discard records) in data set update action property

Is This Answer Correct ?    1 Yes 0 No

I am running a job with 1000 records.. If the job gots aborted after loading 400 records into targ..

Answer / vinay sharma

1) First take seq file after that take one extra column in
that increment the value one by one and send to target
2) Now store the maximum value of extra column and pass this
value to transform thru HASH file and add in extra column
such as (sno+MAX)
Examlpe
SNO
1
2
3
4
5
6
7
Thera are max value is 7
Now add maxvalue means add 7 in SNO
like that
1+7
2+7
3+7
4+7
5+7
6+7
7+7

Is This Answer Correct ?    2 Yes 3 No

I am running a job with 1000 records.. If the job gots aborted after loading 400 records into targ..

Answer / jagannath karmakar

USING SAVE POINT CAN PREVENT THIS PROBLEM

Is This Answer Correct ?    3 Yes 7 No

I am running a job with 1000 records.. If the job gots aborted after loading 400 records into targ..

Answer / venkat

using an option called cleanup on failure

Is This Answer Correct ?    1 Yes 6 No

I am running a job with 1000 records.. If the job gots aborted after loading 400 records into targ..

Answer / mukteswara rao

by usig
1. job level
2. job sequencing level

Is This Answer Correct ?    1 Yes 8 No

Post New Answer

More Data Stage Interview Questions

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?

9 Answers  

Can you highlight the main features of ibm infosphere information server?

0 Answers  

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

0 Answers  

6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment

3 Answers   TCS,

What is the difference between Datastage 7.5 and 7.0?

0 Answers  

how many types of sorting the data in data stage?

1 Answers   BoA, IBM,

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

0 Answers  

in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.

1 Answers   IBM,

What are some different alternative commands associated with "dsjob"?

0 Answers  

I have a few records just I want to store each records tow times in target how?

2 Answers   Polaris,

Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?

8 Answers   Cognizant, HCL, TIAA CREF,

client know skid info?

0 Answers   NTT Data,

For more Data Stage Interview Questions Click Here
Categories