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

which one is better performance wise joiner or look up

1068

Enterprise data warehouse your projects phase by phase explain?

1903

What are the types of presistent cache in look up tr.

2042

What is the session task and command task?

1031

What are junk dimensions?

1056

Explain load alternative records / rows into multiple targets - informatica

1135

What is workflow? What are the components of workflow manager?

1156

What are the different types of transformation available in informatica.

1080

in reporting we add some new objects,how we get the count of the newly added objects to the report

2173

How might you approve all mappings in the archive all the while?

1004

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1046

Explain what is informatica metadata and where is it stored?

1029

lookup transformation with screenshots

3983

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2705

explan ur project architecture?

2042