Answer / guest

BY USING FIRST FUNCTION, TO GET THE 1ST RECORD,
TO GET THE LAST RECORD , SIMPLY USE AGGREGATE
TRANSFORAMATION IN THIS DO NOT APPLY GROUP BY FUNCTION BY
DEFALUT IT WILL GENERATE LAST RECORD
OR
USE RANK TRANS
IN =>PROPERTIES NO OF TOP RANKS:1
NO OF BOTTOM RANKS:LAST RECORD

Answer / chandrasekar

I took the EMP table and we can use the below query in the
SQL override,

select * from emp where rownum=1 union select *
from emp where rowid=(select max(rowid) from
emp);

it will work.

Answer / kiran

take two rank transformations and take reusable sequence
generator connect the next value to both rank transformations
and in the rank transformations properties for the first one
take top and number of ranks as 1 for the second take bottom
and number of ranks 1 at the last take two instances of tgt
connect the ranktrans to two instances

what is a transforamation?

5 Answers  

---

my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica

3 Answers   HP,

---

How to eliminate duplicates in FF and oracle both

3 Answers   CSC,

---

What is the format of informatica objects in a repository?

0 Answers  

---

AT the max how many transformations and mapplets can we use in a mapping ?

1 Answers   Cap Gemini, Cognizant,

---

get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c

3 Answers   Infosys,

---

Why sorter is an active transformation?

0 Answers   Informatica,

---

Describe two levels in which update strategy transformation sets?

1 Answers  

---

Design time, run time. If you don't create parameter what will happen

0 Answers  

---

what is data driven?

5 Answers   TCS, Wipro,

---

How can we eliminate duplicate rows from flatfile,explain?

3 Answers  

---

how to calculate the optimum cache size in aggregator transformation?

1 Answers  

---