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 the etl program with few examples.

968

---

Briefly define a session task?

1057

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1039

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2240

---

What is domain and gateway node?

1122

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

2152

---

What is a difference between complete, stop and abort?

1034

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1841

---

What do you understand by term role-playing dimension?

983

---

What is meant by LDAP users?

1114

---

Differentiate between a repository server and a powerhouse?

1047

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2296

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2353

---

Describe expression transformation?

1045

---

What is an expression transformation in informatica?

964

---