Saturday, February 24, 2024

SSIS Tutorials - Merge Transformation || Merge data from two sources

In this tutorial, we will learn " How to merge data from two homogeneous or heterogeneous source" by using Merge Transformation in your SSIS Package. 
SSIS merge works similar way to a SQL join it merges the two or more different sources (Sources can be of same type or different type / heterogeneous) into a single output. SSIS is all about collecting data from different sources, If you want to merge the collected data from different sources then we can use merge component. Merge component accepts only 2 sorted (compulsory) inputs. if there is more than 2 inputs then it best to use Union All transformation component. Also Merge transformation have only 1 output and does not have any Error output.
Used Components -
1. Data Flow Task
2. Source Assistants - Flat File and SQL Server
3. Sort Transformation : To Sort the data
4. Merge Transformation : Merge the sorted inputs
5. Row Sampling: To watch the final output.

Wednesday, June 29, 2022

When you use 100% of your brain

A popular claim that humans use just 10 percent of their brains is far from accurate—but that doesn't mean we use 100 percent of them, either.

First, let me tell you what would happen if we used 80% of the brain. I suppose if we use 80% of our brains, we will be in ICU.


Why? because we use the majority of our brains throughout the day and night And when we use 80%, it means something is wrong and hence ICU.


The truth is that we do, in some ways, use our entire brain. Most people think we use our brains only in maths, physics, logical reasoning, crime mysteries, testing boyfriends, getting girlfriends, etc.


But the fact is that we use our brains for everything. For instance, for reading this answer, walking, judging the speed of a ball, using hands, sensing temperature, etc.

Permit me to elaborate. Suppose you are walking as well as talking on your phone. When the conversation turns important, you unknowingly stop walking.

Guess why? Because you are multitasking. When you stop walking, the load on your brain reduces and it can focus on the conversation that is important.

The brain is a tool, and we have the scope to use it better than we actually do. But that does mean we will start communicating with snakes, if we use our brain's full potential.

We do use the full capacity of our brains. The idea that humans only use 10% of their brains is a ridiculous myth that seems perpetually inaccessible to the light of reality.


The bottom line -  
Why is it so easy to believe these myths about the brain?

There’s a grain of truth running through some of them. Others seep into our own brains through repetition, and we fail to question their validity.  If you previously bought into some of these brain myths, take heart. You weren’t alone.

As much as scientists know about the human brain, there’s a long way to go before we come close to fully understanding the mysterious organ that makes us human.


Friday, June 7, 2019

3 reasons you are not getting HIRED

As we know that 30 years ago, a 5 to 10 minutes interview was enough to hire somebody, because hiring managers wanted to hire. Today, it takes from 3 to 6 interviews to get back not more than a negative answer through an automated email.
We have enormous flow of people who are apt with the skill-set required to perform an excellent job but not able to perform well in Interviews. Beside, they have many talents, impressive qualifications, and a positive attitude but yet they are not getting hired because there are three main reason for their failure in the interview process as given below -

3. They look for people who do well on interviews, not those who do well on the job. Under the pressure of the interview in unfamiliar settings many good people don't perform well.

2. They look for perfection that does not exist. Look for passion, talent and attitude! 

And number 1:

1. Everyone is looking for 30 year olds with 20 years of experience. 

They have some other hidden reason also -

  1. They want top talent with tons of experience but insist on paying low entry level compensation.
  2. They are deep in the hole, their projects are behinds, they used the interview questions to get the right ideas on how to go the right way on solving it!  They don't hire you because you gave them them the solution on hypothetical questions.
  3. They have reached a high turnover because the whole team left due to office politics, toxic environment, idiotic micro manager... They want a front/back kisser and submissive so they can abuse, discriminate and feed their ego to remedy their inferiority complex.
  4. Some of the company emphasis more on his/her Looks rather than a person's capability or Work Experience. They want good looking, Dynamic Personality.
Recruiters specialize in their certain industry areas, so have a good idea of the skill set available on the market at that time and also specialize in reading different peoples personalities and building relationships with people at all levels day in, day out. We know it is not always easy to find a great Recruiter, but we are out there and our job is to match the best candidates with our clients companies/teams and overall specific requirements. It is mostly that HR doesn't understand anything about technologies. Was told once that they don't want to hire people who are not currently working on the specific technology.

Tuesday, September 11, 2018

