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..
- 9 Answers
- 30987 Views
- Cognizant, IBM, TCS, Virtusa, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the different options associated with dsjob command?
How to Remove Duplicate using SQL?
What are transforms and what is the differenece between routines and transforms?
how to add a new records into source?
What are the benefits of datastage?
Which commands are used to import and export the datastage jobs?
Is the value of staging variable stored temporarily or permanently?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Why do we use exception activity in Datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Explain entity, attribute and relationship in datastage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
how to delete one row in target dataset
