Answer / amedela chandra sekhar

Data mart is a subset of data ware housing.it is a complete
information about one particular domain.

ex:finance,hr,sales.....





chandumba2005@gmail.com

Answer / nagendra phani

Data Mart is the subset of datawahehouse and it is used to
store the data department wise.

Answer / sivaram

A DATA MART IS A SUB-SET OF AN ENTERPRRISE DATAWAREHOUSING.
A DATA MART IS ASUBJECT ORIENTED DATA BASE WHICH SUPPORTS THE
BUSINESS NEEDS OF INDIVIDUAL DEPARTMENTS WITHIN THE
ENTERPRISE.
A DATA MART IS ALSO KNOWN AS HIGH PERFORMENCE QUERY
STRUCTUERS.

Answer / anand

For overwriting Data.Ex" we used to load Flat file data
from DSO to Cube.Its is Data Mart.Loading data from a
infoprovider used as data target to another data target.The
concept we used is DATA MART.

Answer / yash

data mart are specific ,repository of data, designed to
answer specific users.( examaple :sales)

What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?

2 Answers   CTS,

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

0 Answers  

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,

State the limitations where we cannot use joiner in the mapping pipeline?

0 Answers  

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  

What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  

what is parallel querying and what r hints.

1 Answers  

What are the different options available for update strategy?

0 Answers  

how to work with mapplet designer in informatica?

7 Answers  

Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani

2 Answers   Wipro,

If we are using an aggregator but forget to mention the group by port .what will be the output??

11 Answers   Nomura, TCS,