Know Your EPF Account BALANCE.

By using the below link you can view your EPF Balance.

http://epfindia.com/site_en/KYEPFB.php

Employee PF Account Number :   ?

There are 3 Text Boxes.
In which you got to  fill the FIRST & 3RD one.
The 2nd Text Box is not a mandatory one.


Eg: TN/12345/54321 is your PF Account No.

Then give 12345  in the First Text Box.

54321 in the last Text Box.

Note :  Make sure you select the  STATE & ESTABLISHMENT CODE correctly.

Centralized Data Across COUNTRIES

                                        COUNTRY X....The Problems that are faced in COUNTRY X and remedies they have for them, If we get that data centralized then other countries can use it and implement it accordingly.

                                       We have the Passport related information containing in a database i.e used to verify the identity of the citizen.But it is more secured and can't be viewed by all the people.

                                        MOSQUITOES are common in most of the countries.
                                        UNEMPLOYMENT is common in most of the countries.
                                        DISEASES are common in most of the countries.

                                       If we have Centralized solutions related data for the above kind of common things of all the countries, then other countries can utilize the soloutions and can become developed countries.

GOD Exists or Not?

                                  For this Q, Everybody might have Watched Umpteen Movies, Read Articles/News like anything.
                                 Ultimately, NoBody has seen GOD till Now. GOD Hasn't come & shown up to anybody irrespective of RELIGION.

Highlights you find in Movies/News :

                          *People going to Pilgrim Towns to worship GOD, on Buses are  DYING every Year. Why GOD hasn't RESCUED them?
                          *Why GOD is not helping BEGGARS before TEMPLES?
                          *Why RAPES,MURDERS,PLANE CRASHES,EARTHQUAKES are happening if GOD exists?


Opinions you find in Movies/News :
                           *People made GOD.
                           *NoBody has seen GOD.
                           *People who SAVE/HELP other People irrespective of RELEGION/CASTE etc are                              only GOD's.    

Earning? Are you using it for your .........?

                         
                             Everybody is earning Money according to their capacity. But, Due to one's own situations, one is spending Money like anything and Hence it is happening like water passing from a PIPE with holes TOP & BOTTOM.

SCENARIO 1 :
                       1. List out your WISHES that wants to do in a span of a YEAR or TWO.
                       2. Put Money Aside accordingly for your OWN wishes.
                       3.SPEND it once your WISH DAY comes.

Long Term Capital Gains Vs Short Term Capital Gains

Loss from Equity Shares
Can Carry Forward for 8 years if you have filed an Income Tax Return

Long term capital loss 
Is a dead loss – it can neither be adjusted or carried forward.

Taxation of Dividends received on shares:

Any dividend received on shares held in Indian company is fully exempt from payment of tax. However the company is required to pay a tax called Dividend Distribution Tax on such dividend at the rate of 15 percent on such dividend. So effectively 15 percent tax on your behalf has been paid by the company on the dividends received by you.

Read more at:Long Term Capital Gains

Delimeter you can rely on

In order to put a delimeter for a flat file, which should not be a part of string in the flat file.

Then you can rely on VERTICAL TAB.

Number 11  is for VERTICAL TAB.

The following VALUE should be given in column delimeter property of output file.

String.valueOf((char)11)

Important Property of tParallelize

Basic Settings in tparallelize:

Die when one of parallelize subjobs fail

There is a checkbox for the above in Basic settings.

If we use that, even if  one of the parallelize  subjob fails, then the job will die at that point.

Sharing tPostgresql Connection

Basic Settings Checkbox Property : Use or register a shared DB Connection

1) Can give the static name or a value thru Context variable.
     Static name should be in double quotes.

2)In the first tPostgresql Connection,  give a static name after providing all connection details in the corresponding properties.

3)From the second tPostgresql connection, you don't have to mention any connection details, except the Use or register a shared DB connection, by giving the same static name which you have given in the first tPostgresql Connection.

Built-in functions used frequently

CONTAINS & EQUALS :

row1.contains("ram")
row2.equals("Name")

LASTINDEXOF :
("tFileList_1_CURRENT_FILE")).lastIndexOf("."))

SUBSTRING:
m-- starts from 0 .. refers to the position.
n -- starts from 1 -- refers to the position itself (not the no: of the characters)

Input  :  "ABCD".substring(0,2)
Result :   ABC
substring(m,n)


GETTING CURRENT FILEPATH  IN tFILELIST :
((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))

GETTING CURRENT FILENAME FROM  tFILELIST :
((String)globalMap.get("tFileList_1_CURRENT_FILE")).substring(0,((String)globalMap.get
("tFileList_1_CURRENT_FILE")).lastIndexOf("."))

replace() Example :
-------------------------
we can use this for replacing special characters in a string

String input_row="abcd:[],kdkkxyzkll:[],";

String abc="{\"NOTIFICATION_RESPONSE\":{"+input_row.replace(":[],",":\"\"")+"}}";

System.out.println(abc);
Output :
-----------
{"NOTIFICATION_RESPONSE":{abcd:""kdkkxyzkll:""}}

