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
10366 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 are the repository tables in datastage?

1348

What are the functionalities of link partitioner?

1062

Where do the datastage jobs get stored?

1266

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

1056

How to clean the datastage repository?

1176

Describe link sort?

1057

how can we create rank using datastage?what is the meaning of rank?

8846

How many areas for files does datastage have?

1212

Explain the importance of surrogate key in data warehousing?

1229

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

964

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3516

What are the some differences between 7.x and 8.x version of datastage?

1303

How many types of views are there in a datastage director?

1335

What are the types of jobs we have in datastage?

1117

How to implement complex jobs in data stage?

1156