Interested to Buy Any Domain ? << Click Here >> for more details...
Is there any model difference between ODS and DWH
- 2 Answers
- 7349 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 |
Explain about Recovering sessions?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
why do we go for update strategy tr in SCD rather using the session properties?
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
How do you update the records with or without using update strategy?
Why we use stored procedure transformation?
What are the types of lookup caches?
10 Answers Accenture, IBM, Informatica,
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc
Explian the Process of deployment groups in informatica
Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?
Teradata 
