My source table having some records ,i want load 1st record
and last record into one target?
- 3 Answers
- 8884 Views
- iGate, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
How to recover sessions in concurrent batches?
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
What are session parameters ? How do you set them?
Is informatica power center designer has 64 bit support?
How Union Transformation is an Active Trans?
As union transformation gives UNION ALL output, how you will get the UNION output?
is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?
when will we go for unconnected lookup transformation in Informatica?
What is a mapplet/worklet in informatica?
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y
what is the location of parameter file in informatica?
Teradata 
