Skip to main content

Data Warehousing

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.

Comments

Post a Comment

Popular posts from this blog

Staffing Blog for Recruiters

Recruiter: This Is a Staffing Blog Dedicated to all the recruiters. A recruiter is someone engaging in recruitment which is the solicitation of individuals to fill jobs or positions within any group such as a sports team or corporation. Recruiters can be divided into 2 groups: those working internally for one organization, and those working for multiple clients in a 3rd-party broker relationship, sometimes called headhunters. Internal recruiter: An internal recruiter is member of a company or organization, and is typically works in HR (human resources), which in the past was known as the Personnel Office, or just Personnel. These individuals can be multi-functional in that they work in an HR generalist role (hiring, firing, exit interviews, employee disputes, contracts, benefits, recruiting, etc.) or they can work in a specific role focusing all their time in the area of recruiting. They can be permanent employees, or hired as contractors for this purpose. Contract recruiters ten...
7 comments
Read more

Project SDLC

For a general understanding of the Project SDLC and we would also like to add that there can be changes to the user or roles and responsibility of the different participants mentioned in the SDLC. Most of the times recruiters are confused as to what is SDLC and wonder about the different roles and responsibilities carried out by the participants mentioned below. Explanation provided below will actually help you understand different user with in the different phases of SDLC and where they come into picture to actually be in a better position to question a consultant against the requirement on hand. It is important to understand the needs, goals, and challenges of the project .The Customer objectives can be defined by the business requirements which are used to determine the scope of the system. When start by defining the business requirements, it is important that the team look at all type...
1 comment
Read more

DO and DON'T on a call

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...
2 comments
Read more