How to delete duplicate records if we have huge volume of
records in a table ?
(rowid is not the correct approach)
Answer Posted / cmanojkumar
Hi,
Thanks for your answer.
I am sorry this question i need to post in oracle forum not
informatica.
Any way your answer is usefull for me.
Could you please tell me how can we delete with our rowid in
oracle ?
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is flashback table ? Advance thanks
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is the use of source qualifier?
What is sequence generator transformation in informatica?
How many numbers of sessions can one group in batches?
What is meant by incremental aggregation?
What is the function of union transformation?
What does update strategy mean, and what are the different option of it?
Write the unconnected lookup syntax and how to return more than one column.
What is joiner transformation in informatica?
What are the new features of Power Center 5.0?
Can anyone tell me the new features in Informatica 9 Version?
Separate from an archive server and a powerhouse?