Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Post New Answer

More Informatica Interview Questions

WAT IS TEXT LOAD?

3 Answers   Wipro,

Which will beter perform IIf or decode?

3 Answers   TCS,

what is bridge tables in informatica

1 Answers   CTS,

What is staging area?

11 Answers  

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  

what is mapping performence?

2 Answers   Cap Gemini,

Scenario:-  Below is the requirement. Source:-  NAME          ID                    Requirement  RAVI            1                      (no need to repeat as it ID is 1) KUMAR        3                     (repeat 3 times as it ID is 3) John             4                     (repeat 4 times as it ID is 4) Required Out Put:- Name                   ID RAVI                     1                    KUMAR                3      KUMAR                3 KUMAR                3  John                     4 John                     4 John                     4 John                     4 Scenario 2:- Source Data  ID              NAME 1,2            NETEZZA,ORACLE 3,4,5         SQL Server, DB2, Teradata Required Output:-  ID                   NAME 1                  NETEZZA 1                  ORACLE 3                  SQL Server 3                  DB2 3                  Teradata

1 Answers   Cognizant,

we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,

in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

2 Answers   Cap Gemini,

Explain why we use partitioning the session in informatica?

0 Answers  

How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,

Write the program through which the records can be updated?

0 Answers  

For more Informatica Interview Questions Click Here
Categories