Is there any model difference between ODS and DWH

Question Posted / manojdubba

Answers were Sorted based on User's Feedback

Is there any model difference between ODS and DWH..

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

Is there any model difference between ODS and DWH..

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

More Informatica Interview Questions

What are the new features of informatica 9.x at the developer level?

Can you generate reports in Informatcia?

how to get the data from the client machine and how to get server location data to client loction can any body explain to me

Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.

How to load only the first and last record of a flat file into the target?

how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

How to fix the etl bugs..Tell me the process?

sample mappings for scd1,scd2 and scd3

Three date formats are there . How to change these three into One format without using expression transformation ?

What is meant by active and passive transformation?

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

For more Informatica Interview Questions Click Here