Answer / ankit kansal

Hi All,
select sales,sum(q1),sum(q2),sum(q3),sum(q4)
from
select 'sales' as sales
,case when quarter='q1' then sales else 0 end case as q1
...q2
...q3
...q4
)temp group by sales;

http://deepinopensource.blogspot.in/

Answer / senthil kumar s

It wouldn't work many to one concept for Normalizer.

Answer / gm

SQL:
select quarter, sales from table_name
group by quarter, sales;

Informatica:
Source-SQ-Exp-Normalizer Trans.-Tgt
In Normalizer Transformation we can do row into column.

What are the new features of informatica 9.x in developer level?

0 Answers  

---

can we import source table without using source qualifier? if yes then how? if no then why?

2 Answers   Thomson Reuters,

---

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 Answers  

---

how can we load starting with 11th record of a table from source to target

6 Answers   IBM,

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

0 Answers  

---

server hot-ws270 is connect to Repository B. What does it mean?

0 Answers   Cognizant,

---

How to Create a folder using pmrep command?

0 Answers  

---

How do you use reject loader.

0 Answers  

---

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

2 Answers   IBM,

---

How can you complete unrcoverable sessions?

1 Answers  

---

Design time, run time. If you don't create parameter what will happen

0 Answers  

---

What are the methods for creating reusable transforamtions?

2 Answers  

---