Interested to Buy Any Domain ? << Click Here >> for more details...
write a query for how to eliminate the duplicate rows
without using distinct?
- 6 Answers
- 12149 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / bharu_295
select count(*),col1,col2 ..... from table_name
groupby col1,col2.....
having count(*)>1
| Is This Answer Correct ? | 2 Yes | 9 No |
Post New Answer View All Answers
What is meant by lookup transformation? Explain the types of lookup transformation?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is the difference between informatica 7.0 and 8.0?
Why is sorter an active transformation?
Define Pmrep command?
Why do we need informatica?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How do you load first and last records into target table?
What is the surrogate key?
Explain transaction control transformation in informatica
How to update source definition?
How are the sources and targets definitions imported in informatica designer?
What do you mean incremental aggregation?
How to generate sequence numbers using expression transformation?
Explain Dataware house architecture .how data flow from intial to end?
