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
- 30763 Views
- Cognizant, IBM, TCS, Virtusa, I also Faced
- E-Mail Answers
Answer Posted / sree
by using look-up stage we can get the answer..
there are two tables like 1000 records(source) table and 400
records(target) table.
take the source table as primary table and 400 records table
as reference table to look-up table
reference table
.
.
.
source............. look-up......... target
| Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
What is the precedence of stage variables,derivations, and constraints?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is the difference between an operational datastage and a data warehouse?
What are constraints and derivations?
How to Remove Duplicate using SQL?
State the difference between an operational datastage and a data warehouse?
Does datastage support slowly changing dimensions ?
What is the different type of jobs in datastage?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
how can we create rank using datastage?what is the meaning of rank?
What is the difference between server job and parallel jobs?
what are the errors,warnings in datastage
Define Routines and their types?
Define oconv () and iconv () functions in datastage?
