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.

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

0 Answers   TCS,

What are pre and post-session shell commands?

0 Answers  

How can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 Answers   Accenture,

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

what is parameter file?

1 Answers   Cap Gemini,

In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?

2 Answers  

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

0 Answers  

How do you change parameter when you move it from development to production.

1 Answers  

how to declare array in plsql?

1 Answers  

how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy

2 Answers  

Mapplets can you use an active transformation in a mapplet,

1 Answers  

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

0 Answers