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 send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
lookup transformation with screenshots
Explain the features of connected and unconnected lookup.
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is xml source qualifier transformation in informatica?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is meant by target load plan?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What are the different options available for update strategy?
Can we create multiple integration service on single repository?
Does an informatica transformation support only aggregate expressions?
Is it possible to revert a global repository to local one and why?
How can we use mapping variables in informatica? Where do we use them?
What is a sequence generator transformation?