tell me the datawarehouse defination,and it is maintaing
hystorical data meaning,what is the use
Answer Posted / abhinaw prakash
Data warehouse is the coordinated,periodic copying of data
from different sources both inside and outside the
enterprise into an environment optimized for analytical and
informational processing.
By Historical data means that historical data will also be
kept along with the most recent data unlike the OLTP system.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you use reject loader.
Explain the etl program with few examples.
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
is it possible to index the data in cache of lkp transformation ?
Separate from a database, an information bazaar, and an information stockroom?
How to join three sources using joiner? Explain though mapping flow.
draw informatica architecture 8.6 ?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How can we use batches?
How you prepared reports for OLAP?
Can u generate reports in Informatica?
How to create the source and target database connections in server manager?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How to handle decimal places while importing a flatfile into informatica?