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

How can you differentiate between powercenter and power map?

1019

---

Explain the scenario which compels informatica server to reject files?

1091

---

can anyone suggest best free Talend data integration training online

1623

---

How might one distinguish in the case of mapping is right or not without associating session?

1028

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1088

---

What is confirmed fact in dataware housing?

6803

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2057

---

Can informatica load heterogeneous targets from heterogeneous sources?

1121

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1092

---

What do you mean by blocking transformation?

972

---

what is the size of your data warehousing?

2044

---

What is lookup transformation?

1004

---

The question was on time stamp. what is the difference between HH and HH24 when to use when.

1995

---

Is there any target staging area in informatica not staging area

2508

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5688

---