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
- 9697 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 |
Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?
What is predefined event?
To import the flat file definition into the designer where should the flat file be placed?
Can you access a repository created in previous version of Informatica?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
what are the Methods For Creating Reusable Transformations?
how to insert header after each group.
How can we get multiple output values using an unconnected lookup transformation?
What is the functionality of update strategy?
What are the data movement modes in informatcia?
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
Teradata 
