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)

what is fact and what types of fact tables is there

4 Answers   Cap Gemini,

i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.

3 Answers  

What is deployment group?

0 Answers  

What is informatica? What exactly are the practical uses in real world

2 Answers  

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,

Enlist the differences between database and data warehouse.

0 Answers  

Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,

Informatica settings are available in which file?

0 Answers   Informatica,

What is difference between partioning of relatonal target and partitioning of file targets?

2 Answers  

What is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,

How do you do error handling in Informatica?

1 Answers  

When to use normalization transformation other than cobol source?

2 Answers