Answer Posted / brij

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

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1022

---

explain about unit testing? in real time?

2134

---

Whats there in global repository

1641

---

How we can create indexes after completing the load process?

1108

---

What are the advantages of using informatica as an etl tool over teradata?

969

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2076

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

2147

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2057

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1022

---

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.

1585

---

What are the popular informatica products?

958

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

1012

---

How to elaborate powercenter integration service?

1072

---

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 ?

7072

---

What is the cumulative sum and moving sum?

1136

---