wt is Dynamic lookup Transformation?
when we use?how we use?
- 2 Answers
- 24432 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is the difference between view and materialised view?
While importing the relational source defintion from database,what are the meta data of source U import?
What is the use of transformation?
what are cost based and rule based approaches and what is the difference?
Insert else update option in which situation we will use
What are different types of transformations available in informatica?
What is the need of building a data warehouse?
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
how do the project develops? pls specify right from the start to end in step by steps.
What is main use of mapplet?
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
Teradata 
