Answer Posted / srinivas
hi friends,
this is right friends , bt oltp is current data. olap
maintains historical data for analyzing purpose.. olap is
read-only data. it is denormized data . it has dimession
table ,fact table data .
it has detailed data
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Differentiate between a repository server and a powerhouse?
What are the prerequisite tasks to achieve the session partition?
What is joiner transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is a standalone command task?
Can you generate sequence numbers without using the sequence generator transformation?
What is the status code in stored procedure transformation?
What are the differences between oltp and olap?
What are the measure objects?
In informatics server which files are created during the session rums?
What do you understand by SOA of Informatica?
How to start a workflow using pmcmd command?
Explain sessions and how many types of sessions are there?
What are the various types of transformation?
Briefly define reusable transformation?