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.

Write the program through which the records can be updated?

1054

---

Sequence generator, when you move from develoment to production how will you reset

2124

---

What is primary and backup node?

1174

---

Explain your project of banking domian.

1694

---

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

1955

---

Where is metadata stored?

1193

---

How to load last n records of file into target table - informatica

1133

---

Is it possible to define a single node as a Gateway node as well as worker node?

1184

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9899

---

What do you mean by blocking transformation?

1118

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5789

---

How to use pmcmd utility command?

1077

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1958

---

What is InformaticaPowerCenter?

1177

---

Name the different lookup cache(s)?

1292

---