The operational data store (ODS), also called operational data storage, is a data set used to support daily global applications of enterprises. It is a data storage technology between DB and DW. According to the definition given by experts, it is a topic-oriented, integrated, current, and "volatile" data set, which reflects the instant of slicing at a certain time, A collection of business analysis systems and peripheral systems used to exchange data
what is ODS.
The ODS (Operational data Store) is an optional part of the Data Warehouse architecture that has some of the features of the data warehouse and some of the features of the OLTP system, which are "topic-oriented, integrated, current, or near-current, changing" data.
ODS is a theme-oriented, integrated, variable, and current collection of detail dat
I was lucky to have met both of them. Fortunately, the following two solutions helped me and shared them with you:
Start with activate:
Activation of M records from datastore object terminated
Q:
I am trying to activate the records in my ODS and getting the error above. I have been able to successfully load and activate initiate request, but now am having trouble with the activation. the record count hasn' t increased, and I have looked at the sett
You may encounter a situation in which a file is converted to another format in your daily work, and in this article you will learn how to use the control free Spire.xls for. NET (Community Edition) to convert Excel documents to PDF, IMAGE, HTML, TXT, XML, XPS, CSV, ODS, SVG, EMF, xlsm and other formats for your reference.Tool Use:After installation, reference Spire.XLS.dll in the project (the DLL can be obtained in the Bin folder under the installati
Ods-bi in the construction of ETL to occupy 1/3 of the time, deep feelings. The modeling of BI, from the physical data layer, the logical data layer, the business logic layer at all levels, there are many automated tools to handle.However, the process in ETL must be designed according to the performance. Summarize the next few parts.1. Data source/Data target managementTo determine the table, file, or restful url,odbc of the data source, it is worth n
Report get_ods_oss_information (sa38)
This report provides the following technicalInformationOn the Structure of the DSO/ODS object
Active table
Activation queue table
Change log table
Technical name
Logical name
Infoobjects entailed in the ODS object as welll as the following information on these infoobjects;
Key
IO type
Nav. ATTR.
ATTR. Only
ODSIs a flat table, soKeyThe setting is very important, not many, and it is easy to repeat more data, especially when used for counting. It cannot be less. If less data is used, it overwrites data, especially when configuring tables.
No
MongoDB Import Script#!/bin/shEcho"${0} Import data to MongoDB"Tagfile="/srv/mss_data/dim_customerex_mobile_stat_ ' Date +%y%m%d-d"-1 Day"'. Log"Impdatafile="/srv/mss_data/dim_customerex_mobile_stat_ ' Date +%y%m%d-d"-1 Day"'.
)* Public synchronized string geturl ()* Public synchronized void settnsentryname (string TNS)* Public synchronized string gettnsentryname ()
At the same time, oracledatasource implements the java. Io. serializable and javax. Naming. referenceable interfaces.
Independent use of data sources
In practice, you can register oracledatasource to JNDI or use it independently. Here is an example of using oracledatasource separately:
// Initialize the data source instanceOracledatasour
:Attribute name attribute data type descriptionThe type of the JDBC driver used by drivertype string, including oci8, thin, and kprb.URL: the URL of the string database connection.Tnsentry string TNS entry nameIn addition to the methods defined in the javax. SQL. datasource interface, The following methods are also implemented:* Public synchronized void setdrivertype (string DT)* Public synchronized string getdrivertype ()* Public synchronized void seturl (string URL)* Public synchronized string
Before changing log, we need to know its parent ODS (BI 7Is called DSO ). ODS is like a commonTableAnd we often access ODS by reading its activeData Table to obtain ODS data. Because we only understand the storage structure of data in ODS, we will not discuss other features
Etl,extraction-transformation-loading abbreviations, Chinese names are data extraction, conversion, and loading.
Most warehouse-based data architectures can be summarized as:
Data source-->ods (operational datastore)-->DW-->DM (data mart)
ETL throughout its various links.
First, data extraction:
It can be understood that data from the source data is pumped into the ODS or DW.
1. Source Data type:
relation
Server 2005 Dedicated Administrator connection (DAC) tips for using
1 What is a dedicated administrator connection?
SQL Server 2005 provides an administrator with a special diagnostic connection for use when it is not possible to establish a standard connection with the server.
2 What is the use of a dedicated administrator connection?
Even when SQL Server does not respond to standard connection requests, administrators can use this connection to access SQL Server to perform diagnostic que
Referring to the North American War of Independence, the first reaction in most people's minds was the words "Washington", "the Gunfire of Lexington" and "The Victory of York", and what we are going to say today is the "York victory", known as the war after the North American Revolution.What is there to talk about in this battle? Is it that Washington led the high-spirited army to sweep the fallen leaves and beat Britain? Yes, but this is a formal statement after the American media has controlle
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.