Answer Posted / sankar

NORMAL LOADING:THE INTEGRATION SERVUCE CREATE THE DATA BASE
LOG BEFORE LOADING DATA INTO THE THE TARGET DATA BASE.SO
--THE INTEGRATION SERVICE PERFORM ROLL BACK AND SESSION
RECOVERY.
BULK LOADING:THE INTEGRATION SERVICE IN WORK THE BULK
UTILITY WHEN BYPASS THE DATA BASE LOG
--THIS IS IMPROVES THE PERFORMANCE DATA LOADING
--THIS IS NOT PERFORM ROLLBACK

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

1416

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6093

---

What are junk dimensions?

636

---

What is the cumulative sum and moving sum?

758

---

Explain lookup transformation is active in informatica

663

---

---

what is $$$$?

1742

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

900

---

Differentiate between source qualifier and filter transformation?

1003

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1077

---

Clarify the aggregator change?

598

---

How are indexes created after completing the load process?

988

---

What is the need of etl tools?

615

---

Plz can any one say me how to get the informatica certification materials and dumps

1600

---

Explain how many types of dimensions are available in informatica?

596

---

What is the difference between informatics 7x and 8x and what is latest version?

547

---