Fileset

sivagnanamsv · Post by **sivagnanamsv** » Sat May 09, 2009 6:21 am

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

sivagnanamsv · Post by **sivagnanamsv** » Sun May 10, 2009 7:46 am

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)'

sivagnanamsv · Post by **sivagnanamsv** » Sun May 10, 2009 7:49 am

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

sivagnanamsv · Post by **sivagnanamsv** » Sun May 10, 2009 7:55 am

This might be the exact reason

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

ray.wurlod · Post by **ray.wurlod** » Sun May 10, 2009 4:56 pm

The exact reason is that the internal structure and access method for a Lookup File Set is through the index on the identified Key column(s) so that, in order to be able to find something in a Lookup File Set, you need to provide a key value. Put another way, this stage supports GetRowByKey() but does not support GetNextRow(), and the data browser uses the latter.

DSXchange

Fileset

Fileset

And more