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
- 9936 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
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
How many areas for files does datastage have?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is the use of datastage designer?
Where do you see different stages in the designer?
What are the differences between datastage and informatica?
Difference between data warehousing and olap?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
How can you write parallel routines in datastage PX?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is meta stage?
How will you move hashed file from one location to another location?
How to Remove Duplicate using SQL?
What is ibm datastage flow designer?
