Answer Posted / ojesh

PMCMD

What are the static cache and dynamic cache in informatica?

1139

---

How does a sorter cache works?

1000

---

Please let me know how to make Data masking in informatica..

1663

---

What is incremental aggregation?

1014

---

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

---

What is target designer and target load order?

1051

---

Do you find any difficulty while working with flat files as source and target?

1051

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

1013

---

How to update or delete the rows in a target, which do not have key fields?

1116

---

What is the benefit of session partitioning?

1042

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2058

---

Can we override a native sql query within informatica?

987

---

What are the main issues while working with flat files as source and as targets ?

1096

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1895

---

Under which circumstances, informatica server creates reject files?

1026

---