Informatica Server determines which record is first and which is last with the following approach,
The server generates an ORDER BY clause for each column in the lookup cache, then sorts each column in the lookup condition in ascending order. The Server sorts string columns alphabetically (A to Z), numeric columns in ascending numeric order (such as 0 to 10), and date/time columns from January to December and from the first of the month to the end of the month.