World's cities where do you want to live - Vienna, Austria

Now a days, there are many sources to guide us to choose the best cities to live which include many conditions such as best cities for retirement, best cities for young people, best cities to pursue a career, best cities for dining out, best cities for sleeping in, best big cities, best small towns, best cities for better education, health and securities.
It's very tough to decide a best city in the world to accomplish the above list. To choose a city for your family, security is the main concern for anyone. I have come across my research and find out the following cities for living -
Most liveable cities: The below top 10 cities of the year where everyone wants to live.
1. Vienna, Austria
Education: 100 Stability: 100 Healthcare: 100
Culture & Environment: 96.3 Infrastructure: 100
Overall rating: 99.1
Mercer's 20th annual Quality of Living survey announced that Vienna, Austria topped the world's most liveable city list for the ninth consecutive year. Tourism to the country has increased as a whole by nine per cent, with most tourists beelining to Vienna, the skiing city of Tirol, and of course, postcard-perfect Salzburg. 

Maybe people are drawn to the place cafe society was born; its radical modern art and architecture, or its musical culture.

Melbourne, Australia
Osaka, Japan
Calgary, Canada
Sydney, Australia
Vancouver, Canada
Toronto, Canada
Tokyo, Japan
Copenhagen, Denmark
Adelaide, Australia 

Friday, October 6, 2017

Loyalty should be rewarded, not punished

Rewarding the loyal employees should be considered as Investment for long lasting business and revenues. Loyal or not, the driving force for turning up to work every day as an employee is to “earn” a living. If this becomes diluted then so does the drive to stay loyal!. Income should always match the contribution, this is a very simple rule and has nothing to do with loyalty.
Loyalty as a word here does not suit the employees. Infact, it is the hard work and intelligence for which the employers are paid and which they deserve as well. Employers have complete rights to seek opportunities around as they will always look for the same for their career growth and new challenges. At the same time company should pay them as per their efforts and dedication. Employers get paid for their work and dedication. Their loyalty is hard work. If they are not paid well they will leave the company and the company will loose the talent. But the employee will get other opportunities because he always was working hard.
Loyalty may be subjectively seen by bosses where employees may be docile. Nevertheless (s)he may be utterly focused and result oriented. The financial success of employee can be related to  mathematical relation - Directly proportional to highlighting himself as always relevant for him and inversely proportional to time spent indicating the work goals achieved. 
Loyalty is the result of positive actions. Those who continue to be loyal in an unfair reprimand conjuncture must have low self-esteem including fear of losing their job.
There are Organisations or functions or leaders who just prefers to ignore the Long term implication of it. However, sooner or later the outcome is nothing but attrition. And then the whole cost of rehiring and reinstalling an incumbent, would cover up or probably exceed the original cost of retaining a talented employee. Not forget the viral marketing that happens from the unhappy employee for which fresh hiring might also be a challenge.
Organisation try to suck the max out of employee in the name of loyalty. The organization here value a person only if he resigns. Corporate succumbing to employee blackmail is common while caring for the deserving is rare. Trusted people sometimes cannot fetch the result. Good people never smell of the successful life. Only positive attitude people can fetch the positive results. That s power of positive attitude but it s very difficult to find out the positive attitude people. However let s be strong let s be confident let s be positive. They are the key source for upcoming planets , they created that planet so they only able to control that planet . We all should protect them , otherwise alien took over that source from us.
Absolutely an eye opening post for all those who want to take everything from their employees but not ready to give them a justifying salary that would even able to take care of their basic needs. In three years of time span I haven't come across a single Company/Entity/Organisation or a Boss who does realise how important is to satisfy employees with appropriate range of salaries because no matter what most of us are working for MONEY and it's the only motivating factor that make an individual to feel give best outcomes and increase productivity and let's do more attitude for an employer when they see their companies are taking care of them. May be there must be some out there in my Country and I'm unlucky to find one. 

Wednesday, October 4, 2017

Interview Question - What are your weaknesses?

A good interviewer will ask strong, job-related questions focused on identifying an individual’s emotional intelligence level to evaluate how the candidate will perform in the role but sometimes this type of interview questions are good and sometimes not, it can reveal genius person or idiot ones, it depends on the situation.

