Answer / 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

Answer / chandrasekar

Please try the SQL query in the SQL override,

select * from emp where rownum=1 union select *
from emp where rowid=(select max(rowid) from
emp);


if it wrong means please mail to me chandranmca2007@gmail.com

Answer / rakesh

Hi Chandrasekar,

My intension was to specify the column that is generated using sequence generator as RANK PORT. So no matter of sorting..

Thanks.

Answer / chandrasekar

Hi Rakesh,

Please go through the above question because don't sort the
records what have the source as it is to load the records
for first and last.

Answer / srinivas bolusupati

Use sequence generator t/r and give the nextval link
to 2 rank transformations, 1st one with top1 and 2nd one with bottom1 and connect them to 2 instances of target..

Answer / rakesh

use 2 rank transformations, 1st one with top1 and 2nd one with bottom1 and connect them to 2 instances of target..

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

2 Answers   IBM,

How to retrieve last two days updated records?

4 Answers  

What are the ETL tools available in DWH?

6 Answers   Mphasis,

wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,

we have to use order by,where,having we to implement sql query

1 Answers   Satyam,

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   CompuSoft, EDS, TCS,

How to send duplicates to one target and unique rows to one target?target is empty

9 Answers   Amazon, IBM, Wipro,

how i will stop my workflow after 10 errors

1 Answers   HP,

Why update strategy and union transformations are active? Explain with examples.

0 Answers  

What are the different tools in workflow manager?

1 Answers  

What do you mean incremental aggregation?

0 Answers  

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 Answers