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
- 9942 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
Enlist various types of routines in datastage.
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
How one source columns or rows to be loaded in to two different tables?
How to RD using transformer?
Why we use surrogate key?
Describe link sort?
what are the errors,warnings in datastage
What are the job parameters?
What is difference between server jobs & parallel jobs?
What is the difference between operational data stage (ods) and data warehouse?
How will you move hashed file from one location to another location?
What is active and passive stage?
Notification Activity
What is the difference between an operational datastage and a data warehouse?
What is ds designer?
