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 / abc
our design: src-->tfm-->data set.
to load the records from 401, just set the option Use Existing(discard records) in data set update action property
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Give an idea of system variables.
Terminate Activity
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are the stages in datastage?
What are the features of datastage flow designer?
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.
Differentiate between operational datastage (ods) and data warehouse?
What are the some differences between 7.x and 8.x version of datastage?
What are the repository tables in datastage?
How do you generate sequence number in datastage?
How to Remove Duplicate using SQL?
Explain the situation where you have applied SCD in your project?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
How you can fix the truncated data error in datastage?
How many Key we can define in remove duplicate stage?