Answer Posted / raghvendra

incremental aggregation performs aggregation on incremented
data..so based on requirements if we can use incremental
aggregation then definately it will improve performance..so
while develop mapping always keep in mind this factor too...

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

2160

---

What is a dimensional model?

1033

---

Describe expression transformation?

1168

---

In how many ways we can create ports?

1159

---

Explain sql transformation in script mode examples in informatica

1211

---

What is workflow manager?

1100

---

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2325

---

How to do unit testing in informatica? How to load data in informatica ?

1184

---

What is substr in informatica?

1261

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6580

---

Define update strategy?

1315

---

Have you worked with/created Parameter file

1712

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2069

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1125

---

Under what condition selecting sorted input in aggregator may fail the session?

1175

---