Answer Posted / gyana

yes..very nice question

---------------------------
after SQ take two pipeline::::one to find 1st 3 record and another to find last 3 record
------------------------------------------
(1) from SQ connect an expression and into that expression connect a sequence generator to generate sequence.
After expression put a filter t/r (seq>=4) and pass to one target instance(T1)
(2) from SQ connect an expression and into that expression connect a sequence generator to generate sequence.
now take a RANK t/r and set the property as(bottom performer,rank on port SEQ,NUMBER OF rank=3).connect that to second target instance (T2)..it will give u last 3 records..

if any wrong pls send me mail......(gyana.informatica@gmail.com)

Enlist the differences between database and data warehouse.

543

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5767

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

548

---

What is expression transformation?

629

---

What is a mapplet/worklet in informatica?

680

---

---

How can you validate all mappings in the repository simultaneously?

752

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

601

---

can you please explain me pre session and post session options?

6357

---

what is $$$$?

1732

---

What is primary and backup node?

692

---

What is InformaticaPowerCenter?

680

---

How to update source definition?

624

---

How to load a Dimension ? and how to load a fact table?

949

---

what is the size of u r source(like file or table)?

1812

---

What does role playing dimension mean?

619

---