Interested to Buy Any Domain ? << Click Here >> for more details...
wt is Dynamic lookup Transformation?
when we use?how we use?
- 2 Answers
- 25585 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the conditions needed to improve the performance of informatica aggregator transformation?
Define mapplet?
What is a pre-defined event and user-defined event?
What are the new features of Power Center 5.0?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How to implement security measures using repository manager?
Explain constraint based loading in informatica
Under what condition selecting sorted input in aggregator may fail the session?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What happens when a session fails and you click on recover?
Define update strategy?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How to extract sap data using informatica? What is abap? What are idocs?
