GeekInterview.com
Results 1 to 2 of 2

Extract and Load only the first and last records from a flat file to target

This is a discussion on Extract and Load only the first and last records from a flat file to target within the Databases forums, part of the category; How to extract only the first and last records from a flat file and load the same to the target? Any answers?...

  1. 11-27-2011 #1
    Rajani
    Rajani is offline Junior Member Array
    Join Date
    Nov 2005
    Answers
    18

    Extract and Load only the first and last records from a flat file to target

    How to extract only the first and last records from a flat file and load the same to the target? Any answers?

    Reply With Quote Reply With Quote
  2. 02-18-2012 #2
    Lokesh M
    Lokesh M is offline Moderator Array
    Join Date
    Oct 2005
    Answers
    1,112

    Re: Extract and Load only the first and last records from a flat file to target

    Perform SQL Trans, Agg and Rank transformations. In Agg transformation do not perform any grouping for columns. Set the rank 1 only in Rank transformation properties. Use UNION transformation to get first and last record in Target table.

    Reply With Quote Reply With Quote
« Create Target Tables with equal number of records | Filter the top 5 Highest Salaries »