Answer / kish

Hi Krishna,

i think you r wrong...he is asking abt flat file...
by using LOOKUP we can eliminate duplicates...
You can eliminate duplicates and can capture that duplicates
using
dynamic lookup cache. look up the target table if New lookup
row=0 then it is unchanged (duplicate
record) SEND TO ONE TARGET

Answer / srinivas

we can do by using rank transformation also
select rank as 1 top or bottom what ever the ur requirement
and select the group by port for the duplicate column

Answer / sanjay

here i m taking the example of employee table

first use the sorter to get the distinct value....

then use the agg trns, create the output port and use the
count function on employee_id to get the total no. of rows
like.. count(employee_id) and group by employee_id.

create filter trns.. write a condition where output>1... map
it with the target...

Answer / krishna

The source qualifier Trns has select distinc option from thr we can eliminate duplicates

scd methodology?

2 Answers  

---

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  

---

A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers   HP,

---

How to join three sources using joiner? Explain though mapping flow.

0 Answers  

---

Explain informatica architecture - version 8 / 9

0 Answers   Informatica,

---

In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?

4 Answers  

---

PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U

2 Answers  

---

Please let me know how to make encryption and decryption with example?

0 Answers  

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

0 Answers   Informatica,

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

---

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

2 Answers   TCS,

---

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

---