Page 1 of 1
Fileset
Posted: Sat May 09, 2009 6:21 am
by sivagnanamsv
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
Posted: Sun May 10, 2009 7:46 am
by sivagnanamsv
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)'
And more
Posted: Sun May 10, 2009 7:49 am
by sivagnanamsv
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
Posted: Sun May 10, 2009 7:55 am
by sivagnanamsv
This might be the exact reason
Lookup file sets are specific to the $APT_CONFIG_FILE used to create them.
Posted: Sun May 10, 2009 4:56 pm
by ray.wurlod
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.