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

Can you filter data in hashed file?

3363


What is size of a transaction and an array means in a datastage?

754


What a datastage macro?

651


Distinguish between informatica & datastage. Which one would you choose and why?

598


What are orabulk and bcp stages?

664






how to add a new records into source?

1540


How a source file is populated?

629


How can one find bugs in job sequence?

802


1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

1668


What is the difference between operational data stage (ods) and data warehouse?

689


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2024


Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

645


How do you generate sequence number in datastage?

636


What are the differences between datastage and informatica?

586


what is the custome stage in datastage? how can we impliment that one? plz tell me

1920