Answer Posted / mitesh gaur

I think there is no need of using any aggregation. It's very
straight fwd, just sort the data on date and fetch only
first record.
Add the below query to source qualifier's SQL OVERRIDE
and that will be your result - (lets say table name is TmpTab)

select * from (select * from TmpTab order by date) where
rownum = 1;

now connect id, date to target.

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2134

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1092

---

What do you mean by enterprise data warehousing?

1066

---

where to store informatica rejected data?

1096

---

What are the components of the workflow manager?

1137

---

How are the sources and targets definitions imported in informatica designer?

1108

---

What are the different lookup cache(s)?

1118

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

1096

---

What are session parameters ? How do you set them?

1854

---

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

7456

---

What are the new features of informatica 9.x in developer level?

1001

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2268

---

What do you mean incremental aggregation?

1082

---

What is workflow? What are the components of the workflow manager?

1146

---

What are the new features of informatica 9.x developer?

970

---