ADDING CRON TRIGGER OR SCHEDULING JOB IN TALEND OR TAC

For those unfamiliar with "cron", this means being able to create a firing schedule such as: "At 8:00am every Monday through Friday" or "At 1:30am every last Friday of the month".

A "Cron-Expression" is a string comprised of 6 or 7 fields separated by white space. The 6 mandatory and 1 optional fields are as follows:

Field Name Allowed Values Allowed Special Characters
Seconds 0-59 , - * /
Minutes 0-59 , - * /
Hours 0-23 , - * /
Day-of-month 1-31 , - * ? / L C
Month 1-12 or JAN-DEC , - * /
Day-of-Week 1-7 or SUN-SAT , - * ? / L C #
Year (Optional) empty, 1970-2099 , - * /

The '*' character is used to specify all values. For example, "*" in the minute field means "every minute".
The '?' character is allowed for the day-of-month and day-of-week fields. It is used to specify 'no specific value'. This is useful when you need to specify something in one of the two fileds, but not the other. See the examples below for clarification.
The '-' character is used to specify ranges For example "10-12" in the hour field means "the hours 10, 11 and 12".
The ',' character is used to specify additional values. For example "MON,WED,FRI" in the day-of-week field means "the days Monday, Wednesday, and Friday".
The '/' character is used to specify increments. For example "0/15" in the seconds field means "the seconds 0, 15, 30, and 45". And "5/15" in the seconds field means "the seconds 5, 20, 35, and 50". You can also specify '/' after the '*' character - in this case '*' is equivalent to having '0' before the '/'.
The 'L' character is allowed for the day-of-month and day-of-week fields. This character is short-hand for "last", but it has different meaning in each of the two fields. For example, the value "L" in the day-of-month field means "the last day of the month" - day 31 for January, day 28 for February on non-leap years. If used in the day-of-week field by itself, it simply means "7" or "SAT". But if used in the day-of-week field after another value, it means "the last xxx day of the month" - for example "6L" means "the last friday of the month". When using the 'L' option, it is important not to specify lists, or ranges of values, as you'll get confusing results.
The '#' character is allowed for the day-of-week field. This character is used to specify "the nth" XXX day of the month. For example, the value of "6#3" in the day-of-week field means the third Friday of the month (day 6 = Friday and "#3" = the 3rd one in the month). Other examples: "2#1" = the first Monday of the month and "4#5" = the fifth Wednesday of the month. Note that if you specify "#5" and there is not 5 of the given day-of-week in the month, then no firing will occur that month.
The 'C' character is allowed for the day-of-month and day-of-week fields. This character is short-hand for "calendar". This means values are calculated against the associated calendar, if any. If no calendar is associated, then it is equivalent to having an all-inclusive calendar. A value of "5C" in the day-of-month field means "the first day included by the calendar on or after the 5th". A value of "1C" in the day-of-week field means "the first day included by the calendar on or after sunday".
The legal characters and the names of months and days of the week are not case sensitive.
Here are some full examples:

