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
- 30693 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
Which commands are used to import and export the datastage jobs?
What is the purpose of interprocessor stage in server jobs?
What are data elements?
What are orabulk and bcp stages?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What is meta stage?
What are the main features of datastage?
Have you have ever worked in unix environment and why it is useful in datastage?
What can we do with datastage director?
Where do the datastage jobs get stored?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
Which warehouse using in your datawarehouse
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
how do u catch bad rows from OCI stage? And what CLI stands for?
