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
- 9924 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 staging area?
what is scd?
how do u move the code from development to production?
What are the different caches used in informatica?
Explain your project of banking domian.
What are the active and passive transforamtions?
when we dont use aggregator in mapping ?
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
Why is meant by direct and indirect loading options in sessions?
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
In which scenario did u used Mapping variable?
Teradata 
