Interested to Buy Any Domain ? << Click Here >> for more details...
wt is Dynamic lookup Transformation?
when we use?how we use?
- 2 Answers
- 25479 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 you know about transaction control transformation?
wat are deployement groups in informatica, how it will be used for developers
What is intricate mapping?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Could you explain what is enterprise data warehouse?
What is DR strategy for Informatica project?
Briefly describe lookup transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
generate date / time dimension in informatica
can anyone explain me about retail domain project in informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How to generate sequence numbers using expression transformation?
What is meant by active and passive transformation?
What is a joiner transformation?
