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
- 10378 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
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.
Differentiate between datastage and informatica?
How we can covert server job to a parallel job?
How do you generate sequence number in datastage?
What are the some differences between 7.x and 8.x version of datastage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What all the types of jobs you developed?
Can you highlight the main features of ibm infosphere information server?
How do you run datastage job from the command line?
Describe stream connector?
Describe routines in datastage? Enlist various types of routines.
What is active and passive stage?
What is ibm datastage?
What is a folder? Difference types of stages?
How you can fix the truncated data error in datastage?
