Is there any model difference between ODS and DWH
Answer Posted / 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 |
Post New Answer View All Answers
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What are the different options available for update strategy?
What is an active transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is joiner change?
What is different between the data warehouse and data mart?
How do you load only null records into target?
What is the difference between a repository server and a powerhouse?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is joiner transformation in informatica?
Design a mapping to load a target table with the following values from the above source?