In lookup which one is better one connected and unconnected lookup?performance wise i am asking?if i am using five connected lookup in mapping that time what happens?
Latest Answer : Dynamic cache - can be configured as connected lookup only. It does not support lookup on flat file. Can have only equality operator in lookup condition.Static cache - can be configured as connected as well as unconnected lookup. Supports lookup on flatfile. ...
I am new to the informatica ..Can anyone explain stored procedure,sequence generator and lookup transformation with example...
How do i get data in a unconnected lookup transformationi.e if i want to compare customer_id in the source with the customer_id in the unconnected lookup, how can i get the data from the source for the customer_id if it is an unconnected lookupthanksnayana
HI,i am trying to use a flat file and using oracle table as a lookup. when i try to debug its advising invalid mapping. can anyone please help me with this.i also wrote the condition in the lookup as custid=custid.the same is working if i have my source as oracle table.thanksnayana
Latest Answer : by default it takes static cache ...
What is the difference between using Joiner and Using Lookup to join to tables. Which is good to use.
How to implement this situation:have one source and one target,while load into the target first delete then insert?
Now I implement it through this way:create two source qualifier both for the same source,then config the target load plan to load into the target by order.but before I load into the target,I need to look-up
Latest Answer : For relational lookups, you might want to configure the transformation to use a dynamic cache when the target table is also the lookup table. The PowerCenter Server builds the cache when it processes the first lookup request. It queries the cache based ...
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
