DSXchange

why sequential file is not used as a look up???

Because it doesn't really make any sense to do a lookup directly against sequential media. Load it in a hashed file and then do the lookup.

Welcome Aboard ! A sequential file cannot have keys to it and hence a look-up cannot be performed against it.

4friends wrote:why sequential file is not used as a look up???

We use look up as an alternate way to implement joins and use hash file since it uses hash algorithm to look for a match for key columns in the hash file. Sequential file doesnt have key columns. So it wont help you to perform a look-up

You can, of course, use a sequential file for lookups, by identifying the lookup key columns in the metadata and employing an ODBC stage via the ODBC driver for text files.

Just don't expect any speed.

Forgot about that option... but perhaps that's for the best.

Maube it's the right approach if you're being paid by the hour!