Answer Posted / mohit sondhi
OLTP is online transaction processing systems and ODS os
operational database system.
In OLTP we can save the current data, it depends on the day
to day transactions and it stores the day to day data.
In ODS we can store data for a month also and it is not
restricted to a specific day or transaction.
| Is This Answer Correct ? | 16 Yes | 6 No |
Post New Answer View All Answers
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How to open an older version of an object in the workspace?
EXL informatica Questions
How to use procedural logic inside infromatica?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is data transformation manager process?
What is xml source qualifier transformation in informatica?
Implementation methodology
What is sorter transformation?
Explain scd type 3 through mapping.
Define pmcmd command?
What are some examples of informatica etl programs?
Define Pmrep command?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is parallel processing in informatica?