Answer Posted / adityadeep13

Hi Plz mail me at adityadeep13@gmail.com for Informatica and Tableau training with full installable and interview preparation

Can informatica load heterogeneous targets from heterogeneous sources?

1228

---

What do mean by local and global repository?

1276

---

How to delete duplicate row using informatica?

1086

---

Explain the different kinds of facts.

1020

---

What are the main features of Oracle 8i with context to datawarehouse?

2158

---

Where is metadata stored?

1189

---

What is the cumulative sum and moving sum?

1233

---

What are pre and post-session shell commands?

1380

---

What is Data Caches size?

1127

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1555

---

How to update a particular record in target with out running whole workflow?

1622

---

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

1907

---

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

1208

---

What is joiner transformation in informatica?

1096

---

Explain the features of connected and unconnected lookup.

973

---