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 |
How the informatica server increases the session performance through partitioning the source?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
What are reusable transformations in how many ways we can create them?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How can we store previous session logs?
How can u stop a batch?
What is the main difference between a Joiner Transformation and Union Transformation?
what is the process we used in joiner transformation,there is no matching column in sources?
What is different between the data warehouse and data mart?
what is mapping performence?
What is workflow manager?
What is informatica worklet?