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

0 Answers  

---

How does the session recovery work.

1 Answers  

---

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

0 Answers   IBM,

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

0 Answers  

---

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

0 Answers  

---

---

What are the various types of transformation?

0 Answers  

---

Can we have a Mapping without a Source Qualifier?

14 Answers   Deloitte,

---

How can you generate reports in informatica?

0 Answers  

---

why cant we put a sequence generator or upd strategy transformation before joiner transformation?

2 Answers   Satyam,

---

i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

7 Answers   IBM, TCS,

---

What is the difference between a router and a filter transformation?

1 Answers   TCS,

---

How can you differentiate between powercenter and power map?

0 Answers  

---