Answer Posted / keyrun

Hi, There are many ways to delete the duplicates!

By Using the following Transformations you can delete the Duplicates:

Source Qualifier: Use SQ and check 'Distinct' property (If the Source is Relational)

Sorter: Use sorter and in Properties tab Check 'Distinct'(If the Source is Flat File)

Aggregator: Use Aggregator & Group by on the key port.

What is depict expression change?

1120

---

What is fact table? Explain the different kinds of facts.

1076

---

Is it possible to use a client with different version than that of its Informatica server?

1141

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1953

---

How to extract sap data using informatica? What is abap? What are idocs?

1182

---

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

1146

---

 Informatica Checkpoints

3330

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2745

---

What can we do to improve the performance of informatica aggregator transformation?

1095

---

How do you set a varible in incremental aggregation

1891

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1171

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1105

---

Explain sessions and how many types of sessions are there?

1010

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1079

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2168

---