Interested to Buy Any Domain ? << Click Here >> for more details...
Is there any model difference between ODS and DWH
- 2 Answers
- 7193 Views
- Zensar, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bharu_295
ODS is a Replica of transactional data so it is OLTP and DW is an HIstorical Data so its OLAP.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / vchandra
ODS stores operational data where as DWH store ODS data as
well as the history of the source database
| Is This Answer Correct ? | 1 Yes | 1 No |
What is the difference between IN and Exists in Oracle?
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
i have source in oracle 10g,oracle 8i how will u take the data from two sources
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com
how do u tune queries?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
what is runtime variable?
How the Informatica Server reads perameter file?
How do you create single lookup transformation using multiple tables?
Teradata 
