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
Enlist various types of routines in datastage.
What are the enhancements made in datastage 7.5 compare with 7.0?
What are the primary usages of datastage tool?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is usage analysis in datastage?
Which warehouse using in your datawarehouse
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
How the ipc stage work?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
how can we create rank using datastage?what is the meaning of rank?
How a routine is called in datastage job?
Notification Activity
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Where do the datastage jobs get stored?
How do y read Sequential file from job control?