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.

Define Update Override?

1 Answers  

---

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

---

What is galaxy shema

2 Answers   CGI,

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

0 Answers  

---

what is the incremental agrrigation?

2 Answers   Cap Gemini,

---

How to display null values on a target & non-null values on a target?

3 Answers  

---

What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,

---

How many cubes create from a single model?

1 Answers  

---

What is a transaction control transformation?

0 Answers   Informatica,

---

Examples of Fatal & Non-Fatal error?

2 Answers   Cap Gemini,

---

What is complex mapping?

0 Answers  

---

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers   TCS,

---