Answer Posted / jz

If Two Flat files having same coll then go for Union t/r to
join.

What are the new features of Power Center 5.0?

1777

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1246

---

Where can we find the throughput option in informatica?

1060

---

What are the new features of informatica 9.x in developer level?

997

---

What is dynamic cache?

1031

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

2003

---

How to elaborate powercenter integration service?

1131

---

How do you convert single row from source into three rows into target?

1155

---

Under which circumstances, informatica server creates reject files?

1091

---

What is depict expression change?

1116

---

How to create the source and target database connections in server manager?

1088

---

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

1863

---

What is flashback table ? Advance thanks

1930

---

server hot-ws270 is connect to Repository B. What does it mean?

2561

---

What is Data Caches size?

1087

---