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
9866 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

what is Active lock explain

2800

What are the new features of informatica 9.x developer?

970

Can we create a Integration service without a Repository service and vice versa?

1215

Explain the use of aggregator cache file?

1257

Is there any way to read the ms excel datas directly into informatica?

1022

What are the new features of informatica 9.x at the developer level?

1043

What are the types of caches in lookup? Explain them.

971

Reusable transformation and shortcut differences

1840

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1206

Explain how many types of dimensions are available in informatica?

1098

Define sessions in informatica etl?

1035

Explain load alternative records / rows into multiple targets - informatica

1153

What is rank transform?

998

What are the tasks that can be performed using sq?

1093

How many ways are there to do 'remove duplicate records in informatica'?

1015