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
- 9979 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
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What happens when a session fails and you click on recover?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is informatica etl tool?
How do you handle two sessions in Informatica
Write the advantages of partitioning a session?
What are the components of the workflow manager?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
can you please explain me pre session and post session options?
How to extract sap data using informatica? What is abap? What are idocs?
Target increases every day even though no new record was inserted
How do you convert single row from source into three rows into target?
Write the different tools in the workflow manager?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