Expression Meaning
"0 0 12 * * ?" Fire at 12pm (noon) every day
"0 15 10 ? * *" Fire at 10:15am every day
"0 15 10 * * ?" Fire at 10:15am every day
"0 15 10 * * ? *" Fire at 10:15am every day
"0 15 10 * * ? 2005" Fire at 10:15am every day during the year 2005
"0 * 14 * * ?" Fire every minute starting at 2pm and ending at 2:59pm, every day
"0 0/5 14 * * ?" Fire every 5 minutes starting at 2pm and ending at 2:55pm, every day
"0 0/5 14,18 * * ?" Fire every 5 minutes starting at 2pm and ending at 2:55pm, AND fire every 5 minutes starting at 6pm and ending at 6:55pm, every day
"0 0-5 14 * * ?" Fire every minute starting at 2pm and ending at 2:05pm, every day
"0 10,44 14 ? 3 WED" Fire at 2:10pm and at 2:44pm every Wednesday in the month of March.
"0 15 10 ? * MON-FRI" Fire at 10:15am every Monday, Tuesday, Wednesday, Thursday and Friday
"0 15 10 15 * ?" Fire at 10:15am on the 15th day of every month
"0 15 10 L * ?" Fire at 10:15am on the last day of every month
"0 15 10 ? * 6L" Fire at 10:15am on the last Friday of every month
"0 15 10 ? * 6L" Fire at 10:15am on the last Friday of every month
"0 15 10 * * 6L 2002-2005" Fire at 10:15am on EVERY DAY of every month during the years 2002, 2003, 2004 and 2005
"0 15 10 * * 6#3" Fire at 10:15am on the third Friday of every month
Pay attention to the effects of '?' and '*' in the day-of-week and day-of-month fields!
NOTES:
Support for the features described for the 'C' character is not complete.
Support for specifying both a day-of-week and a day-of-month value is not complete (you'll need to use the '?' character in on of these fields).

What I WISH

MEDIA(NEWSPAPER/TV CHANNELS) :

                                   All are equipped with Murders,Deaths,Attacks,SUICIDES etc majorly.

       ****  Newspapers shouldn't get any Bad NEWS even if they search thru BIOSCOPE.

        *** The Newspaper should be filled with only good news of NEW                         BIRTHS,MARRIAGES,FESTIVALS.

 ***AD LESS NEWSPAPERS.

GOD :

                  () Mostly 98% of people go to temples becoz of FEAR of HIM. 

                  ()100% of people will definitely ASK something in RETURN by giving atleast 1 RUPEE                      to HIM.                                     

                 

                 ()People shouldn't do prayers with  FEAR of GOD.

                 ()They should get PEACE when they go to TEMPLE and they would get it only if they 

                    won't make a checklist of what needs to ASK GOD.

WIN/LOSS :

                      ()where ever there is a SPORT, obviously there would be a WINNER and a LOSER.

                      ()one should keep in MIND that a WINNER of today of a particular SPORT will be                                replaced by SOMEBODY at some point of TIME.

  

SCHOOLS :

                      ()Most of the Countries give EDUCATION  via SCHOOLS/COLLEGES to children.

                      ()70% of the STUDENTS are facing UNEMPLOYMENT once they step into LIFE.

                      

                      ()Government should remove certain DEGREES which are of no USE TODAY.

                      ()Government should produce STATISTICS in TV's of the POSITIONS that are                                      available for the particular YEAR for the particular DEGREES.

                      ()At School Level, Teachers should be given proper TRAINING of  What course 

                         should the STUDENTS take after their SCHOOLING that might help their FUTURE.

                 

GATHERING ALL CREATE TABLE STATEMENTS IN POSTGRES DATABASE

=========================================================
GATHERING ALL CREATE TABLE STATEMENTS IN POSTGRES  DATABASE
=======================================================
1)SELECT any one table, right click and click on BACKUP
2)In FILE OPTIONS TAB, Give any filename by selecting the path
3)select format as PLAIN
4)In DUMP OPTIONS #1 TAB, select ONLY SCHEMA in TYPE OF OBJECTS
5)In DUMP OPTIONS #2 TAB, select Verbose Messages in TYPE OF OBJECTS(This is default option , so you don't hav to do any)
6)In OBJECTS TAB, Select all the tables you want.
7)Click on Backup Button

That's it, The output file does consists of all the tables with CREATE STATEMETNS you Want.

Going To Have ARRANGED MARRIAGE??? How to Make it Efficient?

                                 In India, Most of the marriages will be Arranged ones. Even Though we watch many many love stories in Indian Movies, In Real Life it can't be possible because of various reasons.

                                  A Boy(< 25 Age)/A Man( > 25 Age) will see a Girl/Lady and fall in Love.

But, he/she doesn't know the age of other person, doesn't know the CASTE of other person, doesn't the Employment/Education Status of other person.

Ok. Even if one comes to know about all the stuff, then intercaste Marriage/UnEmployment/Less Education will always lead to drop off  of LOVE.

Hence ARRANGED MARRIAGE comes into Picture.

OK OK ... I am coming into the point of ARRANGED MARRIAGE.

                                       ARRANGED MARRIAGE is good if  the Bride & Groom doesn't have any problems after Marriage. On the other side of the COIN, It is obviously BAD if they face all PROBLEMS after Marriage which leads to DIVORCE/EXTRA MARITAL AFFAIRS/DEATH/SUICIDE etc.... all of these which we are seeing DAILY in News Papers.

                                      What If we have a FORMULAE/PROCESS  that makes the ARRANGED MARRIAGE successful atleast to 60%.


1)The Bride/Groom won't have a better communication until the MARRIAGE. Hence, the pair needs to adjust/Manage/Mould themselves in order to satisfy the other. If NONE of the pair are not willing to do so, then obviously it leads to distruction of MARRIAGE.

