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
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Is there any way to read the ms excel datas directly into informatica?
Why do you use Mapping Parameter and mapping variable?
Is it possible to use a client with different version than that of its Informatica server?
What is the difference between STOP and ABORT options in Workflow Monitor?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is data caches/ index caches?
Describe an informatica powercenter?
Can we get 1st record through Informatica(without sequence number).
What are the main issues while working with flat files as source and as targets ?
Separate from an archive server and a powerhouse?
How to generate sequence numbers without using the sequence generator transformation?
can anyone explain me about retail domain project in informatica?
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance