1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

If seg file having 10 records
ex:eid
1
2
"
"
10
if oracle database having 100 records
ex:eid
1
2
"
"
100
how to delete matched records permenently from oracle
database using datastage ?

Question Posted / vaibhav

Answer Posted / vaibhav

We can perform inner join between seq file & oracle stage and then in target oracle stage have write method as Delete where we can specify delete query using orchestrate incoming rows..

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to abort the job its matain duplicates?

2109

What are stage variables?

638

Can you implement SCD2 using join, transformer and funnel stage?

1091

client know skid info?

1635

What is a merge in datastage?

772




How can we improve the performance in datastage?

654

What are orabulk and bcp stages?

649

What are the types of jobs we have in datastage?

672

How can you write parallel routines in datastage PX?

620

EXPLAIN SCD

969

What is a quality stage in datastage tool?

632

What is apt_config in datastage?

702

Notification Activity

901

How to clean the datastage repository?

696

Which algorithm you used for your hashfile?

691