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
- 9944 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
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Difference between server jobs & parallel jobs?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What are stage variables?
What are the important features of datastage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Can you explain repository tables in datastage?
what are the devoleper roles in real time? plz tell i am new to datastage....
What is the purpose of pivot stage and types of containers in datastage
Define Merge?
Why do we use exception activity in Datastage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What are the difference types of stages?
What are the functionalities of link collector?
What is the process of killing a job in datastage?
