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

Explain scd type 3 through mapping.

0 Answers  

---

What are the differences between oltp and olap?

0 Answers  

---

What is the difference between stop and abort in informatica

0 Answers   Informatica,

---

What are the types of groups in Router transformation?

1 Answers   Informatica,

---

I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....

4 Answers   Patni,

---

what is mapping parameter and mapping variables

1 Answers   BirlaSoft,

---

SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers   IBM,

---

write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers   Cap Gemini,

---

How to do unit testing in informatica?

0 Answers  

---

What is the cumulative sum and moving sum?

0 Answers  

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

0 Answers   TCS, Wipro,

---

any body can say about all versions of informatica ?how many versions ?

2 Answers  

---