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
- 10158 Views
- Infotech, I also Faced
- E-Mail Answers
Answer Posted / subhash
we can delete in 2 ways:
1) in TGT Oracle Stage,
select 'Write Mode' as 'DELETE'
and write the delete Query as
"DELETE FROM EMP_TGT
WHERE EID IN (SELECT EID FROM EMP_SRC)"
2)Select 'Write Mode' as 'UPDATE' and write some dummy update query(This statement will not execute as WHERE condition 1=2) as
"UPDATE EMP SER EID='1111' WHERE 1=2"
then write delete query in 'Run before SQL statemets' as
"DELETE FROM EMP_TGT
WHERE EID IN (SELECT EID FROM EMP_SRC)"
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Can we use target hash file as a lookup ?
what is the use of surogate key in datastage
How to perform incremental load in datastage?
what is flow of project?
Define Job control?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What are the important features of datastage?
Define project in datastage?
What is the difference between datastage and informatica?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
How many types of hash files are there?
Lookup constraints
What is the project in datastage?
Can you explain repository tables in datastage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
