Answer Posted / 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/

Did u used latest transformations of 8.6.0? for what?

1826

---

Where do we use mapping variables in informatica?

999

---

What is mapplet in informatica?

983

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2296

---

What do you mean by filter transformation?

904

---

How to extract sap data using informatica?

987

---

What is the difference between Active and Passive transformation?

1085

---

How do we call shell scripts from informatica?

1014

---

can anyone explain me about retail domain project in informatica?

7892

---

Clarify the utilization of aggregator cache record?

945

---

Explain the etl program with few examples.

968

---

How to update a particular record in target with out running whole workflow?

1536

---

What are the different lookup cache(s)?

1036

---

Explain informatica architecture - version 8 / 9

1025

---

What is the commit type if you have a transaction control transformation in the mapping?

973

---