Answer Posted / jj

without one more column its not possible i thing , it shoud
have prod or some thing

select prod,sum(q1),sum(q2),sum(q3),sum(q4) from (
select prod,(case when quarter='q1' then sal end) q1
,(case when quarter='q2' then sal end) q2
,(case when quarter='q3' then sal end) q3
,(case when quarter='q4' then sal end) q4 from za)
group by prod

Define mapping and session?

968

---

What are the different lookup cache(s)?

1033

---

Is it possible to revert a global repository to local one and why?

1023

---

What do you mean incremental aggregation?

1010

---

What is informatica worklet?

987

---

What are active and passive transformations?

1020

---

what is song in infrmatica...?

2162

---

Briefly describe lookup transformation?

982

---

Enlist the tasks for which source qualifier transformation is used.

981

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

9972

---

Can we create two repositories on same database instance in oracle?

1015

---

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

1740

---

What is data transformation manager process?

1078

---

Explain joiner transformation in informatica

1074

---

what is the hint? how to use it to reduce the query processing in program?

7629

---