we can also do it like this FIRST PIPELINE From sq

i have n number of records in my source, i want first and
last record to my target. how can u implement this scenario .

Question Posted / venkateshmalneni

6 Answers
8013 Views
Emphasis, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What is the difference between writing a joiner query in ANSI style and THETA style?

1917

What are the differences between a connected lookup and unconnected lookup?

647

How to differentiate between the active and passive transformations?

624

How do you change a non-reusable transformation to reusable transformation?

598

Under which circumstances, informatica server creates reject files?

589

What is the advantage of informatica?

648

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1463

Is it possible to use a client with different version than that of its Informatica server?

643

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10278

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1507

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1850

What are the types of presistent cache in look up tr.

1548

State the differences between sql override and lookup override?

622

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1651

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

1916