Answer Posted / 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;

Difference between Data and Index Caches?

1198

---

What are pre and post-session shell commands?

1380

---

What are the differences between oltp and olap?

1015

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1946

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1137

---

Clarify the aggregator change?

1076

---

Scheduling properties,whats the default (sequential)

2007

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1138

---

How to update or delete the rows in a target, which do not have key fields?

1219

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1152

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2067

---

How can we improve session performance in aggregator transformation?

1149

---

What is workflow? What are the components of the workflow manager?

1169

---

Explain in detail about scd type 1 through mapping.

1626

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1194

---