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.

What is the difference between stop and abort in informatica

1086

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1143

---

In which transformation you cannot drag ports into it?

1311

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2043

---

What is sorter transformation?

1038

---

What is meant by LDAP users?

1194

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1998

---

What do you mean incremental aggregation?

1072

---

What are Dimensional table?

1053

---

What the difference is between a database, a data warehouse and a data mart?

1147

---

Is there any way to read the ms excel datas directly into informatica?

1020

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1028

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1954

---

Tell me about Propagate functions in informatica

915

---

What are the reusable transformations?

1154

---