Note :  Go for replace() if  replaceAll() is not working.
replaceAll() will not work for dollar ($),doublequotes("),comma(,) etc special characters, in such cases you can go for replace().


split() Example :
-----------------------

package com.myjava.string;

public class MyStrSplit {

    public static void main(String a[]){

     

        String str = "This program splits a string based on space";

        String[] tokens = str.split(" ");

        for(String s:tokens){

            System.out.println(s);

        }

        str = "This     program  splits a string based on space";

        tokens = str.split("\\s+");

    }

}

No: of Child Threads Property of tPartitioner

No : of child Threads  is nothing but the no: of CPU's of the particular machine on which TALEND APPLICATION is running.

we can get the no: of child threads in the below way.

Runtime.getRuntime().availableProcessors()

Note :   If we give more than the no: of CPU's that our machine has, will give in-appropriate results while using tPartioner & tCollector components.

creating a request in tXMLMAP

1) Add a column
2)Make the datatype as document
3)Import the schema which is already created by checking the checkbox in ESB component.

tPrejob & tPostjob Components

we can perform different type of activities by using the tPrejob & tPostjob Components.

tPrejob :   This will be first component to be run in the Talend job.

                  1)  Run the Child jobs.
                  2) Drop the Database Indexes
                  3)Truncate the Database Tables.
                  4)Disable the Indexes of TABLES.

tPostjob :   This will be last component to be run in the Talend job
         
                1)Re-create the Indexes which are dropped in tPrejob
                2)Enable the Indexes which are disabled in tPrejob

Note : Pre & Post jobs will work even if the job fails.

Solution for ZIP file Deployment of Talend job in TAC

After configuring the normal properties that Talend Documentation says, deployment fails because of some default settings in Internet Explorer.

The solution for it is as follows.

Solution 1 :  It works well if you create a TASK in CHROME browser instead of INTERNET EXPLORER.

Note :  1 thing to remember is the TAC webpage consists of multiple pages for the TASKS. check for the last page for your task    created.


Solution 2 :  In INTERNET EXPLORER,  you got to do some settings configured as below.
                   Tools --> Internet Options --> Security --> Custom Level --> DISABLE  "Include Local Directory Path when Uploading files to Server".

Config file not picking up in TAC

This occurs mainly when the PROJECT  is RENAMED.

So,prepare a pre-requiste list of items that are needed to be added when project is renamed.

1)Any custom components needs to be added.
2)Custom components specifically used in context parameter file JOBLET/JOB used.

Summary :
--------------
-->Add and apply Custom components to the project.

Example 4 Efficient For Loop in Talend

String Col="abcd,efg";
String[] filters = col.split(",");
String CFILTER = "WHERE ( ";

for(String filter : filters ) {
  CFILTER += " OR (\"STATUS\" LIKE '%"+filter+"%')";
}

The above split function will split the passed string into multiple rows.
for loop will be iterating till the last row.
we don't have to mention any start/end in the for loop.

String 2 Date Conversion

Input.First_Date.equals("null") ? null :  TalendDate.parseDateLocale("MM/dd/yyyy HH:mm:ss aa",Input.First_Date,"EN")

DATA TYPE CONVERSIONS

String to Integer ---  Integer.parseInt(row1.myString)

String to Date --  TalendDate.parseDate("dd-MM-yyyy",row1.myString)

String to BigDecimal -- new BigDecimal(row1.myString)

String to Float --  Float.parseFloat(row1.myString)

String to Long  --  Long.parseLong(row1.myString)

Integer to String -- variable+"" or variable.toString()

Date to String --  TalendDate.formatDate("yy-MM-dd", row1.myDate)

BigDecimal to String -- row1.myBigDecimal.toString()

Everybody is a SLAVE to EGO/ANGER

                                   Once in a Life time, Everybody has become a SLAVE to EGO/ANGER.
It's very difficult to avoid EGO/ANGER in his own life. Facing various attitudes of people in our daily life, we unknowingly become a SLAVE to EGO/ANGER.

                                    But, Once you come to know it by thinking on the discussion/conservation you had which is the basis of EGO/ANGER, you can reduce your ANGER/EGO when we face the same kind of situation again. It can happen only when we think on the conservation/discussion and come to a conclusion like "I should have done this in a different way",  "I should have dealt it in a better way than this."

SHORTCUTS in EXCEL

Ctrl + Shift + L

Apply filter on selected column headings.

Ctrl+h

Display the Find and Replace dialog box (with Replace selected).

Shift+F4

Repeat last find.

Ctrl+g (or f5)

Display the 'Go To' dialog box.

Ctrl+z	Undo last action (multiple levels).
Ctrl+y	Redo last action (multiple levels).

Ctrl+Alt+v

If data exists in clipboard: Display the Paste Special dialog box.

Shift+Space	Select the entire row.
Ctrl+Space	Select the entire column.

F2	Edit the active cell with cursor at end of the line.

Ctrl+Delete	Delete text to the end of the line.
Ctrl+; (semicolon)	Insert current date.
Ctrl+Shift+: (colon)	Insert current time.

Shift+F2	Insert / Edit a cell comment.
Shift+f10, then m	Delete comment.

For More :
http://www.shortcutworld.com/en/win/Excel_2010.html