Answer Posted / kalyan

I guess the below logic will solve this question..

Sq -> Expression T/R -> Aggr t/r -> Target

Create a constant port in Expression t/r and then pass the 3
fields id, date & const port to the aggregate t/r... Create
a new port calculating mindate.. Now do a group by on the
Const field ; connect id & min Date fields to the Target...

FYI, If u don't apply group by on any column of the table ;
can not calculate the Aggr values...

Please correct me if I am wrong...

Explain how many types of dimensions are available in informatica?

1110

---

Make a note of the quantity vaults made in informatica?

997

---

Explain lookup transformation in informatica

1083

---

Explain Dataware house architecture .how data flow from intial to end?

2593

---

What is decode in informatica?

1177

---

What you know about transaction control transformation?

1004

---

What all are steps in up gradation of Informatica server?

1052

---

What is intricate mapping?

1218

---

How to do unit testing in informatica? How to load data in informatica ?

1139

---

How we can create indexes after completing the load process?

1168

---

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

1007

---

In development project what is the process to follow for an etl developer from day1

1727

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2142

---

What is joiner transformation?

1018

---

What is informatica? Why do we need it?

1118

---