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
- 9145 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
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Explain connectivity between datastage with datasources?
How we can covert server job to a parallel job?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Highlight the main features of datastage?
options available in sequence job to run,validate?
How do you start developing a datastage project?
Define repository tables in datastage?
why do u need the IOS upgradation in a FC switch
If you want to use the same piece of code in different jobs, how will you achieve it?
what is ds administrator used for?
Where do the datastage jobs get stored?
Describe routines in datastage? Enlist various types of routines.
How to reverse the string using unix?
What is oci?
