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 / 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
Nls stands for what in datastage?
What are the steps required to kill the job in Datastage?
What is the difference between server job and parallel jobs?
What is size of a transaction and an array means in a datastage?
How do you reject records in a transformer?
Explain datastage architecture?
how to export or import the jobs in .ISX file
Describe the main features of datastage?
On which interface you will be working as a developer?
How to convert RGB Value to Hexadecimal values in datastage?
Why fact table is in normal form?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Differentiate between odbc and drs stage?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What are iconv and oconv?