1)The approach is to load the seq file data into one temporary table say

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 / shilpasagarg

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

Answer Posted / shilpasagarg

1)The approach is to load the seq file data into one
temporary table say EMP_TEMP. (SEQ -> ODBC Stage (Oracle
(EMP_TEMP table)
EMP_TEMP contains
eid
1
2
"
"
10

2)Then take the ODBC Stage to connect to Oracle DB (EMP
table).
EMP table contains
eid
1
2
"
"
100

Here use the below query to delete the matched EID's
permanantly from oracle DB

DELETE EMP
FROM EMP
INNER JOIN EMP_TEMP
ON EMP.EID=EMP_TEMP.EID

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

options available in sequence job to run,validate?

1326

What is the difference between the local container and shared container?

1108

What are the components of datastage?

1124

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3652

what is the use of materialized view?

1575

What is the difference between in process and inter process?

1157

Is possible to create skid in dim,fact tables?

2642

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2508

How a routine is called in datastage job?

1122

how to implement scd2 in datastage 7.5 with lookup stage

5610

What are data elements?

1181

Can you explain repository tables in datastage?

1412

in oracle target stage when we use load option and when we use upsert option?

2285

If you want to use the same piece of code in different jobs, how will you achieve it?

1161

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2498