Landlord PAN Card mandatory for Rent Over 8333 Per Month For HRA Exemption | Way To Cheat Indian Income Tax Department

December 15th, 2013

Landlord PAN Card mandatory for Rent Over 8333 Per Month For HRA Exemption | Way To Cheat Indian Income Tax Department

Now it is bad time for most of the salaried employee. Most of the salaried employee submit the counterfeit house rent receipt to get Income tax discount.

Till Oct salaried employee can Able to produce house rent of up to Rs 15000 per month without producing the landlord PAN number. But as per the new notice issued by Central Board of Direct Tax,salaried employee need to produce landlord PAN card if your monthly rent is over Rs8333 or yearly rent over Rs100000


What to do If House Rent Over Rs 100000 In A Year:

  • Employee will enjoy the income tax exemption on the total rent. Landlord have to pay income tax on the amount exceed Rs 100000

Do You Need To Submit Landlord PAN Number When House Rent Is below Rs 8333 per month:

  • No. No need to submit Landlord PAN Number

What Happen When Landlord don’t Have A PAN Card & House Rent Over Rs 100000 In A Year:

  • Landlord must sign the self declaration saying that he don’t have the PAN card and that copy must be submitted to the employer to get the HRA exemption

Autosys Resource use | How To Create Resource in Autosys | Autosys Resource

December 6th, 2013

Autosys Resource use | How To Create Resource in Autosys |  Autosys Resource

Resource in Autosys can be used to run one job at a time. In case you are doing multiple dimension load in a table through Autosys, you need to use autosys resource.

How To Create Resource in Autosys:

The below commands need to run in jil to create resource in autosys

insert_resource: DIM_LOAD_ODS_TABLE_RES
res_type: R
machine: bietldw-dev4101.nam.nsroot.net
amount: 1

here insert_resource — you need to give a resource name
machine: mention the dev/uat/prod unix server address
amount: maximum number of job can be run at a time

How To add Resource in Autosys JIL:

Add the following line in the Autosys JIL of every dimension  load JOB JIL:

  • resources: (DIM_LOAD_ODS_TABLE_RES,QUANTITY=1,FREE=A)


How to see created Resource in Autosys:

  • autorep -v DIM_LOAD_ODS_TABLE_RES

Citrus Pay Support Contact Email | Citrus Pay Customer Care Number

December 5th, 2013

Citrus Pay Support Contact Email | Citrus Pay Customer Care Number

Citrus Pay is a Mumbai based payment gateway service provider in India. Citrus Pay is currently one of the leading payment gateway service provider. Citrus checkout is available as a payment gateway for payment through credit or debit card.

Citrus Pay Office Address:

Citrus Payment Solutions Private Limited
302, Swati Building,
Behind Kotak Mahindra Bank,
North Avenue Road,
Santacruz(West),
Mumbai

Citrus Pay Support Email Address:

In case of any payment failure of your credit/debit card though Citrus Pay checkout, you can contact the Citrus Pay Support to the below email address:

  • support@citruspay.com

Citrus Pay Customer Care Number:

  • Call 8767709900  to contact the Citrus Pay Customer care

Hakimpur IRCTC Code | Hakimpur Rail Station code IRCTC | Hakimpur Code For IRCTC

November 29th, 2013

Hakimpur IRCTC Code | Hakimpur Rail Station code IRCTC | Hakimpur Code For IRCTC

Hakimpur is a city in the Punjab. You need to know Hakimpur rail station code to search in IRCTC website. Below we provide the Rail station code for Hakimpur Rail Station.

Hakimpur Code For IRCTC WebSite:

  • HKP is the IRCTC code of Hakimpur Rail Station

Poland Holiday Guide | Weather and seasons of the year in Poland | Travel Guide Of Poland

November 22nd, 2013

Weather and seasons of the year in Poland | Travel Guide Of Poland

Girls skiing in poland Holiday travel - Poland Skiing Guide

If you are planning to visit Poland and you are not afraid of cold weather – visit Poland in winter. What do I mean by “cold weather”? Definitely not +8 C degree! If you can bare temperatures below 0 – you can even think about staying there for longer. If you are getting married to a Polish lady/gentleman by any chance – you can even think about living there and not freezing to death: P!

