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
What are the different plug-ins stages used in your projects?
What are the types of containers in datastage?
What is ds designer?
How a server job can be converted to a parallel job?
What is the different type of jobs in datastage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
How can we improve the performance in datastage?
What are the steps needed to create a simple basic datastage job?
What steps should be taken to improve Datastage jobs?
explain about citrix scheduling tool in datastage
What are the difference types of stages?
Nls stands for what in datastage?
Describe link sort?
What is the differentiate between data file and descriptor file?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.