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
How to generate sequence numbers?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What are the modules in Power Center
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What are the differences between a connected lookup and unconnected lookup?
How to load a Dimension ? and how to load a fact table?
How can you differentiate between powercenter and power map?
whats the logic to load the lower level of granularity of data to fact table.
How can repository reports be accessed without sql or other transformations?
What are the informatica performance improvement tips
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
According to his methodology what all you need before you build a datawarehouse
How do you handle two sessions in Informatica
What is joiner transformation in informatica?
tell me about your project functionality