Sparse lookup possible in SE?

bchau · Post by **bchau** » Tue Dec 12, 2006 12:41 am

I performed a search but could not find any information about sparse lookups in server edition. Does anyone know if it is possible? I know that PX has this option.

Kirtikumar · Post by **Kirtikumar** » Tue Dec 12, 2006 1:00 am

In server, while doing the lookups, each query can behave like a sparse lookup if you dont use the buffers. So each time input values are mapped to question marks of SQL in lookup DB stage and will be run at that time.

ray.wurlod · Post by **ray.wurlod** » Tue Dec 12, 2006 1:34 am

ALL server job lookups are sparse, in that there is no intermediate virtual Data Set. As Kirtikumar notes, however, enabling row buffering has a similar effect to a virtual Data Set. Nevertheless, a query is executed against the database server (or hashed file) for each stream input row, buffering notwithstanding; therefore all server job lookups are technically sparse.

bchau · Post by **bchau** » Tue Dec 12, 2006 1:49 am

ok thanks guys!