Answer Posted / krishnakanthch

We can use the option 'SELECT DISTINCT' in the source
qualifier.

Anybody please tell me whether this works or not.

How do you load unique records into one target table and duplicate records into a different target table?

1180

---

lookup transformation with screenshots

3956

---

What is a pre-defined event and user-defined event?

990

---

Informatica settings are available in which file?

949

---

Partition, what happens if the specified key range is shorter and longer

2449

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1456

---

What is rank transformation?

944

---

How many numbers of sessions can one group in batches?

1035

---

What is the difference between source qualifier transformations source filter to filter transformation?

1008

---

have u done any performance tuning? how u ll do?

2259

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7349

---

What is data caches/ index caches?

1034

---

How to improve the performance of a session using sorter transformation?

1109

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1146

---

How to create or import flat file definition in to the warehouse designer?

1037

---