let us take column names as col1,col2,col3,col4 STEP1:Add normalizer and

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 / arunakumari l

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

Answer Posted / arunakumari l

let us take column names as col1,col2,col3,col4

STEP1:Add normalizer and place occurs value as 4

STEP2:use filter to eliminate null values

STEP3:take expression transformation and use concat
function to concatenate row values

i think this might work
tell me if i am wrong

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you load first and last records into target table?

1209

How would you copy the content of one repository to another repository?

1058

What is the advantage of informatica?

1123

What are the features of complex mapping?

1205

What is flashback table ? Advance thanks

1997

Difference between Data and Index Caches?

1200

How to do unit testing in informatica? How to load data in informatica ?

1181

How does a rank transform differ from aggregator transform functions max and min?

1262

can we override a native sql query within informatica? How do we do it?

1185

What is data transformation manager process?

1220

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2151

What is dynamic cache?

1085

How to extract the informatica rejected data?

1255

What does command task mean?

1215

What is the difference between source qualifier transformations source filter to filter transformation?

1094