If we have lookup table in workflow how do you trouble
shhot to increase performance?
Answers were Sorted based on User's Feedback
Answer / deepak aggarwal
You can calculate the size of lookup cache file needed
from number of rows and colulmn width needed. You can
increase Cache file size for good performance.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / priya
There are 2 ways :
1. Create a persistant cache
2. Add the lookup table in SQ make it outer joined
Is This Answer Correct ? | 1 Yes | 0 No |
Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V
Is it possible to have "5 source & 5 Target" in single mapping?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is meant by lookup transformation? Explain the types of lookup transformation?
is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?
what is mean by grouping of condition column in lookup transformation?
How can we remove the duplicates from flat file source?
plz plz plz send client names and project names in informatica?
Mention few power centre client applications with their basic purpose?
Explain the aggregator transformation?
what are the types of facts with Examples?
Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?