Answer / parthu

It may possible with Normalizer transformation.

Answer / letc

Using max function for q1,q2,q3,q4 in Aggregator transformation. Use sorter before aggregator

Answer / jj

without one more column its not possible i thing , it shoud
have prod or some thing

select prod,sum(q1),sum(q2),sum(q3),sum(q4) from (
select prod,(case when quarter='q1' then sal end) q1
,(case when quarter='q2' then sal end) q2
,(case when quarter='q3' then sal end) q3
,(case when quarter='q4' then sal end) q4 from za)
group by prod

Answer / ankit kansal

one solution can be like this


select max(q1) as q1,max(q2) as q2,max(q3) as q3,max(q4) as q4 from
(
select case when quarter = 'q1' then sales end q1
,case when quarter = 'q2' then sales end q2
,case when quarter = 'q3' then sales end q3
,case when quarter = 'q4' then sales end q4
,row_number() over ( partition by quarter order by 1 ) rnk

from sequel_test order by 5

)tb group by rnk order by 1,2,3,4

Answer / chandu

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

In a sequential batch can u run the session if previous session fails?

3 Answers  

What do you understand by a term domain?

0 Answers  

whats the option in informatica 7 version is outdated in informatica 8 version onwards.

1 Answers   iGate,

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,

How to do Integration testing in Informatica?

5 Answers   Intelligroup,

What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

7 Answers  

what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,

how we can do session partition in informatica any one explain me clearly? thanks advance.

1 Answers   iGate,

HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers   Patni, Wipro,

what are the Methods For Creating Reusable Transformations?

0 Answers   Informatica,

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

0 Answers