Answer Posted / sri47
OLTP refers a transactional Data base.
ODS refers a data base which actually contains the Basic
data like the details of available Procts,and Branches of
Company etc.
Means It will be small in size and can be modified
daily.Most of the times Thos ODs is used for loading the
Dimensions.
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What is an unconnected transformation?
Is there any target staging area in informatica not staging area
What is a pre-defined event and user-defined event?
Please let me know how to make encryption and decryption with example?
What is the Rank index port in Rank transformation?
What is the procedure for creating independent data marts from informatica 7.1?
Separate from a database, an information bazaar, and an information stockroom?
What is joiner transformation in informatica?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is lookup change?
What is the use of target designer?
What does reusable transformation mean?
How to Create a folder using pmrep command?
What is an aggregator transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?