DSXchange

we can use the sample stage to get the Nth record..?

This might be the exact reason

Lookup file sets are specific to the $APT_CONFIG_FILE used to create them.

Lookup file sets can only be read in a lookup reference which limits their real world use. No utilities can read a lookup file set, uncluding orachadmin

I found this in parallel advance dev guide

' Data in a lookup file set cannot be read by any stage other than lookup (reference links)'

Its a wild guess.. if your first lookup 'processing_dt' sequential file contains only one record..which determines what are the records processed on that date should be passed out of the lookup then we can also consider putting the processing date condition while picking up the data from the databas...

As we can do 'view data' in data set we are not able to do it in Lookup file set. Is there any special reason that view data option is not exists with lookup file set