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
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What happens when a session fails and you click on recover?
What are the types of schemas we have in data warehouse and what are the difference between them?
explain about unit testing? in real time?
What is the use of transformation?
Write the prerequisite tasks to achieve the session partition?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is the scenario which compels informatica server to reject files?
Repository user profiles
Explain lookup transformation is active in informatica
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How to update source definition?
Mention few power centre client applications with their basic purpose?
4 yrs etl devloper roles and responsibilities?any body give solutions