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
- 10188 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
AGGREGATOR default datatype
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Define project in datastage?
What could be a data source system?
What are the steps needed to create a simple basic datastage job?
How to read the length of word in unix?
What is the difference between in process and inter process?
What is job control?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is the purpose of pivot stage and types of containers in datastage
Can you implement SCD2 using join, transformer and funnel stage?
Why do we use link partitioner and link collector in datastage?
What is the importance of the exception activity in datastage?
