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 tokens will generate?
What do you understand by term role-playing dimension?
what are 3 tech challenges/ common issues you face?
Plz..let me know differences between Informatica 7.1 and 8.1?
Can we combine a flatfile and a database table using an UNION transformation?
what are the transformations that restricts the partitioning of sessions?
what is Active lock explain
How can we integrate different flat file data in a single mapping and with in a single execution
There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.
What is a filter transformation and why it is an active one?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.