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 |
what are testing in a mapping level please give brif eplanation
what type of transformation is not supported by mapplets?
in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
Can we override a native sql query within informatica?
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
What is the maplet?
what are presession,postsession success and postsession failure commands ?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
What is source qualifier transformation?
What is the difference between a repository server and a powerhouse?
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?