how to abort the job its matain duplicates?



how to abort the job its matain duplicates?..

Answer / Mohd Afzal

To abort a job that is creating duplicates in Data Stage, you can use data quality checks and filters to ensure duplicate records are not processed. This can be done by adding unique constraints on relevant tables, using merge or upsert statements instead of insert statements, or by implementing a script to identify and remove duplicates.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

What is PX?

2 Answers   IBM,


What are the repository tables in datastage?

1 Answers  


HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?

1 Answers   HCL, IBM, Infosys,


hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage

1 Answers   Wipro,


How do you register plug-ins?

1 Answers  


options available in sequence job to run,validate?

1 Answers   CTS,


What are the difference types of stages?

1 Answers  


What is the purpose of interprocessor stage in server jobs?

1 Answers   ASD Lab,


With out using Funnel Stage, how to populate the data from different sources to single target

12 Answers   Wipro,


what is the best stage in datastage parller jobs to use full out join and why

5 Answers   Virtusa,


how do u capture duplicates through sort & transformer

4 Answers  


how to load meta data

2 Answers   IBM,


Categories