A very well known organization that assists with resume', interview and other coaching as part of a severance package told me that interviewers may ask 'what is your weakness', because some people actually answer the question with answers that provide immediate disqualification, such as, 'I tend to be late Mondays because I am a weekend warrior', or 'I despise coming in at the same time everyday and bosses complaining about it'. However, a good interviewer instantly spots insanity without asking about weaknesses.

If it's an employee that conforms with everything they are told to do then this hits the jackpot, especially if the candidates are readily prepared for the questions.

90% of a job is  being able to get along with everyone else; the rest (the actual job) is on-the-job-training, at least in the companies I've worked for, that's been the case. We're not numbers, we're people. Shoot,  we all have weaknesses and does anyone really know where they will be in 5 years? Heck, I could be dead in  5 years! I'd rather have conversations with people and find out if they are easy going and easy to work with; after all, people do business with people. And, are they trainable? If so, they'll probably be an awesome addition to the team.

They don't only asked such stupid questions. They also expect from profesionnals to reply like parrots! It's hilarious and humiliate, at the same time. I have a tendency to want to give smart-assed answers to stupid questions!! I often get really stupid questions or comments in my line of work because I'm a woman. They really click in the smart-ass in me which I do sometimes allow out.

It is unprofessional and irresponsible for recruiters to keep going through the same questions over and over again. It makes no significant sense. Simply hire people, train them and provide them with responsibilities, and watch your company grow. 

Tuesday, November 8, 2016

RBI to issue ₹2000 Rupees Notes coming February 2017

Indian black money
In India, Black money refers to funds earned on the black market, on which income and other taxes have not been paid. The total amount of black money deposited in foreign banks by Indians is unknown. Some reports claim a total exceeding US$50 trillion are stashed in Switzerland's. Other reports, including those reported by Swiss Bankers Association and the Government of Switzerland, claim that these reports are false and fabricated, and the total amount held in all Swiss banks by citizens of India is about US$2 billion.

Historic moment against black money in India - Just a beginning of the end of black money in India
Not just a piece of paper, there is much more in this note Read the full content of this message. A very good move by Modi government. In the sixties demonetising of 1000/5000/10000 took place.That was purely internal. Now greater problems on the rise due to forged notes of higher denominations of 500/1000 from Pakistan,Bangladesh,and Nepal. Ordinary people do not have the knowledge of differences between good notes and forged one.surgical strikes needed at this juncture to weed out forged notes.For next two or three days it is going to be a big problem for ordinary people.
"The notes of Rs 2000 and Rs 500 will be circulated soon. The RBI has decided to limit the notes with higher value," PM Modi said.

India is all set to add one more denomination to its currencies shortly. The Reserve Bank of India (RBI) will be issuing Rs 2,000 currency notes, the highest to come into circulation, even as some experts feel7 high-value denominations should be discontinued to curb black money.

The Rs 2000 currency is designed keeping in mind to eradicate the black money issues using state of the art indigenous nano technology, every Rs. 2000 currency note is embedded with a NGC (Nano GPS Chip)




Banks closed, ATMs shut. Your Rs 500 & Rs 1000 notes are invalid. 
The Prime Minister said that all the 500 and 1,000 denomination notes can be deposited in banks and post offices from November 10 till December 30.


How the embeded NGC Technology Works?

The unique feature of the NGC is it dosent need any power source. It only acts as a signal reflector. When a Satellite sends a signal requesting location the NGC reflects back the signal from the location, giving precise location coordinates, and the serial number of the currency back to the satellite, this way every NGC embedded currency can be easily tracked & located even if it is kept 120 meters below ground level. The NGC cant be tampered with or removed without damaging the currency note.

How will this help eradicate black money menace?

Since every NGC embeded currency can be tracked. The satellite can identify the exact amount of money stored at a certain location. If a relatively high concentration of currency is found a certain location for a longer period of time at suspicious locations other than banks & other financial institutions. The information will be passed on to the Income Tax Department for further investigation.
INDIA A BRIGHT SPOT IN GLOBAL ECONOMY: MODI
Modi, in his address to the nation, said India has "registered itself as a bright spot" in the global economy. In the past two-and-half-years, with the help of 125 crore people, this nation has registered itself as a bright spot in the global economy. This is a claim made not by us, but by the International Monetary Fund and the World Bank and this government is for the poor, and will remain a government of the poor."

Microsoft Business Intelligence (Data Tools)

Microsoft Business Intelligence (Data Tools)