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

Explain how to import oracle sequence into informatica?

989

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1173

---

Difference between Target-based loading and constraint-based loading?

983

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1032

---

What is mapping debugger?

990

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1767

---

Explain sessions and how many types of sessions are there?

987

---

What are the differences between source qualifier and joiner transformation?

1037

---

How can we handle two sessions in informatica?

1018

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2435

---

Enlist some properties of sessions.

1055

---

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1025

---

How is union transformation utilized?

996

---

What are the restrictions of union transformation?

1018

---

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

1838

---