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

Explain the use of aggregator cache file?

1256

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1963

---

tell me the rules and responsblites in our project(my project is development)

1933

---

How are indexes created after completing the load process?

1647

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1979

---

Partition, what happens if the specified key range is shorter and longer

2499

---

What will be the approach?

979

---

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

1012

---

Explain the scenario which compels informatica server to reject files?

1168

---

How can we handle two sessions in informatica?

1033

---

What is the command used to run a batch?

1064

---

What is different between the data warehouse and data mart?

1066

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2264

---

how tokens will generate?

2204

---

What are the different options available for update strategy?

1004

---