Answer Posted / abhinav prakash

1.Pass the ports to an expression t/r.
create a dummy port and give the value as '1'
2.Pass only the salary port to an Aggregator t/r.
Create a dummy port with the same data type and column name
and value as expression.
create o/p port:max(salary)
3.Join these 2 t/r using joiner and join on the dummy port.
ensure u have checked the sorted input option.
4Pass the o/p to the target.

Define Pmrep command?

1070

---

What are the differences between joiner transformation and source qualifier transformation?

1179

---

How might you approve all mappings in the archive all the while?

1020

---

What is domain and gateway node?

1172

---

where to store informatica rejected data? How to extract the informatica rejected data?

1008

---

What is the use of transformation?

1002

---

What are the types of caches in lookup?

1053

---

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

2428

---

What is the advantage of informatica?

1069

---

How to update source definition?

1100

---

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

1095

---

Define the various join types of joiner transformation?

990

---

What's the layout of parameter file (what does a parameter file contain?)?

2390

---

Clarify the utilization of aggregator cache record?

1007

---

According to his methodology what all you need before you build a datawarehouse

1761

---