Answer Posted / achoudhr

I wanted to ask, why Static is better than other 3 options.

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2062

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2239

---

What all join we can perform in LOOKUP transformation?

916

---

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

1808

---

How to call shell scripts from informatica?

938

---

How an expression transformation differs from aggregator transformation?

993

---

What are the components of Informatica? And what is the purpose of each?

983

---

How to load a Dimension ? and how to load a fact table?

1372

---

How do we call shell scripts from informatica?

1014

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1424

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1589

---

Can you generate sequence numbers without using the sequence generator transformation?

1054

---

What is a node in Informatica?

1004

---

What is the Process to creating lookup transformation in informatica

984

---

which one is better performance wise joiner or look up

1025

---