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.

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  

---

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

---

Different sorts of metadata that stores in the storage facility?

0 Answers  

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers   IBM,

---

Do you have knowledge in ralph kimball methodology

1 Answers  

---

---

what are the Methods For Creating Reusable Transformations?

0 Answers   Informatica,

---

What is surrogate key?

9 Answers  

---

Differentiate between a repository server and a powerhouse?

0 Answers  

---

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,

---

any body can say about all versions of informatica ?how many versions ?

2 Answers  

---

What are the informatica performance improvement tips

0 Answers   Informatica,

---

What is fact table? Explain the different kinds of facts.

0 Answers  

---