Answer Posted / krishna

hi neetu,
i hope you were a bit wrong.
static cache is also used to check whether row exists or
not.....
well krishna for your question on dynamic cache..
static cache is one in which data when changed in the
target table cannot be incorporated in the look up on the
fly.
when you use a dynamic cache any changes to the target
table gets reflected in the lookup even if the record is
being inserted or updated in the same mapping run priorly

What is rank transform?

603

---

How to update source definition?

630

---

State the differences between sql override and lookup override?

622

---

How an expression transformation differs from aggregator transformation?

628

---

What is the difference between STOP and ABORT options in Workflow Monitor?

698

---

---

is it possible to index the data in cache of lkp transformation ?

1528

---

Explain target update override in informatica

631

---

Enlist some properties of sessions.

630

---

Explain the tuning lookup transformation - informatica

615

---

What is the use of target designer?

610

---

On which transformations you created partitions in your project?

761

---

Explain the difference between a data warehouse and a data mart?

600

---

According to his methodology what all you need before you build a datawarehouse

1188

---

Explain sql transformation in script mode examples in informatica

605

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1414

---