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
- 7998 Views
- Emphasis, I also Faced
- E-Mail Answers
Answer Posted / venkateshmalneni
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 |
Post New Answer View All Answers
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
According to his methodology what all you need before you build a datawarehouse
What are the databases that informatica can connect to windows?
what are the Methods For Creating Reusable Transformations?
What are mapplets? How is it different from a Reusable Transformation?
What are the static cache and dynamic cache in informatica?
Define enterprise data warehousing?
Can you use flat files in Mapplets.
What is the benefit of session partitioning?
What is update strategy transform?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
When do you use sql override in a lookup transformation?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How to use pmcmd utility command?
What is workflow monitor?
