i have n number of records in my source, i want first and
last record to my target. how can u implement this scenario .
- 6 Answers
- 8911 Views
- Emphasis, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
we can also do it like this
FIRST PIPELINE
From sq connect all the ports to expression t/r and by using sequence generator t/r generate sequence number.
From expression t/r connect the all the ports to the filter t/r write a condition sno=1.
from filter t/r connect all the ports to the target
SECOND PIPELINE
From sq connect all the ports to Aggrigator t/r and dont group by any port,connect the ports to the target
THE DATA FLOW DIAGRAM WILL BE LIKE THIS
sequencegenerator
|
\|/
src--->sq--->expression--->filter--->trg
|
|-->aggrigator--->tgr
I think this will work
| Is This Answer Correct ? | 12 Yes | 1 No |
Please try the SQL query in the SQL override,
select * from emp where rownum=1 union select *
from emp where rowid=(select max(rowid) from
emp);
if it wrong means please mail to me chandranmca2007@gmail.com
| Is This Answer Correct ? | 8 Yes | 3 No |
Hi Rakesh,
Please go through the above question because don't sort the
records what have the source as it is to load the records
for first and last.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / srinivas bolusupati
Use sequence generator t/r and give the nextval link
to 2 rank transformations, 1st one with top1 and 2nd one with bottom1 and connect them to 2 instances of target..
| Is This Answer Correct ? | 0 Yes | 0 No |
what is polling?
where actually the usage of push down optimization happens...
What are the associated ports in look up T/R.
What are the new features of the server manager in the informatica 5.0?
I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?
How many transformations can be used in mapplets.
What is the use of target designer?
In a table, 4 person having same salary. How to get Third person record only?
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
what is difference between mapping and mapplet ?
how do the project develops? pls specify right from the start to end in step by steps.
My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...
Teradata 
