Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete duplicate records if we have huge volume of
records in a table ?
(rowid is not the correct approach)
- 6 Answers
- 10029 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / chandu
select * from from <table_name> where rowid not in(select
min(rowid) from <table_name> group by column(primary or
unique key column))
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Is there any target staging area in informatica not staging area
What are the tasks that source qualifier perform?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How to open an older version of an object in the workspace?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Design a mapping to load a target table with the following values from the above source?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Differentiate between joiner and lookup transformation?
What do you understand by a term domain?
What are Dimensional table?
Explain about cumulative Sum or moving sum?
What is Index Caches size?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Enterprise data warehouse your projects phase by phase explain?
