Pages

Subscribe:

Ads 468x60px

Thursday, 24 May 2012

To Ask for a Salary Increment or To Not?


You are currently happy with your work, but unhappy with pay?  Do you need a rise in pay to assist your relatives and family?  Otherwise, you may be interested in your supervisor asking for a raise.  If this is the case, you will want to continue reading on. Some of the many factors that should be taken into account before you decide to ask your employer for a raise are outlined below for your convenience.

One of the many factors you want to consider when trying determining if you should ask for a raise, it is your duty.  Have recently taken more functions on the job?  If you have been compensated for these additional duties?  If not, you may be within your rights to ask the pay raise.  With this in mind, it is also necessary to examine the other aspect of duties.  If you recently had the reduced workload, you want to refrain from asking for a pay raise, how can give off an unpleasant impression of yourself.

Age is another factor that you want to consider when trying to determine if you should ask for a pay raise.  The duration of employment can play a huge role in if you are not able to receive a raise they hoped.  Generally speaking, the longer working for a company, the more likely it is you will be able to get a raise.  In fact, before asking for a raise, you might want to refer to your employee manual, how your company may already have a pay raise plan in place.

The minimum wage for your state is another of the many factors you want to consider when considering pay raises.  In recent years, States have made the decision to increase their rates of pay the minimum wage. In fact, some of these wage increases were quite high.  You want to make sure that you are making more than minimum wage.  If your State has recently increased its minimum wage, your employer must have done so as well, but there is no harm in checking.  It might also want to see on request for a pay raise that will increase your salary in conjunction with any increases in the minimum wage in the State.  For example, you want to make sure that you are doing at least a few dollars more than an hour over all new hires.

Talking about the starting salary for your company, we recommend that you verify this information.  Generally, long-term employees should make more money than new hires, particularly in similar positions.  You may be able to examine the average starting pay for new hires in your business by examining any company job listings that you're able to meet. You may also be able to obtain information from other employees about their salary. With this in mind, many companies require confidentially when bound to pay.  Therefore, if you are aware of an employee's income, you will want to refrain from citing that as an example with the supervisory authority.

The factors listed above are just some of the many factors that you will want to consider before making the decision to ask for a raise.  If you decide to ask for a raise, you want to adopt a positive approach, friendly, when in this way.
Off course, everyone is needing to get higher salary in job. Present trend is if existing management doesn't pay more then leave job and pick up new job. For fetching new job is not easy in nowadays because technical interview becomes very strong. Only Oracle DBA success kit like Oracle DBA Interview Questions book can help at this time and you are able to get job very easily.

Sunday, 13 May 2012

Query Rewrite in Oracle for Data Warehousing Application

Query Rewrite in Oracle for Data Warehousing Application



There are several ways that you can affect the optimizer’s logic in rewriting a query. First using the QUERY_REWRITE_ENABLED parameter, you can enable or disable the ability of the entire database to do query rewrites. This feature is very useful to maintain data warehouse database. Oracle supports so many good features and those are very useful in data warehousing database.


The QUERY_REWRITE_INTEGRITY parameter determines the freshness that is required of a materialized view. The options for this parameter are


ENFORCED:


The default setting for the QUERY_REWRITE_INTEGRITY parameter, this setting tells the optimizer to use only materialized views that contain fresh data. This setting also instructs the optimizer to use relationships that are based on enforced constraints like NOT NULL and Foreign key.


TRUSTED:

In this mode, the optimizer trusts that the data in the materialized views is correct and the relationships are correct. The optimizer also trusts declared but not enforced relationships and constraints, and it will use relationships specified by dimensions


STALE_TOLERATED:


In this mode, the optimizer trusts that the data in the materialized views is correct even if the views aren’t current and fresh. This mode offers the greatest flexibility in terms of rewrite capabilities but with the risk of returning incorrect results.


The safest level if rewrite integrity is ENFORCED. This setting guarantees that no data returned y the materialized view will be out of sync with a similar query against the base tables the base tables of the materialized view.


We can change above parameters in session level too using following commands.


Alter session set QUERY_REWRITE_ENABLED=true;
Alter session set QUERY_REWRITE_INTEGRITY=stale_tolerated;

This kind of questions can be asked during Oracle DBA interview questions and you can also need to take care for performance tuning during database services activities.