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
- 30773 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
how to export or import the jobs in .ISX file
What are stage variables?
What are the difference types of stages?
How to reverse the string using SQL?
How can you write parallel routines in datastage PX?
How we can covert server job to a parallel job?
Describe routines in datastage? Enlist various types of routines.
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Can you highlight the main features of ibm infosphere information server?
What is the difference between hashfile and sequential file?
Can you define merge?
How will you move hashed file from one location to another location?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is the difference between passive stage and active stage?
Differentiate between validated and Compiled in the Datastage?
