ODS is a Replica of transactional data so it is OLTP and DW is an HIstorica

Is there any model difference between ODS and DWH

Question Posted / bharu_295

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Explain what are the different versions of informatica?

1145

Explain the code page compatibility?

1119

What is transformation?

1159

What are the performance considerations when working with aggregator transformation?

1209

Explain joiner transformation in informatica

1171

What are the components of workflow manager?

1154

What is the sql query overwrite in source qualifier in informatica

1142

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

1052

Explain the types of lookup transformation?

1104

How might you approve all mappings in the archive all the while?

1082

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2055

What is native users?

1223

What is option by which we can run all the sessions in a batch simultaneously?

1192

How many types of sessions are there in informatica.please explain them?

1210

What is informatica?

1218