Answer Posted / murugan

only use the Aggregator function.....

first(sal>=values)

What is sq transformation?

1101

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7360

---

Briefly define reusable transformation?

1094

---

How can informatica be used for an organization?

1154

---

How to do unit testing in informatica? How to load data in informatica ?

1065

---

Can we create two repositories on same database instance in oracle?

1046

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2203

---

What are the new features of Power Center 5.0?

1724

---

What are multi-group transformations?

1035

---

Explain about cumulative Sum or moving sum?

995

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1893

---

What is the use of source qualifier?

1088

---

What does “tail –f” command do and what is its use as an Informatica admin.

1047

---

without table how to come first record only in oracle?

2218

---

How does the aggregator transformation handle null values?

1109

---