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
- 31054 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
Define oconv () and iconv () functions in datastage?
How the ipc stage work?
AGGREGATOR default datatype
What are the job parameters?
what is the difference between == and eq in UNIX shell scripting?
What is size of a transaction and an array means in a datastage?
State the difference between an operational datastage and a data warehouse?
What are constraints and derivations?
How a source file is populated?
What is the importance of the exception activity in datastage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Differentiate between operational datastage (ods) and data warehouse?
What are the functionalities of link partitioner?
Which commands are used to import and export the datastage jobs?
What is the use of datastage designer?
