FROM THE ABOVE ANSWER WE HAVE TO ADD NORMALIZER TRANSFORMATION

I am hvaing SOURCE as
1000,null,null,null
null,2000,null,null
null,null,3000,null
null,null,null,4000

Now i want the OUTPUT as

1000,2000,3000,4000

For more clarification i want to elimate nulls and want in
a single line.

Please help me out

Question Posted / adisekhar

5 Answers
9872 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / adisekhar

FROM THE ABOVE ANSWER WE HAVE TO ADD NORMALIZER TRANSFORMATION

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is InformaticaPowerCenter?

1138

What is the function of look up transformation?

1126

Explain the difference between mapping parameter and mapping variable?

1045

Why filter transformation is an active one?

990

What is the difference between router and filter?

1276

What is rank transform?

1002

Design time, run time. If you don't create parameter what will happen

1837

What is session task and command task?

1305

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

1617

What are the different types of olap? Give an example?

1057

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2016

What is the reusable transformation?

1052

draw informatica architecture 8.6 ?

3877

What is powercenter on grid?

1183

What are the conditions needed to improve the performance of informatica aggregator transformation?

1100