Sunday, February 6, 2011

How to get last 50 records in miilion of records using Informtica


Use rank transformation and choose bottom 50...so that it
will load only last 50 records. there is option select BOTTOM
Number of Ranks : 50

2 comments:

  1. if there is no primary key how can it possibel to load last fifty records

    ReplyDelete
  2. Unix command

    $ tail 50 filename

    ReplyDelete