Answer / praveen n

Double click the lookup transformation, check the properties
tab, if check port of dynamic lookup cache selected or not,
if it is selected it is dynamic cache and if not it is static

Static cache: it is read only and persistent
Dynamic cache: it is changing during the session runs.
Thanks
Praveen

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,

---

what is update strategy transformation ?

7 Answers   TCS,

---

How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.

3 Answers   Eureka Forbes,

---

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,

---

what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,

---

---

What are the mapings that we use for slowly changing dimension table?

2 Answers  

---

During the running session, output files are created by informatica server. Enlist few of them.

0 Answers  

---

Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?

3 Answers  

---

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers   Infosys, TCS,

---

Differentiate between sessions and batches?

0 Answers  

---

What are some examples of informatica etl programs?

0 Answers  

---

I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE

5 Answers   Informatica,

---