‘Uncategorized’ Archives
Business Intelligence – Systems Analyst II – The City of Edmonton, THE CITY OF EDMONTON Edmonton, AB, CANADA
We are a team committed to enhancing the quality of life for our residents. We are inspired by a shared vision and a certainty that our City on a river is one of the most spectacular places on Earth. We are: An ENERGY City A City of DESIGN A City that LINKS the continent with the north and with Asia A RECREATION City An [...]
Analyst, CANADIAN TIRE CORPORATION, LIMITED
Job Description Analyst-C043KE Description COMPANY SUMMARY: Canadian Tire offers employees a wealth of challenging and rewarding career opportunities. We are a successful and growing company that values diversity and innovative thinking, and fosters a culture of performance and accountability. We invest in the growth and development of our [...]
Defination of Correlated Subquery
In job interview for a database / sql programmer a question is sometime asked what is a correlated Sub query? A sub query containing an outer reference is called correlated sub query, because its results are correlated with each individual row of the main query. For the same reason, an outer reference is sometimes called a correlated reference. [...]
Data Staging (ETL) in Business language
We are researching Specifically with business users in mind and accordingly presenting some information On Data Staging which is ; Getting data out of source systems and into the data warehouse in reasonable and rational format is by far the largest effort of building data warehouse. This activity can account for 80% of the total efforts of the [...]
Data mart & crystal reports
Data marts can bring diverse data sources into one place for timely, detailed information to make smart business decisions and easy report creation with Business Objects, Cognos, Crystal Reports, SAS and other tools.
Accounting centric data warehouse / accounting data mart
Building an Accounting centric data warehouse (ACDW) is an incremental process. Overtime collection of data marts, each supporting a different analytical need or business process, are developed to composed the ACDW. What makes ACDW different from a data warehouse is the General Ledger integration. With GL data, a complete top to bottom view of the [...]
Functional datamarts
A data mart is a subset of an Enterprise Data ware house, perform the role of departmental, regional, or functional data ware house. An organization builds a series of data marts over time and eventually linked them via an enterprise wide, logical data warehouses. A data mart is generally focuses on single subject area and is generally determined [...]
