Simple job: SEQ>>>ORACLE_STAGE. in ORCL

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 ?

Question Posted / vinod upputuri

5 Answers
10377 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

Please Help Members By Posting Answers For Below Questions

Define project in datastage?

1148

What is data partitioning?

1266

What are transforms and what is the differenece between routines and transforms?

1105

How to read multiple files using a single datastage job if files have the same metadata?

1299

What a datastage macro?

1101

What is the purpose of pivot stage and types of containers in datastage

1082

What is oci?

1352

Differentiate between datastage and datastage tx?

1111

Define data aggregation?

1147

what is use of SDR function?

5222

How the ipc stage work?

1170

What are constraints and derivations?

1210

What is the command line function to import and export the ds jobs?

1189

explain about citrix scheduling tool in datastage

2509

Name the command line functions to import and export the DS jobs?

1199