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 the use of an aggregator cache file?

0 Answers  

How You Pull the records on daily basis into your ETL Server.

2 Answers   TCS,

What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,

What are the new features of informatica 9.x developer?

0 Answers  

Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.

1 Answers  

What is data transformation manager process?

0 Answers  

Explain what transformation and how many are there in informatica?

0 Answers  

How to load time dimension?

1 Answers   Ford,

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

0 Answers   IBM,

i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

3 Answers   Satyam,

How do you implement unconn. Stored proc. In a mapping?

1 Answers  

Without using Lookup & Sequence Generator, How to generate Sequence?

5 Answers   CTS,