Answer / sunil

Data Mart is subset of enterprise datawarehouse which
supports bussiness needs of middle level management in an
enterprise.

datamart is designed for particular line of business,such
as sales,marketing and finance
DW is maitaining the total organization of data
where as DM is maitained only particular subject.

Answer / sujana

data mart is a particularsubject unlike dwh..for ex
totla organization data --dwh
sales,marketing etc--data mart

Answer / tom

Adding to Sunil's answer- Data Mart is a object oriented and
DW is a subject oriented

Answer / vali

hi guys iam adding one more point...
data mart is designed for business transcational process
where as dwh desgined for business analysys

any modifications plz let me kw..vali
vali413@gmail.com

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,

---

What is aggregate cache in aggregator transforamtion?

5 Answers  

---

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,

---

Explain one complecated mapping?

3 Answers   Fidelity, Wipro,

---

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,

---

 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,

---

How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers   CTS,

---

How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers   CTS, HCL, Infosys, TCS,

---

In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?

3 Answers  

---

I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..

1 Answers  

---

Issue with Update override at Target table in Informatica.

2 Answers  

---

Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,

---