lookup and using seqfile, or dataset, or file set for a ref

[Marley777]

Which is best to use as a reference in a lookup stage (seqfile, or dataset, or file set, or DB2)?

Thanks

[kris007]

It depends on the requirement you have. If all those stages have the same number of records then there won't be much difference performance wise. DB2 might be slower by the time it takes to establish the connection to the database (on the same server or remote server).

[ray.wurlod]

Probably a Data Set in most cases, but you need to factor in the amount of resources needed to populate that Data Set in the first place.