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.

Which one is better performance wise connected/un-connected lkp?why?

2 Answers   HCL, TCS,

---

How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 Answers  

---

How do you implement unconn. Stored proc. In a mapping?

1 Answers  

---

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,

---

In ur current projectu have done any performance tuning of mappings?

1 Answers  

---

What are the mapings that we use for slowly changing dimension table?

2 Answers  

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

0 Answers   TCS,

---

What is the difference between Normal load and Bulk load?

5 Answers  

---

who is the best faculty for informatica in hyderabad ameerpet?

1 Answers  

---

how can run the wf through pmcmd commend? write script?

2 Answers   Cap Gemini,

---

How mapping parameter and variable works

1 Answers  

---

How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,

---