tell me the datawarehouse defination,and it is maintaing
hystorical data meaning,what is the use
Answer / 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 |
Why use shortcuts(Instead of making copies).
What is substr in informatica?
how to run the batch using pmcmd command
What is the benefit of session partitioning?
what is the logic will you implement to load data into a fact table from n dimension tables?
Explain the pipeline partition with real time example?
What are the session parameters?
What is decode in informatica?
What are the advantages of using informatica as an etl tool over teradata?
How to load only the first and last record of a flat file into the target?
What is the Rank index port in Rank transformation?
What are the measure objects?