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
- 8310 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
Define repository tables in datastage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
How many areas for files does datastage have?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
State the difference between an operational datastage and a data warehouse?
Highlight the main features of datastage?
Explain connectivity between datastage with datasources?
options available in sequence job to run,validate?
What are stage variables?
What are the types of views in datastage director?
client know skid info?
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.
How complex jobs are implemented in datstage to improve performance?
Is it possible to query a hash file?
