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 ?

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


Please Help Members By Posting Answers For Below Questions

What are the components of datastage?

656


How we can covert server job to a parallel job?

599


Different ways a project can be moved to production ?...example ….export-import and Version control.

1935


Why fact table is in normal form?

678


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

1720






What is apt_config in datastage?

702


Can you define merge?

668


how to implement scd2 in datastage 7.5 with lookup stage

5131


Define Merge?

879


Give an idea of system variables.

589


What are the functionalities of link partitioner?

620


Difference between data warehousing and olap?

653


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?

1784


what is the use of skid in reporting?

1957


Define repository tables in datastage?

704