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
- 10162 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
Can we get 1st record through Informatica(without sequence number).
What is target designer and target load order?
How to load the data from a flat file into the target where the source flat file name changes daily?
Mention few power centre client applications with their basic purpose?
In informatics server which files are created during the session rums?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is powercenter on grid?
What is a repository? And how to add it in an informatica client?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Why filter transformation is an active one?
What is informatica etl tool?
Explain informatica architecture - version 8 / 9
What is deployment group?
What are the types of data warehouses?
Which means the first record should come as last record and last record should come as first record and load into the target file?
