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
- 10187 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
What is a datastage job?
What are the steps needed to create a simple basic datastage job?
What is use Array size in datastage
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is the difference between informatica and datastage?
What can we do with datastage director?
What are the types of containers and how to create them?
Define orabulk and bcp stages?
What is the use of datastage designer?
What are the stages in datastage?
CHANGE CAPTURE
Can you explain engine tier in information server?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
what is use of SDR function?
What is oci?
