Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9740 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 |
can we use bulk loading when we use look in mapping
what is the complex transformation you used in informatica
What is the command used to run a batch?
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .
What is dynamic cache?
what are the Methods For Creating Reusable Transformations?
How to generate sequence numbers without using the sequence generator transformation?
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
What is lookup transformation?
how to get max value record into one target and remaining records into another target?
As union transformation gives UNION ALL output, how you will get the UNION output?
Teradata 
