How new port is created in lookup after enabling the dynamic lookup cache?

Can any one explain about the new port that is created in the lookup after enabling the dynamic lookup cache?
and what is the associate port??????

thanks in advance for your time

Showing Answers 1 - 2 of 2 Answers

adil

  • Nov 28th, 2006
 

Hi,Associate port is either an i/p or o/p .Data in this port is used by IS[Infa Server] to insert or update lookup cache.

  Was this answer useful?  Yes

Manasa

  • Dec 6th, 2006
 

A Lookup transformation using a dynamic cache has the following properties:

  • NewLookupRow. The Designer adds this port to a Lookup transformation configured to use a dynamic cache. Indicates with a numeric value whether the PowerCenter Server inserts or updates the row in the cache, or makes no change to the cache. To keep the lookup cache and the target table synchronized, you pass rows to the target when the NewLookupRow value is equal to 1 or 2.
  • Associated Port. Associate lookup ports with either an input/output port or a sequence ID. The PowerCenter Server uses the data in the associated ports to insert or update rows in the lookup cache. If you associate a sequence ID, the PowerCenter Server generates a primary key for inserted rows in the lookup cache.
  • Ignore Null Inputs for Updates. The Designer activates this port property for lookup/output ports when you configure the Lookup transformation to use a dynamic cache. Select this property when you do not want the PowerCenter Server to update the column in the cache when the data in this column contains a null value.
  • Ignore in Comparison. The Designer activates this port property for lookup/output ports not used in the lookup condition when you configure the Lookup transformation to use a dynamic cache. The PowerCenter Server compares the values in all lookup ports with the values in their associated input ports by default. Select this property if you want the PowerCenter Server to ignore the port when it compares values before updating a row.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions