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 can we use mapping variables in informatica? Where do we use them?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What are the different lookup cache(s)?
What are the popular informatica products?
What is joiner transformation in informatica?
What do you understand by term role-playing dimension?
How to do the error handling of if ur source is flatfiles?
Explain what is informatica metadata and where is it stored?
What is the difference between informatica 7.0 and 8.0?
How to open an older version of an object in the workspace?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
How identifying bottlenecks in various components of informatica and resolving them?
What do you mean incremental aggregation?
How do you load alternate records into different tables through mapping flow?
What is flashback table ? Advance thanks