Using Connected or unconnected lookup for performance wise which one is preferable?.
Answer / sam
Performance wise unconnected lookup transformation is better as it returns one port & does not build dynamic cache. only static cache is build .
| Is This Answer Correct ? | 0 Yes | 0 No |
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
What is the difference between view and materialised view?
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
how to duplicates from expression transformation without using sorter before that
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
how to load dimension table and fact table. plz tell me the steps.
What is data transformation manager process?
Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?
How you know when to use a static cache and dynamic cache in lookup transformation?
how to join two flat files in informatica?
Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.