I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,

---

What are the disadvantages of Sequence Generator T/R?

3 Answers   Zensar,

---

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

8 Answers   BRAD, TCS,

---

How many ways are there to create ports?

0 Answers   Informatica,

---

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

0 Answers   TCS,

---

---

can anyone explain me about sales project in informatica?

8 Answers   MBT, Satyam,

---

Can anyone tell me the new features in Informatica 9 Version?

0 Answers   Syntel,

---

What do you understand by a term domain?

0 Answers  

---

What is Data Caches size?

0 Answers   Informatica,

---

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,

---

What is the difference between stop and abort in informatica

0 Answers   Informatica,

---

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

6 Answers   HCL, Schneider,

---