Answer / srikanth

select (select marks from sub where subject='maths') maths,
(select marks from sub where subject='science') science,
(select marks from sub where subject='social') social from
sub group by 1;

Answer / brij

select
decode(subject,'maths',mark) maths
,decode(subject,'science',mark) science
,decode(subject,'social',mark) social
from <<table>>

Answer / keshava

We can use pivot finction on 11g instead of multiple
decodes.

How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica

1 Answers  

---

Types of error logs in Informatica?

2 Answers  

---

Briefly define a session task?

0 Answers  

---

what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,

---

How to create a non-reusable instance of reusable transformations?

0 Answers   Informatica,

---

Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks

4 Answers  

---

scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  

---

What is the default join that source qualifier provides?

3 Answers   Informatica,

---

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

2 Answers   CTS,

---

In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?

3 Answers  

---

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  

---

Explain the shared cache and re-cache?

0 Answers  

---