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 ?
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
how to abort the job its matain duplicates?
Describe stream connector?
Differentiate between Join, Merge and Lookup stage?
Explain connectivity between datastage with datasources?
How one source columns or rows to be loaded in to two different tables?
What is the difference between orabulk and bcp stages?
What are iconv and oconv?
Define meta stage?
What is the difference between passive stage and active stage?
What is the difference between datastage and datastage tx?
Which warehouse using in your datawarehouse
Name the different sorting methods in datastage.
What are the types of jobs we have in datastage?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
What steps should be taken to improve Datastage jobs?