Answer Posted / mike

well
Cached Lookup: In a lookup cache the entire rows will be
put in the buffer and then will be compared with the in
coming rows
where as
uncached lookup: In the uncahed lookup for every row the
lookup will query the lookup table to get the rows

correct me if i was wrong

What is the meaning of up gradation of repository?

1965

---

What are the databases that informatica can connect to windows?

1040

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2169

---

which one is better performance wise joiner or look up

1076

---

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

1945

---

How do you update the records with or without using update strategy?

1101

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2018

---

Does an informatica transformation support only aggregate expressions?

1027

---

Enlist the advantages of informatica.

1051

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1064

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8209

---

What is the need for an etl tool?

1058

---

What is an active transformation?

1084

---

Informatica settings are available in which file?

982

---

What is the status code in stored procedure transformation?

1173

---