Answer / 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

Answer / kondeti srinivas

it is so simple
write a query like this

SELECT MAX(A),MAX(B),MAX(C),MAX(D) FROM TABLE_NAME

Answer / adisekhar

FROM THE ABOVE ANSWER WE HAVE TO ADD NORMALIZER TRANSFORMATION

Answer / madhavi

In the lookup transformation->properties->presql condtion
write delete from table_name where column_name="NULL";.

Answer / 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

connected and unconnected lookups?

4 Answers  

What is limitations of truncate and load option

1 Answers   Cap Gemini,

Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,

How we can create indexes after completing the load process?

0 Answers  

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

How to import oracle sequence into Informatica?

3 Answers   Satyam,

How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)

5 Answers   TCS,

How to start a workflow using pmcmd command?

0 Answers  

What is blocking transformation?

0 Answers   Informatica,

what is workflow varible

1 Answers   HP,

write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80

3 Answers   iGate,

what is incremental aggregation ,with example?

2 Answers