Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(1 Rating)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

FAQ: What is the 'Ignore NULL Inputs For Updates' option in a Dynamic PowerCenter Lookup transformation?
Answer

In dynamic lookup transformation, Ignore NULL inputs for updates option works as follows:

When updating Dynamic Lookup cache, Lookup transformation compares each port value of input row with rows from existing lookup cache that meets lookup condition. This is done to determine if the row has to be updated or inserted in the existing cache. If Ignore NULL inputs for updates option is selected for some of the ports, then these ports are ignored when their input values is NULL. Hence, when you have to ignore some of the ports in Lookup transformation (which can have NULL values), select the Ignore NULL inputs for updates option for those ports.

The Ignore NULL inputs for updates option is grayed out for all condition ports since they do not have any NULL input values. If any of the input rows has a NULL in any of the condition port, then that row is ignored by Dynamic lookup cache. And this row is not considered for comparison and is marked NO CHANGE (NewLookupRow = 0).


More Information

Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter 8.x; PowerCenter 9.x
Database:
Operating System:
Other Software:

Reference
PowerCenter Transformation Guide > "Dynamic Lookup Cache" > "Dynamic Lookup Properties"

Attachments

Last Modified Date:3/2/2012 2:26 AMID:21602
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)