Answer Posted / 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.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain scd type 3 through mapping.
What is meant by a domain?
difference between informatica 8.1.1 and 8.6
Do you find any difficulty while working with flat files as source and target?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Explain pmcmd command usage in informatica
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are the differences between joiner transformation and source qualifier transformation?
How to differentiate between the active and passive transformations?
How can we improve session performance in aggregator transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
explain one complex mapping with logic? sales project?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Separate from an archive server and a powerhouse?
Global and Local shortcuts. Advantages.