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..
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
Define APT_CONFIG in Datastage?
Where do you see different stages in the designer?
How the ipc stage work?
What is difference between server jobs & parallel jobs?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
How to RD using transformer?
What is a datastage job?
What is the difference between operational data stage (ods) and data warehouse?
If you want to use a same piece of code in different jobs, how will you achieve this?
What are the types of containers in datastage?
I have a few records just I want to store data in to targets cycling way how?
Difference between data warehousing and olap?
How rejected rows are managed in datastage?
Describe routines in datastage? Enlist various types of routines.
Differentiate between odbc and drs stage?