Is there any model difference between ODS and DWH
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 |
can we use self join in informaitca?
How can repository reports be accessed without sql or other transformations?
case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
How to eliminate duplicate records in informatica mapping? Explain with an example....
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
What is aggregate cache in aggregator transforamtion?
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
What are the types of maping wizards that r to be provided in Informatica?
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
Why do we use DSS database for OLAP tools?
how can we calculate fact table size?