Answer / vaibhav bhandeo

Datamart is a subset of data warehouse and it supports a
particular region, business unit or business function.
Data warehouses and data marts are built on dimensional
data modeling where fact tables are connected with
dimension tables. It is designed for a particular line of
business, such as sales, marketing, or finance.

Answer / amedela chandra sekhar

Data mart is a subset of Data warehouse.it is a complete information about one particular domain.eg:(finance,sales).

Data marts and Data warehouses are built on dimensional
data modeling where the relationship b/w dimension tables fact tables.

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  

---

replace multiple spaces with single space.

3 Answers   IBM,

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

0 Answers   TCS,

---

What is the advantage of informatica?

0 Answers  

---

What is the diff. b/w informatica versions 8.1.1 and 8.6.1?

4 Answers   IBM, Wipro,

---

---

What are the reusable transforamtions?

1 Answers  

---

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

1 Answers   Qwest,

---

how can we perform incremental aggregation?explain with example?

9 Answers   IBM, TCS,

---

what is target update override and when we use it?

2 Answers   TCS,

---

What is the functionality of update strategy?

2 Answers  

---

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  

---

TELL ME ABOUT WORK FLOW SCHEDULING?

3 Answers   TCS,

---