Answer Posted / rishikesh

lookup on flat file in informatica7.1
no such provision in 6.1
union all trnasformation in 7.1 not in 6.1
transaction control tranformation not in 6.1
file reposioty in 7.1

Describe data concatenation?

1088

---

Briefly define a session task?

1143

---

What is data caches/ index caches?

1112

---

How many ways are there to do 'remove duplicate records in informatica'?

1023

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1116

---

What are the new features of Power Center 5.0?

1788

---

Enlist few areas or real-time situations where informatica is required.

1095

---

Explain the aggregator transformation?

1174

---

What are the types of caches in lookup? Explain them.

974

---

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

2016

---

what is the complex transformation you used in informatica

2594

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1288

---

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

1868

---

Mention a few design and development best practices for informatica?

1004

---

What are the types of schemas we have in data warehouse and what are the difference between them?

949

---