Answer Posted / brij

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

Different qualification between a related rotate toward the sky and isolates look upward?

984

---

Design a mapping to load a target table with the following values from the above source?

1338

---

What are active transformations.

1648

---

Explain sessions?

1050

---

What are multi-group transformations?

1086

---

What is the difference between informatica 7.0 and 8.0?

1009

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2132

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3698

---

How do you promote a non-reusable transformation to reusable transformation?

1132

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1631

---

What is the need of an ETL tool?

1081

---

Explain the different dimensions.

956

---

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3861

---

Explain the mapping variable usage example in informatica

1155

---

How does the aggregator transformation handle null values?

1145

---