Let’s assume you are very lucky, and while visiting my country you get a lot of snow and some sunshine. What to do with this unknown white substance?

Poland in Winter - Poland Travel

First of all – just enjoy it! Why? It might melt in one hour if the temperature drops suddenly – which is likely to happen. Especially now – in the global warming era. So just go for a walk to a nearby park or a forest and just admire the purity of everything that surrounds you. In south India, where I live now, you can get some snow only in shopping malls for 300 INR per half an hour: P. So admire it – when you have it – for free :P .

If you are a little bit more courageous and you are looking for a truly authentic winter holiday experience – go into the mountains.  There are cosy villages where you can take delight watching the scenery, breathe the crisp mountain air and take it easy.  It is an ideal place to visit if you want to enjoy winter without the crowds and commercialism of the larger European ski resorts. It would be a great place for sport enthusiasts of ski or snowboard too.

For a truly fun loving Indian, I would suggest a slightly different experience – to have a sleigh ride (in the worst case scenario – sledge ride from the closest slope) with your friends or colleagues if they have a soul young enough to do so :) .

Even if you fail to do this, at least make attempt to create a snowman – especially if you visit Poland with your kids. They would love it!

Poland Transport in Winter - Poland Holiday guide

Despite the joy, there are things that you must pay attention to. So remember to keep your body warm when you are outside, especially in Jan and Feb – the coldest winter months. At this time the temperature might drop to – 20 C degrees which is even cold for us – Polish. Also the days are very short so remember about it while planning your day.

Happy winter Polish day :) !

TCS Female Associates Attacked in Hyderabad | Woman Safety in Hyderabad – A Real Incident

November 22nd, 2013

TCS Female Associates Attacked in Hyderabad | Woman Safety in Hyderabad – A Real Incident

TCS Female Associates Attacked in Hyderabad-Woman Safety in Hyderabad

In the light of the heinous incident that occurred in Hyderabad last week, I want to share a few words. Maybe not of wisdom, but ones that definitely helped me stay safe:

1. After 8 pm, prefer the road transport buses to the shared autos and cabs. They may delay you but they offer a margin of safety.

2. If you have to board an auto or cab, move to its front and note down the number of the vehicle so that the driver can see you are noting down his vehicle’s number. If you tell the driver you did so, even better! ( I have done this so many times that people thought I was paranoid. Still, I would say it is better to be paranoid than hurt or traumatized.)

3. Buy a pepper spray!!!! It gives you immense confidence to walk alone and it it a good self-defense mechanism. It is pretty powerful, trust me, It was sprayed before me and the suspended particles were enough to make my nose burn and cough a lot!! (In Hyderabad, they are available in Health n Glow outlets and also you can order them online from healthkart.com)

4. Install any of those women safety apps that they advertise about. It wouldn’t hurt to download them.

5. If a man is leching at you or trying to misbehave, start screaming at him. He deserves it! It will at least stop the man from troubling you any further.

6. Other useful tips to remember I have read but not from my personal experience -
a. Use your TCS ID card to wring the neck of your assailant if he happens to be the driver.
b. Dial 100 and start screaming.
c. Remember you can hurt your assailant and I am sorry if I am crossing a line of propriety – Target his sensitive areas with your knees and your elbow is pretty powerful to hit a man.

7. We should not be carefree by chatting on mobile, playing games, talking over phone / sleeping. Pay an attention till we get down from the cab / taxi.
8. Try to stick to the same route that you travel every day.
9. Better to inform family when you onboard, and expected arrival.
10. Update your family if there is a significant delay because of traffic / road conditions. Need transparency among our family, where we are going, what we are doing, when will come back.

I just wanted to share these pointers and hope it helps!

House rent receipt Format India for HRA apply in India | How To Apply For HRA To Reduce Income Tax

November 21st, 2013

House rent receipt Format India for HRA apply in India | How To Apply For HRA To Reduce Income Tax

Are you working in India & seeking to get deduction in Income tax burden. You can easily cheat Income tax department.

Here we provide you the Scanned House Rent receipt.

