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 are the types of lookup transformation?

0 Answers   Informatica,

---

need for registering a repository server

1 Answers  

---

why we use informatica in our project?

2 Answers   TCS,

---

What are the options in the target session of update strategy transsformatioin?

2 Answers  

---

To achieve the session partition what r the necessary tasks u have to do?

1 Answers  

---

In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?

6 Answers  

---

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,

---

can we import source table without using source qualifier? if yes then how? if no then why?

2 Answers   Thomson Reuters,

---

What is update override?

1 Answers   Accenture,

---

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

7 Answers   L&T,

---

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,

---

what is the exact meaning of domain?

3 Answers  

---