Question { IBM, 6583 }

I am hvaing SOURCE as first line: 1000,null,null,null
second line as:null,2000,null,null 3rd line
as :null,null,3000,null and final line as:
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

Answer

select no,max(col1),max(col2),max(col3),max(col4) from
tablename group by no;

Question { CTS, 14597 }

How will you update the row without using update statergy?

Answer

In target

there is a update override option is there using this one we
can update the records without using update strategy t/r

Question { Deloitte, 40689 }

How we can get unique records into one target table and
duplicate records into another target table??

Answer

data flow for this one is:

sq-->Aggregater-->Router-->target

in aggregater t/r take 2 output ports and give condition like

uniqe_port---->count(*)=1

duplicate_port--->count(*)>1

connect this one router and in router take 2 groups and
give condition like

uniqgroup=uniqe_port

duplicategroup=duplicate_port


and connect that groups to target