Answer / swetha

Two ways

1. Edit the definition

2. Reimport the defintion

if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,

---

my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?

3 Answers   ACS,

---

Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers  

---

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

0 Answers  

---

If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,

---

which one is better either active or passive transformation in informatica

1 Answers  

---

How to do Integration testing in Informatica?

5 Answers   Intelligroup,

---

Explain your project of banking domian.

0 Answers   Cap Gemini,

---

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  

---

what is the predefined port in dynamic lookup

2 Answers  

---

source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.

4 Answers   TCS,

---

Name the different lookup cache(s)?

0 Answers  

---