ODS - Operational Data Store.
ODS Comes between staging area & Data Warehouse. The data is ODS will be at the low level of granularity.
Once data was poopulated in ODS aggregated data will be loaded into into EDW through ODS.
ODS: ODS is also a simalar small DWH which will help analyst to analysis the bussiness.It will have data for less number of days. generally it will be around 30-45 days. Like DWH here also we will primary keys will be genrated, error and reject handling will be done.
By using Aggregator transformation with first and last functions we can get first and last record.
A few more ...
- Cognos Decision Stream
- Oracle Warehouse Builder
- Business Objects XI (Extreme Insight)
- SAP Business Warehouse
- SAS Enterprise ETL Server
Tools of SAS are :-
- SAS Information delivery portal.
- SAS data integration studio.
- Business Intelligence.
-SAS Enterprise Guide.
he Latest Version is 7.2
informatica 8.0
Granularity , is the level of detail in which the fact table is describing, for example if we are making time analysis so the granularity maybe day based - month based or year based
Webmaster 20th of May 2012
Tell us what you feel about Extract, transform, load (ETL) Interview Questions and Answers
All comments will be published after review. No login or registration is required to post a comment on Extract, transform, load (ETL) Interview Questions and Answers We offer and invite you to submit your valuable comment now; Please be respectful of others when commenting. Insulting others, self-promotional comments, website promotional comments, marketing stuff, SEO Techniques, SMS-style content and off-topic comments will not be approved at this information portal.
So start sharing your thoughts regarding Extract, transform, load (ETL) Interview Questions and Answers
Thank you.