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
- 10149 Views
- Infotech, I also Faced
- E-Mail Answers
Answer Posted / vinod upputuri
Simple job:
SEQ>>>ORACLE_STAGE.
in ORCL_STAGE: SPECIFY WRITE METHOD: DELETE ROWS
specify the matching column as key column in column definition.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the importance of the exception activity in datastage?
Can you explain link buffering?
What are the types of containers and how to create them?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
what are the devoleper roles in real time? plz tell i am new to datastage....
Define data aggregation?
How many types of hash files are there?
How do you import and export the datastage jobs?
What are iconv and oconv?
What are the functionalities of link collector?
options available in sequence job to run,validate?
Have you have ever worked in unix environment and why it is useful in datastage?
What are data elements?
How to clean the datastage repository?
Why fact table is in normal form?
