Interested to Buy Any Domain ? << Click Here >> for more details...
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 ?
- 5 Answers
- 9937 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
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is the use of datastage designer?
How do you generate sequence number in datastage?
What is the difference between datastage and informatica?
Why do we use link partitioner and link collector in datastage?
what is the use of skid in reporting?
Where the datastage stored his repository?
What is the difference between server job and parallel jobs?
Give an idea of system variables.
State the difference between an operational datastage and a data warehouse?
What are the types of views in datastage director?
How many types of hash files are there?
What is the difference between hashfile and sequential file?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What is the difference between in process and inter process?
