Answer Posted / rekha

NORMAL LOAD : IT LOADS THE RECORD ONE BY ONE AND WRITES LOG
FOR EACH FILE . IT TAKES MORE TIME TO COMPLETE
BULK LOAD : I LOAD THE NUMBER OF RECORDS AT A TIME ,IT WONT
FALLOW ANT LOG FILES OR TRACE LEVELS . IT TAKES LESS TIME
USE THE BULK MODE FOR IMPROVING THE SESSION PERFORMANCE

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

1866

---

How can we use mapping variables in informatica?

1064

---

Differences between connected and unconnected lookup?

1222

---

How an expression transformation differs from aggregator transformation?

1044

---

How you can differentiate between connected lookup and unconnected lookup?

1064

---

have u done any performance tuning? how u ll do?

2299

---

What is the scenario which compels informatica server to reject files?

1073

---

What is a filter transformation?

1048

---

What is a router transformation?

1132

---

Separate from a database, an information bazaar, and an information stockroom?

1089

---

Differentiate between a repository server and a powerhouse?

1121

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2136

---

Describe expression transformation?

1132

---

State the differences between sql override and lookup override?

1210

---

While migrating the data from one environment to another environment how would you manage the connections?

1090

---