Is there any model difference between ODS and DWH
Answer Posted / 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 View All Answers
explain about unit testing? in real time?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is enterprise data warehousing?
How to handle decimal places while importing a flatfile into informatica?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is a surrogate key?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How do you change a non-reusable transformation to reusable transformation?
How can we delete duplicate rows from flat files?
Is there any target staging area in informatica not staging area
What is rank index in rank transformation?
Can we create a Integration service without a Repository service and vice versa?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is a rank transform?