Answer Posted / dr.jornalist

Surrogate Key:- Surrogate key is a system generated primary
key used in informatica for maintaining history of values.

How might you approve all mappings in the archive all the while?

1081

---

What are the designer tools for creating transformations?

1158

---

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?

1557

---

What is fact table? Explain the different kinds of facts.

1125

---

How to extract sap data using informatica? What is abap? What are idocs?

1252

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1204

---

what is SDLC way of code development?

2091

---

Explain informatica architecture - version 8 / 9

1151

---

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

1908

---

can anyone explain me about retail domain project in informatica?

7998

---

Which version configuration tool used in ur project?

3320

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1676

---

What are the different versions of informatica?

1332

---

Define mapplet?

1059

---

What are the components of workflow manager?

1153

---