Answer Posted / purushotham perumalla

Create variable ports in Expression transformation to
concat name if the number is same as follows

Assume the input field names are number and name

define the variable ports in expression transformation in
the following order

v_flag = iif(number = v_number,0,1)
v_name = iif(v_flag = 1,name,v_name ||' '||name)
v_number = number
O_name = v_name

The output of o_name will be as follows

number o_name
----------------
101 raja
101 raja sekar
101 raja sekar reddy


Add an aggregator transformation after expression and group
by number. output number and o_name from aggr to target.
As aggr outputs last row in each group by deault it will
send 101 raja sekar reddy to the output.

What is complex mapping?

1127

---

What differs when we choose the sorted input for aggregator transformation?

1034

---

What are session parameters ? How do you set them?

1857

---

What all join we can perform in LOOKUP transformation?

991

---

Differentiate between reusable transformation and mapplet.

1105

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1153

---

How to load a Dimension ? and how to load a fact table?

1423

---

Define pmcmd command?

1049

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1045

---

have u done any performance tuning? how u ll do?

2303

---

What are the types of data warehouses?

1528

---

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

2430

---

How to generate sequence numbers without using the sequence generator transformation?

1215

---

 Informatica Checkpoints

3334

---

How to load the data from people soft hrm to people soft erm using informatica?

1025

---