Question { CTS, 9009 }

write sql query following table

quarter sales
q1 1000
q1 2000
q1 3000
q1 4000
q2 5000
q2 6000
q2 7000
q2 8000
q3 1000
q3 2000
q3 3000
q3 4000
q4 5000
q4 6000
q4 7000
q4 8000
i want the output format like
q1 q2 q3 q4
1000 5000 1000 5000
2000 6000 2000 6000
3000 7000 3000 7000
4000 8000 4000 8000

Answer

In Expression transfermation, if( sales = q1,sales,0)

Question { HP, 9362 }

Converting Rows to columns
I have Relational source like his.
JAN FEB MAR APR
100 200 300 400
500 600 700 800
900 100 200 300

I need to convert these rows into columns to the targe.

MONTH TOTAL
JAN 1500
FEB 900
MAR 1200
APR 1500

Please experts help me

Answer

You will take Expression Transfermation.
In Expression Editon you can write lke this
sum(months) and group by month.

Question { HP, 9362 }

Converting Rows to columns
I have Relational source like his.
JAN FEB MAR APR
100 200 300 400
500 600 700 800
900 100 200 300

I need to convert these rows into columns to the targe.

MONTH TOTAL
JAN 1500
FEB 900
MAR 1200
APR 1500

Please experts help me

Answer

you will take Expression transfermation
and write expression like this

sum(months)

Question { Puma, 7681 }

select * from emp where sal>(select min(sal) from emp) how
to implement the same in informatica ?

Answer

In Mapping take two transfermations.
1.aggrigate transfermation
2.filter transfermation.
in aggrigate add one output port is minsal
minsal=MIN(SAL).next in filter condition SAL > minsal.

next link the ports to target.