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 will be the approach?
What is a joiner transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Explain the code page compatibility?
Explain sessions and how many types of sessions are there?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How do you handle two sessions in Informatica
How does the aggregator transformation handle null values?
How can you generate reports in informatica?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is fact table? Explain the different kinds of facts.
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Differentiate between Load Manager and DTM?
How to convert multiple rows to single row (multiple columns) in informatica