Is there any model difference between ODS and DWH
- 2 Answers
- 7525 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 |
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
what is the hint? how to use it to reduce the query processing in program?
What are active and passive transformations?
version controlling in informatica?
is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?
Explain about Recovering sessions?
How many dimensions are there in informatica?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
performance tuning of Informatica
What are the components of workflow manager?
explain one complex mapping with logic? sales project?
1 Answers Accenture, JPMorgan Chase,
Teradata 
