Answer / 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.

How will u find weather dimension table is big in size of a fact table?

1 Answers  

---

what is lookupoverriding?

1 Answers  

---

What is the benefit of session partitioning?

0 Answers  

---

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

---

what is mean by flag 4 in update strategy t/r

6 Answers  

---

What are the static cache and dynamic cache in informatica?

0 Answers  

---

Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,

---

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

0 Answers   Informatica,

---

What are the mapping parameters and mapping variables?

0 Answers   Informatica,

---

What is a filter transformation?

0 Answers  

---

how can i invoke pmcmd in command line prompt

1 Answers  

---

What you know about transaction control transformation?

0 Answers  

---