BETTER COMMUNICATION :
=======================
                          What is meant by BETTER COMMUNICATION? Does it mean to talk with each other 24/7 daily in mobile on unnecessary stuff like what have you eaten, what are you doing, what did you do yesterday, what are doing now, today etc....?

                                     In my Opinion, He/She should know ABOUT

                                   1)Other Person's Character by posing the questions related to them.
                                   2)How He/She takes a Decision?
                                   3)How He/She treats Elders/Youngers?
                                   4)How Many Friends does HE/SHE has?
                                   5)If your father gives one Lakh rupees to you what will you do?
                                 

He/She should prepare a list of questions and need to have a conversation with  Bride/Groom.

I am listing out some of the Questions for sample.

1)By knowing the Academic Career of 10th/12th/Degree Percentages you can get to know about his/her's Intelligence.
The Percentages might have come by Mugging/ Pure Intelligence. What ever it is, It shows the Concentration,Punctuality He/She has over Education.

2)How many friends does He/She has?
    What are the Names of  his/her's Best Friends?
While having this conversation the answers should come abruptly or within few seconds or can take some time. But the answers should come, otherwise, it clearly determines the person as INTROVERT and needs to take MORE time to mingle with OTHERS.

3)What are the Achievements He/She made till now?

4)What does  MARRIAGE mean in your opinion?

5)What does LOVE mean in your opinion?

6)How do you define MONEY?

The above are some of the sample ones, likewise you can prepare some on your OWN and pose them  on your PARTNER accordingly.

                            Make Sure you do have ANSWERS before you POSE to your PARTNER. If you don't know/had Bad  the answer then you are UNFIT to your PARTNER.

                          Prepare a List like this, Give some points which makes you Satisfactory.
After the conversation, check the Points and then goahead/carry on accordingly.


There is an African Proverb

"Show me your friend and I will show you your character." 

Get to Know about the Friends of HIM/HER and have a conversation with them to know your PARTNER's Character.

What If I KNOW MOSQUITOES Language?

                                        Yesterday I got a wierd thought about MOSQUITOES.
At my Home, Lots of mosquitoes daily enjoying being in HEAVEN as they suck the blood of ours like anything.
                         

                   1)If Mosquitoes are very less, I was thinking like MOSQUITOES might have gone for a marriage of one of the mosquitoes relative.

                  2)If I come to know Mosquitoes Language, I would ask them what they are in need of other than blood and provide it so that both of us are beneficial(Atleast sucking blood will be avoided).

                  3)More over I can open a Training Centre, How to Learn MOSQUITOES LANGUAGE in 30 days (FULLY REFUNDED IF language not comes) and can become a MILLIONAIRE.

                 4)If we know the MOSQUITOE LANGUAGE, we don't need an ARMY for a country also. MOSQUITOES ARMY will suck the blood of ENEMIES before they attack us.

                 

Going to Tourist Places? Then Must Read This!!!!!!!!!!!

1) Need to maintain a check list of the places you want visit by a searching internet.

2) Need to watch the videos of tourist places priorky in YOUTUBE and skip some of them if you   need.

3) Need to know the  best hotels (for having food) by enquiring autowalas/cabs.

4) Schedule  the toure timings  from 07.00 A.M To 10.00 A.M and 03.00 P.M To 05.00 P.M

5) Need to keep water bottles has many has possible Need to keep milk if there are any infants

6) DO NOT WALK IN ORDER TO SAVE MONEY WITH OUT TAKING AUTOS

7)  Prepare  the check list of train timings and bus timings of to and fro and  Go only in super fast trains and buses in order to saving time.

8)  Take a small umbrella if you are visiting the place in summer/ rain season.

9) Drink coconut water and butter milk where ever you see them.

10) Prepare a CheckList of Nearest Hospitals in case of Health Emergency.

TALEND COMPARE DATE FUNCTION EXAMPLES

1)if first one less than second one return number -1,
TalendDate.compareDate("2016-DEC-01" ,"2016-DEC-020","yyyy-MM-dd");

2)equlas return number 0,
TalendDate.compareDate("2016-DEC-01" ,"2016-DEC-01","yyyy-MM-dd");

3)bigger than return number 1. (can compare partly)
TalendDate.compareDate("2016-DEC-15" ,"2016-DEC-01","yyyy-MM-dd");

Working Code :
Var.start : TalendDate.parseDate("yyyy-MM-dd","2016-DEC-01")

Var.End : TalendDate.parseDate("yyyy-MM-dd","2016-DEC-01" )

TalendDate.compareDate(Var.start,Var.End,"yyyy-MM-dd");

COMPARE DATE () SUMMARY :

Date1 < Date2    :         Returns -1
Date1 = Date 2     :         Returns 0
Date1> Date 2    :         Returns 1