Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / himanshu
OLTP : Online Transaction Processing
The granularity of the data is Transaction i.e. stores each
transaction.
ODS: Operational Data Store
As dataware house contains summarized data
(Weekly/Monthly/Yearly). ODS may be used to maintain data
with lower granilarity (Hourly/Daily).
eg. Data for previous years may be summarized but sould not
be for the current year.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What are the differences between a connected lookup and unconnected lookup?
without table how to come first record only in oracle?
What is lookup change?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is informatica? Why do we need it?
What are the data movement modes in informatica?
What is informatica etl tool?
What is fact table? Explain the different kinds of facts.
How to do unit testing in informatica?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is session task and command task?
What is meant by a domain?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What are mapplets?
Where do we use mapping variables in informatica?
