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

How you load distinct records into one target and duplicate records into another target?

3 Answers   Mphasis,

---

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,

---

how u know when to use a static cache and dynamic cache in lookup transformation.

9 Answers   Accenture,

---

what is the diff b/w target load plan and cbl?

3 Answers   CTS, iGate,

---

What are the uses of a Parameter file?

3 Answers   CSC,

---

how to delete duplicate records by using filter transfermation?

3 Answers  

---

What do you mean incremental aggregation?

0 Answers  

---

What is different between the data warehouse and data mart?

0 Answers  

---

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers   TCS,

---

Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.

3 Answers   IBM,

---

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

---

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers   IBM,

---