tell me the datawarehouse defination,and it is maintaing
hystorical data meaning,what is the use



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

Post New Answer

More Informatica Interview Questions

Do you have knowledge in ralph kimball methodology

1 Answers  


Is it possible to revert a global repository to local one and why?

0 Answers  


COM components can be used in Informatica

0 Answers  


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 Answers  


Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,






What is meta data and system catalog?

2 Answers  


How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size

1 Answers  


explain different levels in pushdown optimization with example?

2 Answers   TCS,


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

0 Answers  


Write the prerequisite tasks to achieve the session partition?

0 Answers  


i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,


Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks

3 Answers   IBM,


Categories