Answer / joe

We cannot use a sorter because it will shuffle the data.

For the last 20 rows. In a seperate pipeline use aggregator
and do a Count(key) and Max(key) to get the total number of
rows.
use an output port o_count and o_max to populate this count
to an expression transformation before the Filter.

o_count_last_20 = o_count - 20
i.e. if there are 35 records we need records from 15 to 35

In the filter check nextval between o_count_last_20 and
o_Max

Answer / sunny

Hello joe, your solution is partially correct - what if the
records are not in sequence to do MAX minus 20 ? I guess
this logic can be applied only after passing through
sequence generator, by getting a sequence number.

Answer / joe

1. Use a sequence generator to associate a NEXTVAL to the
row.

2. Filter condition : NextVal <=20


For source- dbase: Do a filter at SQ by including the
following condition . WHERE Rownum <=20

Answer / sri

For this you can write SQL query by TOP clause in expression
transformation.
Or else You can use Rank Transformation.

Answer / raju

You can also achieve using following flow in the mapping.

1)Create an out put port SNO in expression transformation
and connect it to NEXTVAL port in sequence generator
transformation.

2)Use sorter transformation.In sorter ,use SNO port as key
column and Direction is Descending.

3)Use filter transformation with filter condition as
SNO<=20.

In which transformation you cannot drag ports into it?

0 Answers   Informatica,

Explain the informatica workflow?

0 Answers  

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,

lookup transformation with screenshots

0 Answers   TCS,

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

1 Answers   Accenture,

How to import oracle sequence into Informatica?

3 Answers   Satyam,

can we load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,

Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  

What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,

what are the limitation of sorter transformation?

2 Answers   TCS,

can any one give some examples for pre sql and post sql(Except dropping and creating index).

0 Answers   Zensar,

I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?

1 Answers   Cognizant, HCL,