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
- 31378 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 transforms and what is the differenece between routines and transforms?
What is orabulk stage?
What is ibm datastage flow designer?
What is the project in datastage?
what is the use of materialized view?
Differentiate between operational datastage (ods) and data warehouse?
Can you define merge?
What is apt_config in datastage?
What is datastage engine?
What are the areas of application?
Highlight the main features of datastage?
If you want to use the same piece of code in different jobs, how will you achieve it?
What are the types of containers and how to create them?
What are the various kinds of containers available in datastage?
How to read the length of word in unix?
