Answer / palthepu_santosh

from source qualifier map the column(id) into two fields of
rank (id,id_grp). select grp_id as group by and rank as 1
output should be
1
2
3

Answer / gyana

after source qualifier take a rank t/r
set the group by as column_id and in rank property set
# the number of rank=1
after that connect to target .you can get the desired result

SOURCE---->SQ--->RANK T/R----->TARGET

Answer / redflower

src->sq->aggregator->filter->target

from aggt/r we would calculate count(empid)
for eliminating duplicates we will write the filter condition
count(empid)=1

hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?

4 Answers  

---

Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

5 Answers   Flextronics,

---

How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,

---

why dimenstion tables are denormalized in nature ?

3 Answers  

---

Explain scd type 3 through mapping.

0 Answers  

---

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  

---

how we can add header and footer to flat files?

2 Answers   Tech Mahindra, Zensar,

---

How you know when to use a static cache and dynamic cache in lookup transformation?

0 Answers  

---

can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

1 Answers   Puma,

---

Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,

---

without using rank transformation how can we rank items by using some other transformations

2 Answers  

---

in which situations do u go for scds ?

3 Answers   TCS,

---