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
Posted by at

2 comments:

  1. UnknownMay 8, 2011 at 9:30 AM

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

    ReplyDelete
  2. UnknownAugust 21, 2012 at 2:18 AM

    Unix command

    $ tail 50 filename

    ReplyDelete

Subscribe to: Post Comments (Atom)