Answer Posted / lahari

There are multiple ways to do it.
1.if source is RDBMS then we can filter by selecting distinct option.
2.In sorter transformation select distinct.
3.In Aggregator transformation select all ports as group by key.

Explain constraint based loading in informatica

1096

---

How many types of sessions are there in informatica.please explain them?

1169

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1059

---

Global and Local shortcuts. Advantages.

2034

---

What is intricate mapping?

1206

---

What is an expression transformation in informatica?

1040

---

What does role playing dimension mean?

1045

---

how to load rows into fact table in data warehouse

1190

---

How many ways a relational source definition can be updated and what are they?

1018

---

What are the different types of transformation available in informatica.

1105

---

Define filter transformation?

1099

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5676

---

explain one complex mapping with logic? sales project?

6671

---

Define update strategy?

1230

---

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?

1512

---