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

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2071

---

Implementation methodology

1721

---

Explian the Process of deployment groups in informatica

1064

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1161

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1152

---

What is the function of look up transformation?

1127

---

What is a transaction control transformation?

1214

---

Differentiate between a repository server and a powerhouse?

1125

---

What are the different components of powercenter?

1055

---

What is the reusable transformation?

1053

---

What are roles and groups and benefits of using them?

1058

---

What is the session task and command task?

1065

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4167

---

tell me 5 session failure in real time how can you solve that in your project?

2306

---

Where do we use mapping variables in informatica?

1075

---