Answer Posted / addy

Hi

I would like to mention- apart from logging differences
there is a crucial diffrence - if we are running the session
in bulk target load mode we cant recover a session from the
same point when we run it for the next time.

whereas if we are running the session in normal target load
mode we can recover the session if the output being loaded
to the target is deterministic in nature - this is relay a
helpful feature with the applications handling RealTime data.

-addy

How can you define user defied event?

976

---

What are pre and post-session shell commands?

1236

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1792

---

What is the difference between writing a joiner query in ANSI style and THETA style?

2320

---

What is dimensional table? Explain the different dimensions.

1109

---

How to create or import flat file definition in to the warehouse designer?

1021

---

What is the benefit of partitioning a session?

1102

---

Explian the Process of deployment groups in informatica

990

---

Define the various join types of joiner transformation?

941

---

what is degenerated dimension?

3872

---

How to create Target definition for flat files?

1157

---

 Informatica Checkpoints

3269

---

What is meant by a domain?

1078

---

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

1805

---

expain about the tune parameters?

2338

---