look up stage interiors
Posted: Thu Mar 07, 2013 8:57 am
Hi
Could some one please share some light over the below
1. The look up stage removes the duplicates if, multiple rows returned from link is disabled, does it mean that the look up operator has a tsort underneath to remove duplicates OR are the duplicates identified when the look up table is built and indexed ?
2. If there is no implicit sort, will the look up table created for reference data be different if the data is sorted and not sorted (on reference link)
3. If the look up reference data is sorted will it cause the searched to be faster or will it make the job slow (if the sort does not contribute to faster searches then obviously unnecesary sort adds to over all time)
Thanks
Could some one please share some light over the below
1. The look up stage removes the duplicates if, multiple rows returned from link is disabled, does it mean that the look up operator has a tsort underneath to remove duplicates OR are the duplicates identified when the look up table is built and indexed ?
2. If there is no implicit sort, will the look up table created for reference data be different if the data is sorted and not sorted (on reference link)
3. If the look up reference data is sorted will it cause the searched to be faster or will it make the job slow (if the sort does not contribute to faster searches then obviously unnecesary sort adds to over all time)
Thanks