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
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How can a transformation be made reusable?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Why update strategy and union transformations are active?
Quickly characterize reusable change?
Difference between Data and Index Caches?
What is the meaning of up gradation of repository?
Partition, what happens if the specified key range is shorter and longer
can we override a native sql query within informatica? How do we do it?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Target increases every day even though no new record was inserted
What is a predefined event?
How to generate sequence numbers without using the sequence generator transformation?
What is the maplet?
What are the components of Informatica? And what is the purpose of each?
