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
- 9943 Views
- Infotech, I also Faced
- E-Mail Answers
Answer Posted / shar
Vaibhav can u plz explain how an sql query is written b/t
seq file and oralce table in oracle stage delete query?
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the steps required to kill the job in Datastage?
What is meta stage?
What is process model?
How do y read Sequential file from job control?
How complex jobs are implemented in datstage to improve performance?
What are the functionalities of link collector?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
how to abort the job its matain duplicates?
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)
Is the value of staging variable stored temporarily or permanently?
What is use Array size in datastage
What could be a data source system?
Where do the datastage jobs get stored?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
In Datastage, how you can fix the truncated data error?
