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 an MDDB? What is the difference between MDDBs and RDBMSs?

3 Answers  

What are the basic needs to join two sources in a source qualifier?

4 Answers  

without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,

What is meant by active and passive transformation?

0 Answers  

Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks

4 Answers   IBM,

Write the program through which the records can be updated?

0 Answers  

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,

How can we use mapping variables in informatica?

0 Answers  

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 Answers  

What is batch and describe about types of batches?

2 Answers  

Diff b/w ShortCut and reusabel Object ?

4 Answers  

Explain about perform recovery?

1 Answers