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 |
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
Howmany ways yoU can update a relational source defintion and what are they?
If I am having 6 flat files in data. How can you load the data at a time
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
Explain the difference between a data warehouse and a data mart?
How can we store previous session logs?
i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
What are the components of Informatica? And what is the purpose of each?
In any project how many mappings they will use(minimum)?