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 type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

1 Answers   Qwest,

Suppose we do not group by on any ports of the aggregator what will be the output?

0 Answers  

What is the status code in stored procedure transformation?

0 Answers   Informatica,

I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,

Which will beter perform IIf or decode?

3 Answers   TCS,

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

What is the use of incremental aggregation?

2 Answers  

What are the types of lookup transformation?

0 Answers   Informatica,

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

0 Answers  

What is a unit Testing?

1 Answers  

What is session task and command task?

0 Answers  

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

3 Answers