1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

What is different between the data warehouse and data mart?

Question Posted / manish kumar


What is different between the data warehouse and data mart?..

Answer / Deepesh

A Data Warehouse is a large, centralized repository of integrated data from one or more disparate sources. It serves as a central hub for reporting and analysis across an organization. A Data Mart, on the other hand, is a smaller, department-specific subset of a Data Warehouse. Data Marts focus on specific business areas, making it easier to analyze targeted information.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

Can you use one mapping to populate two tables in different schemas

2 Answers  

Explain the features of connected and unconnected lookup.

1 Answers  

How to compare Source and Target table, without using dynamic lookup?

4 Answers  

generate date / time dimension in informatica

1 Answers   Informatica,

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  

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,

write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales

3 Answers   Cognizant, Flextronics,

How can we update a record in the target table without using update strategy?

1 Answers  

Why union transformation is an active transformation?

1 Answers   Informatica,

Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin

1 Answers  

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,

source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?

5 Answers   Wipro,

For more Informatica Interview Questions Click Here
Categories