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 is the maplet?

0 Answers   Informatica,

---

How to eliminate duplicates from flat file..what is the procedure

4 Answers  

---

how do u get the first record from 50,000 records ?

10 Answers   TCS, UBS,

---

i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers   Deloitte,

---

what is shared Cache. when we will use shared Cache?

4 Answers  

---

what is the function of 'F10' informatica ?

4 Answers   IBM,

---

what is shared lookup&persistent lookup?

4 Answers   Accenture, Cap Gemini,

---

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,

---

I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 Answers  

---

Without using any transformations how u can load the data into target?

15 Answers   IBM,

---

we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,

---