Answer Posted / rajendra

Incremental loading is load the

History data
Present data

and add insert new data to the table

Whats there in global repository

1694

---

Can anyone tell me the new features in Informatica 9 Version?

2127

---

How many ways are there to create ports?

1332

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1174

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1688

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

1074

---

Explain the tuning lookup transformation - informatica

995

---

Define Pmrep command?

1058

---

what is mean by complex business rule ?

2162

---

How many ways a relational source definition can be updated and what are they?

1017

---

What is an expression transformation in informatica?

1038

---

What is lookup change?

1048

---

what is the complex transformation you used in informatica

2587

---

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

2112

---

What is the function of look up transformation?

1123

---