Answer Posted / isha

http://www.folkstalk.com/2013/04/unconnected-stored-procedure-transformation-informatica.html

Explain the etl program with few examples.

966

---

how we can load rejected record's at run time?(not through bad files)

2314

---

What is informatica etl tool?

941

---

What is a surrogate key?

1016

---

Can we create a Integration service without a Repository service and vice versa?

1172

---

What is a repository manager?

1029

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2181

---

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

---

How to Create a folder using pmrep command?

1104

---

How to do unit testing in informatica?

1122

---

What is the way to execute pl/sql script using informatica mapping?

1508

---

What is incremental aggregation?

1014

---

Explain how many types of dimensions are available in informatica?

1007

---

What's the layout of parameter file (what does a parameter file contain?)?

2334

---

How can a transformation be made reusable?

1077

---