Answer / venky

after sq transformation use exp transformation in that add
one port,and take seq generator trans and its properties
reset is enable,and link to the port in exp trans,after
that take filter trans and condition port>3,after that use
sorter trans in that take port desc,after that take exp
trans and create another new port,after that take seq gen
trans in properties resert as enable and link to the new
port,afer that use filter trans condition new port>3 and
connect to target.

this is the process u can do u wil get the result.pls try it
correctly

Answer / 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)

Answer / shaik

if i don't want to change the order of source data,then how
can we perform.....

Answer / davankumar p

2 pipelines,1st pipeline sorter t/r ascending order then
rank t/r top3
2nd pipeline sorter decending order then rank top3 t/r

What do you mean by worklet?

0 Answers  

---

In joiner, how to load Master table in Target?

2 Answers  

---

what is the use of Data Mart?

5 Answers   IBM,

---

we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.

8 Answers  

---

Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  

---

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers   Polaris, Zensar,

---

Which transformation should we use to normalize the COBOL and relational sources?

4 Answers   DELL, IBM, Lehman Brothers,

---

which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?

6 Answers   IBM,

---

how to we create datamart?

2 Answers   HSBC,

---

What all are steps in up gradation of Informatica server?

0 Answers  

---

what is metadata?

8 Answers   Satyam,

---

How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers   TCS,

---