Rent_receipt in India for HRA Claim for Income tax Relief

How To Submit The  House Rent receipt To Your Company:

  • Take a print out of scanned House Rent receipt provided
  • Fill the house rent receipt &signed properly in landlord name
  • Photocopy the properly filled house rent receipt
  • submit the photocopy to your company finance department
  • You will get a discount in income tax amount from next month onwards


Important Tricks To Submit Your HRA Claim:

  • You can submit the house rent receipt for one month & can enjoy the income tax relief for the full financial year
  • You need to submit the landlord PAN number incase you mentioned house rent is more than Rs15000 pRent_receipt in India for HRA Claim for Income tax Relief for month

Guide To Increase Performance Of Complex Query | Tips for writing more efficient SQL | SQL Optimization Guide

October 25th, 2013

Guide To Increase Performance Of Complex Query | Tips for writing more efficient SQL | SQL Optimization Guide

It is not so easy to optimize a complex query & decrease the load on SQL server. Here I am giving some good guide to increase the
performance of a  complex sql query. If you are a basic sql user & want to tune your complex sql query, please follow the below optimization tips.

Use minus instead of EXISTS subqueries –

  • Some say that using the minus operator instead of NOT IN and NOT Exists will result in a faster execution plan.


Index your NULL values –

  • If you have SQL that frequently tests for NULL, consider creating an index on NULL values.  To get around the optimization of SQL queries that choose NULL column values (i.e. where emp_name IS NULL), we can create a function-based index using the null value built-in SQL function to index only on the NULL columns.


Leave column names alone –

  • Never do a calculation on an indexed column unless you have a matching function-based index (a.k.a. FBI).  Better yet, re-design the schema so that common where clause predicates do not need transformation with a BIF

Avoid the use of NOT IN or HAVING-

  • Avoid using NOT In or HAVING clause in your SQL query, instead, a NOT EXISTS subquery may run faster (when appropriate)


Never mix data types -

If a WHERE clause column predicate is numeric, do not to use quotes. For char index columns, always use quotes.
There are mixed data type predicates:
where cust_nbr = “999″
where substr(ssn,7,4) = 9999

Use decode and case –

  • Performing complex aggregations with the “decode” or “case” functions can minimize the number of times a table has to be selected

Use full-table scans when necessary –

  • Not all OLTP queries are optimal when they uses indexes.  If your query will return a large percentage of the table rows, a full-table scan may be faster than an index scan.  This depends on many factors, including your configuration (values for db_file_multiblock_read_count, db_block_size), query parallelism and the number of table/index blocks in the buffer cache

Use decode and case –

  • Performing complex aggregations with the “decode” or “case” functions can minimize the number of times a table has to be selected.

Rewrite complex subqueries with temporary tables-

  • Oracle created the global temporary table (GTT) and the SQL WITH operator to help divide-and-conquer complex SQL sub-queries (especially those with with WHERE clause subqueries, SELECT clause scalar subqueries and FROM clause in-line views).  Tuning SQL with temporary tables (and materialization in the WITH clause) can result in amazing performance improvements.

Re-write NOT EXISTS and NOT EXISTS subqueries as outer joins –

  • In many cases of NOT queries (but ONLY where a column is defined as NULL), you can re-write the uncorrelated subqueries into outer joins with IS NULL tests.  Note that this is a non-correlated sub-query, but it could be re-written as an outer join.

TCS Promotion Process | TCS ITA Promotion Guideline | TCS Promotion

October 17th, 2013

TCS Promotion Process | TCS ITA Promotion Guideline | TCS Promotion

TCS PROMOTION GUIDELINE - TCS PRMOTION PROCESS 0 HAPPY EMPLOYEE - TCS ITA ASC PROMOTION

Tata Consultancy Services is currently the market leader of IT industry. Tata Consultancy Services (TCS) has a defined guideline for promotion eligibility. As discussed with the senior TCS associates, we come to know the details of promotion eligibility.

Does TCS Promotion Guideline Applicable for all TCS employee:

  • TCS Promotion Guideline is applicable for only non BPO TCS employee
  • This is applicable for all grades including ITA,,ASC.
  • The minimum total experience should be 4 years for ITA,5 years for Assistant Consultant & 7 years for Consultant.

