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
Explain the situation where you have applied SCD in your project?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
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.
Define project in datastage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What are the different plug-ins stages used in your projects?
Could anyone give brief explanation bout datastage admin
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What could be a data source system?
how to sort two columns in single job in datastage.
What can we do with datastage director?
Difference between in process and inter process?
What is use Array size in datastage
AGGREGATOR default datatype
What is a folder? Difference types of stages?