Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / bidhar
ODS can be described as a snap shot of the OLTP system.It
acts as a source for EDW(Enterprise datawarehouse).ODS is
more normalised than the EDW.Also ODS doesnt store any
history.Normally the Dimension tables remain at the ODS
(SCD types can be applied in ODS)where as the Facts Flow
till the EDW.
More importantly Client report reqiurements determing what
or what not to have in ODS or EDW.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is the Rank index port in Rank transformation?
What is the format of informatica objects in a repository?
How to join three sources using joiner? Explain though mapping flow.
What is union transformation in informatica?
In development project what is the process to follow for an etl developer from day1
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain the difference between mapping parameter and mapping variable?
What is persistent lookup cache?
What are the issues you have faced in your project? How did you overcome those issues?
Define update strategy?
What do you mean incremental aggregation?
What is a stored procedure transformation?
What is status code in informatica?
How to generate sequence numbers without using the sequence generator transformation?
