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
- 10366 Views
- Infotech, I also Faced
- E-Mail Answers
Answer Posted / vaibhav
We can perform inner join between seq file & oracle stage and then in target oracle stage have write method as Delete where we can specify delete query using orchestrate incoming rows..
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the repository tables in datastage?
What are the functionalities of link partitioner?
Where do the datastage jobs get stored?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
How to clean the datastage repository?
Describe link sort?
how can we create rank using datastage?what is the meaning of rank?
How many areas for files does datastage have?
Explain the importance of surrogate key in data warehousing?
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)
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What are the some differences between 7.x and 8.x version of datastage?
How many types of views are there in a datastage director?
What are the types of jobs we have in datastage?
How to implement complex jobs in data stage?
