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/

How to extract sap data using informatica? What is abap? What are idocs?

676

---

What are the features of complex mapping?

737

---

How can we use batches?

686

---

what is degenerated dimension?

3308

---

What is the difference between Active and Passive transformation?

736

---

---

What is the need of etl tools?

714

---

How are indexes created after completing the load process?

1094

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2011

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1411

---

How many ways a relational source definition can be updated and what are they?

664

---

Explain constraint based loading in informatica

748

---

What is complex mapping?

756

---

Different circumstance which drives informatica server to expel records?

634

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1725

---

What are the prerequisite tasks to achieve the session partition?

811

---