Answer Posted / guest

Let suppose the data are as these fields
A B C D
1000,null,null,null
null,2000,null,null
null,null,3000,null
null,null,null,4000

In the mapping take A,B,C,D as input ports.set 4 output
ports for the same 4 input ports like out_A,out_B,out_C,out_D.

For out_A output port set value like-IIF(ISNULL(A),1000,A).
Similary for out_B-IIF(ISNULL(B),2000,B)
likewise for C,D.

if you don't want to hard code 1000,2000 in the expressions
written above just create 4 variable port like
var_A,Var_B,var_C,var_D before creating the output ports and
each variable port set max(A) for var_A,max(B) for var_B
port likely.

put each variable port name against 1000,2000,3000 and 4000
in respective expression.
as example for out_A set IIF(ISNULL(A),var_A,A)

Now take 4 output ports to a aggrerator transformation.set
group by any one port but not all ports at a time.

Join the ports to target.

Hurry you get result like this

1000,2000,3000,4000

Regards

Sukanta

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1250

---

How to elaborate tracing level?

1217

---

What is the way to execute pl/sql script using informatica mapping?

1681

---

How can we handle two sessions in informatica?

1092

---

How do you handle two sessions in Informatica

1217

---

How many ways are there to create ports?

1402

---

Enlist the differences between database and data warehouse.

1164

---

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

2122

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2596

---

How many dimensions are there in informatica?

1134

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

1068

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1221

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2245

---

What are the different components of powercenter?

1112

---

Explain the scenario which compels informatica server to reject files?

1207

---