Informatica - Can any one explain about the new port that is created in the lookup after enabling the dynamic look

GeekInterview.com > Tech FAQs > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 113 of 302

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

Total Answers and Comments: 2

Last Update: December 06, 2006 Asked by: sunil

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

November 28, 2006 09:17:29

adil

RE: Can any one explain about the new port that is cre...

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.

Is this answer useful? Yes | No

December 06, 2006 02:09:20

Manasa

RE: Can any one explain about the new port that is created in the lookup after enabling the dynamic look...

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.

Is this answer useful? Yes | No

jQuery - Enabling the Pager Buttons

Learning jQuery Enabling the Pager Buttons To make these new buttons actually work we need to update the currentPage variable and then run our pagination routine At first blush it seems we should be able to do this by setting currentPage to page which is the current value of the iterator that create

What is Cache

A cache is a type of dynamic and high speed memory that is used to supplement the function of the central processing unit and the physical disk storage. The cache acts as a buffer when the CPU tries to access data from the disk so the data traveling from the CPU and physical disks can have synchroni

Explain about TNSPING

You can also use tnsping utility on command prompt to check Oracle Net connectivity. Follow these steps to check the connection to particular SID. Open Command prompt. Write tnsping < SID for the database connectivity you want to check > If you get the message “Used TNSNAMES

C Programming - Dynamic Memory allocation

C Programming Dynamic Memory allocation In this tutorial you will learn about C Programming Dynamic Memory Allocation Dynamic memory allocation Memory allocations process Allocating a block of memory Allocating multiple blocks of memory Releasing the used space and To alter the size of allocated mem

Advance Java Practice Test (Part 1)

Advance Java Practice Test Part 1 This article provides details about Advance Java Online Practice Test Part 1 which is made available at geekinterview com Questions are generated randomly each time you take the test Online Practice Test is made available to everyone you too can take the test and g

ASP.NET : Dynamic Image control

ASP NET Training Dynamic Image control In this tutorial you will learn how to create Dynamic Image Control DynamicImage Control Properties and Custom Parameters mosgoogle The DynamicImage control derives from the DynamicImageBase which is in turn derived from Image This control acquires image bytes

Informatica FAQ Related

—