Answer Posted / nagaraju bhatraju

1.)
we can distinguish between unique and duplicate records in
informatica by using forward reference technique ,
in the sense , we can store the previous rec key value in
Variable_Port and can be compared with the previous rec key
value , but Data has to be come in sorted order on that key
column , for that we should use sorter transformation.

once if you find the duplicate rec by comparing , you can
flag that rec as dulicate and you can divert it to other
target.

2.) with out using sorter

in order to collect only unique records for flat file ,
just use aggregator before exp transformation, and check
group by on the key column where you are expecting
duplicate records. so you will get only unique records and
duplicate records will be eliminated.

What is the difference between Active and Passive transformation?

1081

---

What are the tasks that can be performed using sq?

1024

---

How many ways are there to do 'remove duplicate records in informatica'?

954

---

What are the types of presistent cache in look up tr.

2005

---

lookup transformation with screenshots

3939

---

What is the difference between router and filter?

1153

---

What do you understand by SOA of Informatica?

925

---

explain one complex mapping with logic? sales project?

6593

---

Can we override a native sql query within informatica?

987

---

Explain target update override in informatica

1043

---

What do you mean by worklet?

1017

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1914

---

How can we handle two sessions in informatica?

982

---

What are the different ways to implement parallel processing in informatica?

1340

---

what is the difference between informatica6.1 and infomatica7.1

2182

---