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
- 10007 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
which r the connectors used in san?
How do you run datastage job from the command line?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
How do you remove duplicate values in datastage?
What is a folder? Difference types of stages?
What is ibm datastage flow designer?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
Define data aggregation?
CHANGE CAPTURE
What is a datastage job?
How you Implemented SCD Type 1 & Type 2 in your project?
what is 'reconsideration error' and how can i respond to this error and how to debug this
What are the types of jobs we have in datastage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Can you explain kafka connector?
