write a query for how to eliminate the duplicate rows
without using distinct?
Answer Posted / abhishek kumar
select id from tgt_table group by id;
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
What is dimensional table?
How big was your fact table
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?
Is it possible to define a single node as a Gateway node as well as worker node?
Differentiate between reusable transformation and mapplet.
How to partition the Session?
What are data-driven sessions?
What is a predefined event?
What is difference between a gateway node and worker node?
How do you load first and last records into target table?
What is a code page?
Mention a few design and development best practices for informatica?
Write the program through which the records can be updated?
What is a joiner transformation and why it is an active one?
What is InformaticaPowerCenter?