Answer Posted / kiran

source-sq-exp-tgt
in exp take two new ports
o1- substr(string,2,1)
o2-concat('20',(substr(string,3)))

let me know if i m wrong

difference between informatica 8.1.1 and 8.6

3255

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

742

---

Explain load alternative records / rows into multiple targets - informatica

705

---

What is persistent lookup cache?

611

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

570

---

---

 Informatica Checkpoints

2869

---

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

1421

---

What is workflow manager?

586

---

What you know about transaction control transformation?

566

---

How to join three sources using joiner? Explain though mapping flow.

708

---

what is SDLC way of code development?

1570

---

Under which circumstances, informatica server creates reject files?

603

---

What is the difference between stop and abort in informatica

669

---

what is index?how it can work in informatica

1597

---

can anyone explain me about retail domain project in informatica?

7447

---