Answer Posted / sumankumar

type2 scd it wil maintain historical informtion + currnt
information along with 3 options .....
1.effective date
2.version number
3.flag value

What is workflow? What are the components of the workflow manager?

1070

---

Write the unconnected lookup syntax?

1033

---

Define Pmrep command?

998

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2022

---

Explain the scenario which compels informatica server to reject files?

1091

---

Can you use flat files in Mapplets.

2612

---

What is data transformation manager process?

1080

---

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

1095

---

How to update or delete the rows in a target, which do not have key fields?

1121

---

What do you understand by SOA of Informatica?

927

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1174

---

explain abt ur project architecture?

2124

---

write a query to retrieve the latest records from the table sorted by version(scd)

1011

---

What is the function of union transformation?

1067

---

What is parallel processing in informatica?

1621

---