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 is shared lookup&persistent lookup?

4 Answers   Accenture, Cap Gemini,

How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 Answers  

Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.

0 Answers  

What is the difference between lookup override and souce qualifier override ?

2 Answers   Puma,

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

0 Answers  

What is different between the data warehouse and data mart?

0 Answers  

How can we use batches?

0 Answers  

case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers  

Three date formats are there . How to change these three into One format without using expression transformation ?

3 Answers   HP,

How can you increase the performance in joiner transformation?

0 Answers  

Where is the cache stored in informatica?

5 Answers   Infosys, Satyam,

What are the mapings that we use for slowly changing dimension table?

2 Answers