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

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

Screening Resumes

When screening and evaluating resumes, recruiter must consider the following information: · Previous job responsibilities and past related work experience that may suggest future performance. · Special skills and qualifications. · Dates of employment. Staff will look for unaccounted gaps of time or conflicting dates, which may suggest instability or unsuccessful work experiences · Salary information. · Verifiable facts. Positions held, responsibilities, dates of employment, salary, etc. After the close date of the recruitment, the Job Expert for the hiring department and Human Resources will screen the application forms or resumes for minimum education and qualification requirements. A recruitment date may be extended if there are no qualified candidates. Recruitments can also be open until the position is filled; in this situation, applicants are reviewed and interviewed on a regular basis until an eligible candidate can be selected and appointed to the available position.
Post a 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