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

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

1136

---

What are the differences between source qualifier and joiner transformation?

1137

---

How many types of sessions are there in informatica.please explain them?

1211

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1733

---

What is the difference between Active and Passive transformation?

1224

---

Explain sessions?

1140

---

What are the features of complex mapping?

1209

---

How do you handle two sessions in Informatica

1219

---

where to store informatica rejected data?

1139

---

What are the tasks that source qualifier perform?

1145

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1169

---

What is a joiner transformation?

1037

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7370

---

What are the components of Informatica? And what is the purpose of each?

1108

---

How can we store previous session logs?

1140

---