Answer Posted / jeevankumar medapati

smal projects:::100gb to 500 gb
medium projects:: 500gb to 1000 gb
large projects :::1000 gb to 1200gb etc

Differentiate between sessions and batches?

573

---

how to create user defined function (udf) in informatica

784

---

what is the size of your data warehousing?

1669

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1011

---

Can you use flat files in Mapplets.

2220

---

---

Mention some types of transformation?

607

---

How to generate sequence numbers using expression transformation?

641

---

What is the cumulative sum and moving sum?

756

---

What is the use of an aggregator cache file?

689

---

Differences between connected and unconnected lookup?

610

---

Whats there in global repository

1268

---

Different sorts of metadata that stores in the storage facility?

561

---

How can we delete duplicate rows from flat files?

742

---

what is the Default Source Option For Update Strategy Transformation?

755

---

What is a dimensional model?

583

---