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.

how to remove staging area

1 Answers  

---

Explain the etl program with few examples.

0 Answers  

---

What are the different versions of informatica?

0 Answers  

---

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

3 Answers   CTS,

---

how can u tune u r informatica mapppings

2 Answers   CTS,

---

Which is the best place to learn Informatica Powercenter Online Training?

1 Answers  

---

Why update strategy and union transformations are active?

0 Answers  

---

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,

---

What are the popular informatica products?

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,

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

0 Answers  

---

when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?

7 Answers   Cegedim, IBM, TCS,

---