Data Warehouse “Provides information on techniques to design, build, maintain and retrieve information from data. a. AB initio – is a database module. b. Business Intelligence – BI is a process of enhancing data into information and then into knowledge. Gather, store, analyze and provide access to data. c. Informatica – database module. d. ETL - Extract, transform, and load (ETL) is a process in data warehousing that involves, extracting data from outside sources, transforming it to fit business needs, and ultimately ,loading it into the data warehouse. ETL is important, as it is the way data actually gets loaded into the warehouse e. Cognos – is an Ottawa, Ontario based company which makes business intelligence (BI) and performance planning software. f. Data Stage – Is used for data extraction, transformation and loading (ETL) solution for information intensive companies, Offers end to end Meta data Management and data integration Applications such as CRM (Customer Relation Management), ERP (Enterprise Resource Planning), and SCM (Supply Chain Management). g. OLAP - Online Analytical Processing, a category of software tools that provides analysis of data stored in a database. OLAP tools enable users to analyze different dimensions of multidimensional data. For example, it provides time series and trend analysis views. OLAP often is used in data mining. h. Report Net - Cognos Report Net. Cognos Report Net improves your performance, reduced costs—complete reporting coverage and zero-footprint environment reduce maintenance. Quicker results—seamless integration and adaptive authoring shorten reporting times. Improved decision-making—reports and dashboards present critical data in easy-to-understand formats. Increased agility—create one version of data truth across divisions, departments, countries, and more.
Don't Ask-- Only with the individual's consent: --School, college records Yes: --Social Security number --Performance at prior workplace --Credit report (but with notice to the applicant in California, Minnesota, Rhode Island, Vermont). (Under federal regulations, credit inquiries that tend to have a disparate impact on minority applicants, disabled persons or women may be closely scrutinized.) Generally Yes: --Smoke at home (The question could lead to a lawsuit; 31 states ban policies prohibiting off-duty smoking.) --Political affiliation (Some states ban discrimination on this basis and political affiliation may not be used for discriminatory purposes in federal-government employment.) Yes: --Ability to perform certain functions **The Americans with Disabilities Act governs these inquiries. Only after a job offer and only if all are treated the same: --Medical examination --Medical conditions --Urine test for drug use (13 states have further restrict...
Comments