 Related Questions In lookup which one is better one connected and unconnected lookup?performance wise i am asking?if i 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? Read Answers (9) | Asked by : reddy 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. ... Read Answers (3) | Asked by : senthilkumarselvaraj I am new to the informatica ..Can anyone explain stored procedure,sequence generator and lookup transformation with example... Read Answers (2) | Asked by : kalpana 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 Read Answers (2) | Asked by : nayana 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 Read Answers (3) | Asked by : NAYANA Latest Answer : by default it takes static cache ... Read Answers (4) | Asked by : BUJJI What is the difference between using Joiner and Using Lookup to join to tables. Which is good to use. Read Answers (5) | Asked by : Naveen Kumar 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 Read Answers (2) | Asked by : Grayva 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 ... Read Answers (3) | Asked by : poornima 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 Read Answers (2) | Asked by : sunil
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
