Skip to main content

Load last n records of file into target table – Informatica

By


SQ->SG->AGG->ROUTER->TGT



AGG-> MAX(SNO)

ROUTER->MAX(SNO)-N The default port in router will give u the last n records.
Labels:

Comments

  1. Unknown20 February 2014 at 09:40

    Use aggregator without any group by ports which will give last record by default--Sadik

    ReplyDelete
  2. Anonymous31 August 2014 at 13:42

    use sequence generator t/r in exp t/r. use sorter t/r for descending . and use filter t/r to get n top numbers.

    ReplyDelete
  3. pdprasad17 September 2014 at 12:52

    Is it possible to this with Rank tr. ?

    ReplyDelete
  4. AJINKYA7 October 2014 at 05:23

    Use SNO=CURVAL from SG to find out last record.
    Then select SNO-N records

    ReplyDelete
  5. Unknown3 November 2014 at 09:40

    use variable port to generate ids in exp trans

    variable port vid(integer) = vid+1;
    output port oid(integet)=vid;

    pass data to sorter, sort by oid desc
    now pass data to exp tr, again generate ids

    variable port vidN(integer) = vidN+1;
    output port oidN(integet)=vidN;

    pass data to filter on oidN=M

    we can do through Rank trans also, after generating ids in exp trans... pass data to Rank trans and select top M ranks, rank port need to be oid port

    ReplyDelete

Post a Comment