Answer Posted / 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

Define filter transformation?

630

---

Enlist the various types of transformations.

566

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3455

---

Enlist the differences between database and data warehouse.

561

---

What is substr in informatica?

669

---

---

Explain what are the different versions of informatica?

664

---

How can we use mapping variables in informatica? Where do we use them?

628

---

How can we improve session performance in aggregator transformation?

682

---

How do you set a varible in incremental aggregation

1453

---

What do you understand by SOA of Informatica?

594

---

How identifying bottlenecks in various components of informatica and resolving them?

591

---

What is native users?

730

---

How many ways are there to create ports?

734

---

What are active and passive transformations?

658

---

In informatics server which files are created during the session rums?

642

---