Answer / bsgsr

i believe this should work.

1) use the first and last functions of aggregate t/tion.
2) use the top option and 1 rank using rank t/tion
similarly last option and 1 rank to get only the first
and lst records.
3) else connect the flat file to filter t/tion. create new
port in filter name it s_no and connect the nextval port of
s.gen and write the contion (assume the file contains 100
records) like s_no=1 or s_no=100

is it possible to index the data in cache of lkp transformation ?

0 Answers  

---

how to get flatfile containg 10 records half records one target another half another target

2 Answers  

---

How to add source flat file header into target file?

3 Answers   Logica CMG,

---

Can anyone briefly describe abt audit table loading?

2 Answers   TCS,

---

What is the diff. b/w informatica versions 8.1.1 and 8.6.1?

4 Answers   IBM, Wipro,

---

Whatis the difference between View and Materialized View ?

11 Answers   Satyam, Syntel,

---

Explain the pipeline partition with real time example?

0 Answers   Informatica,

---

write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,

---

what is materialized view?

2 Answers  

---

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers   HP,

---

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in

1 Answers  

---

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

3 Answers  

---