wt is Dynamic lookup Transformation?
when we use?how we use?
Answers were Sorted based on User's Feedback
Answer / ashis
When we use dynamic lookup the process is as follows:
1. When the first record is read from the lookup
table/flatfile, server keeps the value in the RAM also the
same information is written into two auto generated files
(having random names, forgot the type, hope it is something
related to index and cache).
2. When the next record comes for lookup, first the record
is searched in the RAM or created file based on the
conditions used in lookup condition.
3. If not found then searched in the Lookup table.
4. In case of dynamic lookup once value is fetched from the
source with modified fields it will be updated in the RAM
or autogenerated file for further lookup for same key
values, before the completion of the session.
(Example:- in case if emp_id 101 got modified more than one
time between the two runs).
5. In case of static lookup. It will always look into the
already existing value in the lookup table.
Is This Answer Correct ? | 24 Yes | 6 No |
Answer / padmavathi
What Ashis told is Exactly correct apart of this Actually
when lookup table contains less data then we will go for
the Dynamic Lookup cache, performance increases.If large
data is there means its better to go for static cache.
Is This Answer Correct ? | 20 Yes | 6 No |
how many types of dimensions are available in informatica?
What is meant by query override?
If we set dd_insert in mapping and Delete in session properties what will happen.?
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
What is the difference between Power Centre and Power Mart?
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)
What is a poling?
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,