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
- 9929 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 main features of Oracle 8i with context to datawarehouse?
What is the need for an etl tool?
How do you convert single row from source into three rows into target?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Define the various join types of joiner transformation?
Where is metadata stored?
What is Cognos script editor?
While migrating the data from one environment to another environment how would you manage the connections?
In how many ways we can create ports?
What are the transformations that are not supported in mapplet?
4 yrs etl devloper roles and responsibilities?any body give solutions
Under which circumstances, informatica server creates reject files?
scenario where i can use only concurrent execution of workflow.
What is a code page?
What is data transformation manager process?
