My source table having some records ,i want load 1st record and last record int

My source table having some records ,i want load 1st record
and last record into one target?

Question Posted / chandumba2005

3 Answers
8630 Views
iGate, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

My source table having some records ,i want load 1st record and last record into one target?..

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

Is This Answer Correct ?

13 Yes

0 No

My source table having some records ,i want load 1st record and last record into one target?..

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.

Is This Answer Correct ?

7 Yes

0 No

My source table having some records ,i want load 1st record and last record into one target?..

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

Is This Answer Correct ?

1 Yes

0 No

Post New Answer