SSIS lookup activity in data flow

Question

SSIS lookup activity in data flow

sakuraime 2,341

I there is a look up activity , source is a table from databaseA and the lookup reference is a table from databaseB .

may I know the actual joining query will happen in databaseA or databaseB ? or on other places?

sakuraime 2,341 Reputation points

2021-09-25T15:30:20.593+00:00

there are 3 modes .

may I know FULL cache will make the results join at where the pacakge is execute (which outside sql server) ?

1 answer

Your answer

sakuraime 2,341 Reputation points

2021-09-25T15:30:20.593+00:00

there are 3 modes .

may I know FULL cache will make the results join at where the pacakge is execute (which outside sql server) ?

Answer 1

ZoeHui-MSFT 41,491

Hi @sakuraime ，

LookUp transformation performs lookup operation by connecting input value with data-table or table dataset columns. It compares source data with existing table dataset and filters matching ones and un-matching ones.

the actual joining query will happen in databaseA or databaseB ? or on other places?

It depends on which destination you want to match the data to.

About Full Cache Mode, here is an official documentation you may take a reference.

lookup-transformation-full-cache-mode-cache-connection-manager

Regards，

Zoe

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October

sakuraime 2,341 Reputation points

2021-09-27T13:31:59.6+00:00

if I use full cache , without using any Cache transform . which part of memory / or which windows processes memory will be using ?
my ssis package is locate on the same sql server SSISDB , and also the package is triggered by sql server agent on the same server.
sakuraime 2,341 Reputation points

2021-09-28T03:43:25.033+00:00

any idea for this ?
ZoeHui-MSFT 41,491 Reputation points

2021-09-29T03:00:26.753+00:00

Hi @sakuraime ，Full cache :Once the database is queried , during the pre-execute phase of the data flow. The entire reference set is pulled into memory.
More details you may see here which explain the Lookup Logic.
sakuraime 2,341 Reputation points

2021-09-29T04:36:26.647+00:00

thanks. but which part from the link tells which part of memory / or which windows processes memory will be using???
sakuraime 2,341 Reputation points

2021-09-30T09:21:51.703+00:00

has any idea about this ?
sakuraime 2,341 Reputation points

2021-10-01T14:48:00.133+00:00

anyone has an idea here?
sakuraime 2,341 Reputation points

2021-10-03T14:50:58.467+00:00

ányone more has an idea ?

Share via

SSIS lookup activity in data flow

1 answer

Your answer