TCS ITA Promotion Guideline:

  • Employee getting D band in last appraisal cycle are not eligible for promotion.
  • If you get  2 consecutive A band,you get ITA promotion in 3 years
  • Otherwise you will get ITA promotion in 4 years

TCS Assistant Consultant Promotion Guideline:

  • Employee getting D band in last appraisal cycle are not eligible for promotion.
  • For promotion to  Assistant Consultant or above, you need to stay minimum 2/3 years in one grade before promotion depends upon performance band.
  • TCS employee get 2 consecutive A band since last grade changes, get promotion in 2 years & others (A/B/C band) get promotion in 3 years.
  • The minimum total experience should be 5 years for Assistant Consultant


TCS  Consultant Promotion Guideline:

  • Employee getting D band in last appraisal cycle are not eligible for promotion.
  • The minimum total experience should be 7 years for Consultant
  • TCS employee get 2 consecutive A band since last grade changes, get Consultant  promotion in 2 years & others (A/B/C band) get promotion in 3 years.


TCS Promotion Process:

  • Your appraiser should initiate your promotion
  • This should be approved by reviewer & HR
  • Then the promotion should be reviewed by Unit HR/IOU owner
  • Once approved, employee will get the promotion letter on the night of the TCS quarter result is announced

Increasing CPU Performance & Reducing Memory Usage in Datastage | Way to Increase Performance In Informatica

October 11th, 2013

Increasing CPU Performance & Reducing Memory Usage in Datastage | Way to Increase Performance In Informatica

Some parallel datasets generated with InfoSphere® DataStage® 7.0.1 and later releases require more disk space when the columns are of type VarChar when compared to 7.0. This is due to changes added for performance improvements for bounded length VarChars in 7.0.1.
Set APT_OLD_BOUNDED_LENGTH to TRUE to revert to pre-7.0.1 storage behavior when using bounded length varchars. Setting this variable can have adverse performance effects. The preferred and more performant solution is to use unbounded length VarChars (don’t set any length) for columns where the maximum length is rarely used, rather than set this environment variable.
By default, the parallel engine internally handles bounded length VARCHAR fields (those that specify a maximum length) as essentially fixed length character strings. If the actual data in the field is less than the maximum length, the string is padded to the maximum size. This behavior is efficient for CPU processing of records throughout the course of an entire job flow but it increases the I/O demands for operations such as Sort. When environment variable APT_OLD_BOUNDED_LENGTH is set, the data within each VARCHAR field is processed without additional padding resulting in a decrease amount of data written to disk. This can decrease I/O bandwidth demand and therefore increase performance when running a scratch disk subsystem with insufficient bandwidth. This can increase job throughput if the scratch file system is not able to keep up with the processing capability of DataStage and the Intel® Xeon® Server. Additional CPU cycles will be used to process variable length data when using APT_OLD_BOUNDED_LENGTH. More CPU processing power is used to reduce the amount of I/O required from the scratch file system by using this setting.
By using the APT_OLD_BOUNDED_LENGTH results in a 25% reduction in size of temporary sort files and a 26% increase in throughput (a 21% reduction in runtime.)

Please note that the performance benefit of this tuning parameter will vary based on several factors. It only applies to data records that have varchar fields. The actual file size reduction realized on the scratch storage system will depend heavily on the maximum size specified by the varchar fields, and the size of the actual data contained in these fields, and whether the varchar fields are a sort key for the records. The amount of performance benefit will depend on how much the total file size is reduced, along with the data request rate of the sort operations compared to the capability of the scratch file system to supply the data.  By setting APT_OLD_BOUNDED_LENGTH, the amount of data that was written and subsequently read from the disk decreased substantially over the length of the job allowing faster completion.

Note: If you are using this option with DataStage 8.5, it is recommended that you additionally set APT_DONT_COMPRESS_BOUNDED_FIELDS=TRUE to avoid any conflicts. The net result with both of these variables set will be exactly the same behavior as previous releases with just APT_OLD_BOUNDED_LENGTH=TRUE.