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/

What if the source is a flat-file?

1069

---

Can we get 1st record through Informatica(without sequence number).

1433

---

How to differentiate between the active and passive transformations?

1107

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2108

---

How does the aggregator transformation handle null values?

1112

---

How do you convert single row from source into three rows into target?

1116

---

What is the difference between Active and Passive transformation?

1109

---

What is transformation?

1070

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1112

---

What are different types of transformations available in informatica?

957

---

what are the Methods For Creating Reusable Transformations?

1127

---

What are the types of data warehouses?

1459

---

Can we create a Integration service without a Repository service and vice versa?

1191

---

Explain in detail scd type 2 through mapping.

1009

---

How to configure mapping in informatica?

1143

---