We can perform inner join between seq file & oracle stage and then in t

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

5 Answers
10183 Views
Infotech, I also Faced
E-Mail Answers

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

What is a datastage job?

1013

To see hidden files in LINIX?

1530

What are the enhancements made in datastage 7.5 compare with 7.0?

1149

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3250

Explain datastage architecture?

1402

Can you explain link buffering?

1181

Differentiate between datastage and datastage tx?

1051

What is the sortmerge collector?

1131

how to implement scd2 in datastage 7.5 with lookup stage

5606

Is possible to create skid in dim,fact tables?

2636

Explain connectivity between datastage with datasources?

976

Can you explain kafka connector?

1312

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1216

Define Merge?

1319

how to export or import the jobs in .ISX file

1203