Sunday, October 4, 2015



Friday, September 25, 2015

SSIS Interview Questions - Basics

What is SQL Server Integration Services (SSIS)?

  • SQL Server Integration Services (SSIS) is component of SQL Server 2005 and later versions. SSIS is an enterprise scale ETL (Extraction, Transformation and Load) tool which allows you to develop data integration and workflow solutions. Apart from data integration, SSIS can be used to define workflows to automate updating multi-dimensional cubes and automating maintenance tasks for SQL Server databases.

Differentiate SSIS and DTS

  • SSIS is a successor to DTS (Data Transformation Services) and has been completely re-written from scratch to overcome the limitations of DTS which was available in SQL Server 2000 and earlier versions. A significant improvement is the segregation of the control/work flow from the data flow and the ability to use a buffer/memory oriented architecture for data flows and transformations which improve performance.

What is Control Flow?

  • When you start working with SSIS, you first create a package which is nothing but a collection of tasks or package components.  The control flow allows you to order the workflow, so you can ensure tasks/components get executed in the appropriate order.

What is Data Flow Engine?

  • The Data Flow Engine, also called the SSIS pipeline engine, is responsible for managing the flow of data from the source to the destination and performing transformations (lookups, data cleansing etc.).  Data flow uses memory oriented architecture, called buffers, during the data flow and transformations which allows it to execute extremely fast. This means the SSIS pipeline engine pulls data from the source, stores it in buffers (in-memory), does the requested transformations in the buffers and writes to the destination. The benefit is that it provides the fastest transformation as it happens in memory and we don't need to stage the data for transformations in most cases.

What is Transformation?

  •  A transformation simply means bringing in the data in a desired format. For example you are pulling data from the source and want to ensure only distinct records are written to the destination, so duplicates are  removed.  Anther example is if you have master/reference data and want to pull only related data from the source and hence you need some sort of lookup. There are around 30 transformation tasks available and this can be extended further with custom built tasks if needed.

What is Task?

  • A task is very much like a method of any programming language which represents or carries out an individual unit of work. There are broadly two categories of tasks in SSIS, Control Flow tasks and Database Maintenance tasks. All Control Flow tasks are operational in nature except Data Flow tasks. Although there are around 30 control flow tasks which you can use in your package you can also develop your own custom tasks with your choice of .NET programming language.

What is a Precedence Constraint and what types of Precedence Constraint are there?

  • SSIS allows you to place as many as tasks you want to be placed in control flow. You can connect all these tasks using connectors called Precedence Constraints. Precedence Constraints allow you to define the logical sequence of tasks in the order they should be executed. You can also specify a condition to be evaluated before the next task in the flow is executed.
  • These are the types of precedence constraints and the condition could be either a constraint, an expression or both 
    • Success (next task will be executed only when the last task completed successfully) or
    • Failure (next task will be executed only when the last task failed) or
    • Complete (next task will be executed no matter the last task was completed or failed).

What is a container and how many types of containers are there?

  • A container is a logical grouping of tasks which allows you to manage the scope of the tasks together.
  • These are the types of containers in SSIS:
    • Sequence Container - Used for grouping logically related tasks together
    • For Loop Container - Used when you want to have repeating flow in package
    • For Each Loop Container - Used for enumerating each object in a collection; for example a record set or a list of files.
  • Apart from the above mentioned containers, there is one more container called the Task Host Container which is not visible from the IDE, but every task is contained in it (the default container for all the tasks).

What are variables and what is variable scope?

  • A variable is used to store values. There are basically two types of variables, System Variable (like ErrorCode, ErrorDescription, PackageName etc) whose values you can use but cannot change and User Variable which you create, assign values and read as needed. A variable can hold a value of the data type you have chosen when you defined the variable.
  • Variables can have a different scope depending on where it was defined. For example you can have package level variables which are accessible to all the tasks in the package and there could also be container level variables which are accessible only to those tasks that are within the container.

Disclosure Policy

This policy is valid from 25 September 2015

 This blog is a personal blog written and edited by me. This blog accepts forms of cash advertising, sponsorship, paid insertions or other forms of compensation.

 This blog abides by word of mouth marketing standards. We believe in honesty of relationship, opinion and identity. The compensation received may influence the advertising content, topics or posts made in this blog. That content, advertising space or post will be clearly identified as paid or sponsored content.

 The owner(s) of this blog is compensated to provide opinion on products, services, websites and various other topics. Even though the owner(s) of this blog receives compensation for our posts or advertisements, we always give our honest opinions, findings, beliefs, or experiences on those topics or products. The views and opinions expressed on this blog are purely the bloggers' own. Any product claim, statistic, quote or other representation about a product or service should be verified with the manufacturer, provider or party in question.

 This blog does not contain any content which might present a conflict of interest.

Wednesday, July 15, 2015

Thursday, September 12, 2013



Saturday, April 27, 2013

Free TV Shows Online

Hi friends, have you ever experienced watching Live tv on internet? Yes it is now possible to watch your favorite movies and live shows online. Live Tv is the place where everyone could express the feel of doing everything live. Live Broadcasts are also given importance using which you can broadcast anything and everything that you prefer. Blog Tv lines up with a huge number of English and many other language movies and shows. The site's design is awesome.Just check into and watch TV Online. You can watch or broadcast your favorites online. It also introduces playing football online through web tv. It requires that you must be above 18. Everyone can play a live game of football through Free TV Online. Just enter, play and have a real fun playing the game online. So why do you wait for? Start gaming. Be sure not to miss the TV programmes while you are on travel.

We also should consider the fact that Television provides entertainment to everyone regardless of their age. It has its own merits and demerits. Inspite of many news channels and shows like KBC increasing our intellectual power,it offers many things that affect an individual.Whether it be Diwali,Pongal,republic day or Independence day almost every channel line up with their own series of special programmes for the whole day.It sometimes fail to make us remember the importance of the day.For example, On a Republic day, a schoolboy refuses to make his way to school for Republic day function just for the reason that he could not miss the special programme on television at that time. Is television guiding us in the right way? Coming to mega serials, some of the serials really produce a hell in all our minds. After looking into the serials, many of them even seem to induce problems in their houses. As smile is the only way to success, shows like Mr.Bean, Reach out adds to its(Tv's) credit. Television media could be improved by letting the people to know about the facts in a clear and a positive way.

Thursday, January 12, 2012

I recently got a freebie tulsa golden hurricane tickets. I was thrilled, delighted and overjoyed at the prospect. After all, it was a city where the shopaholic in me could really let go. Think about it, they had more than one mall, they had outlets like Next and the Bombay Store. I couldn't wait. Plus I had a sick friend I need to visit, but I figured that retail therapy would be the best cure for him. I got up eagerly at 6 am, something I have not done in at least the past two months - such was the anticipation of getting away from boring old Chennai even for a day. The flight was on time (I was lucky indeed!) and I arrived inBangalore at 9.30am. And then it began. has game time tickets for the Tulsa Golden Hurricane, UAB Blazers, and the UC Santa Barbara Gauchos maps and seating arrangements. I came out of the airport to find that the taxi I had booked but was nowhere in sight. He was meant to have been waiting with a sign. I would have been  more excited if it was uab blazers tickets or uc santa barbara gauchos tickets too. After frantically ringing for about half an hour, he finally answered and then ten minutes later saunters across he had met up with a friend, he saucily informs me, without so much as a smile or an apology. We then proceed to the fabled Garuda Mall, where I find my friend waiting. I also found that there is nothing in the mall that I cannot get back in Chennai. Except perhaps a smile from fellow shoppers. While wandering around I got pushed, shoved and nudged by almost everybody. I got tired of being jostled by the greatness of Bangalore, so we got out and proceeded towards a famous cosmetics store. I bought a powder, which I am told is Rs 990. But my bill arrived and it was almost Rs 1300. The store's glitzy manager looks snootily at me as she presented the bill and I humbly paid up, walked out feeling bruised and felt sorry for myself.

Tuesday, December 20, 2011

Kolaveri Di Meaning

The song is sung when a guy is dumped by a girl and been to a drunken state due to the failure. Then he sings the song Why this Kolaveri di which exactly means "Why did you do this to me" or "Why you dumped me".

Dhanush start the song with words Soup song, Flop song. The soup song is a song for those who failed in Love.

We can say the song is in Tanglish and there is no grammar in the song as well there is no sense in doing literal translation of the song. Whether you know Tamil or not, you can still understand the entire song if you know the meaning of line Why this Kolaveri Di.

Dhanush didn't write the lyrics on any paper, he just got the tune and has sung instantly.

The song is from Dhanush's wife Aishawarya's debut film Moondru (3). It is amazing to see that the song got 2.5 Million views in just 1 week. So there can be no better way to publicize the movie.

Dhanush is the singer of this song who is a National Award-winning Actor, Singer, composer and what not!!

Tuesday, December 6, 2011

Why this Kolaveri?? - Lyrics

Dhanush Rocks!!!!!!!!

yo boys i am singing song

soup song

flop song

why this kolaveri kolaveri kolaveri di

why this kolaveri kolaveri kolaveri di

rhythm correct

why this kolaveri kolaveri kolaveri di

maintain please

why this kolaveri..di

distance la moon-u moon-u

moon-u color-u white-u

white background night-u nigth-u

night-u color-u black-u

why this kolaveri kolaveri kolaveri di

why this kolaveri kolaveri kolaveri di

white skin-u girl-u girl-u

girl-u heart-u black-u

eyes-u eyes-u meet-u meet-u

my future dark

why this kolaveri kolaveri kolaveri di

why this kolaveri kolaveri kolaveri di

maama notes eduthuko

apdiye kaila snacks eduthuko

pa pa paan pa pa paan pa pa paa pa pa paan

sariya vaasi

super maama ready

ready 1 2 3 4

whaa wat a change over maama

ok maama now tune change-u

kaila glass

only english..

hand la glass

glass la scotch

eyes-u full-aa tear-u

empty life-u

girl-u come-u

life reverse gear-u

lovvu lovvu

oh my lovvu

you showed me bouv-u

cow-u cow-u holi cow-u

i want u hear now-u

god i m dying now-u

she is happy how-u

this song for soup boys-u

we dont have choice-u

why this kolaveri kolaveri kolaveri di

why this kolaveri kolaveri kolaveri di

why this kolaveri kolaveri kolaveri di

why this kolaveri kolaveri kolaveri di

Saturday, December 3, 2011

Business Web Directory

Friends, it’s been few months into blogging. Though I tend to write one post a month, I definitely know that it’s not up to the mark. Just that I got little busy with my work leaving no time to write up.  The happiest thing is that I have moved into a new project and to a team I wanted. Updating my blog was my inner voice all these days.
I eventually failed to notice my blog’s popularity over the web and its ranking and stuffs. The PR, the site traffic and the other rankings have invariantly gone down. I just surf the web the whole day today as to how to improvise my ranking and the other stuffs. Directory Submission seemed to be the top on list in order to get your site indexed. In that way, I am now ready to register my blog with some popular business listing and get listed with them. The first thing I got impressed with Jasmine web directory is that they provide the thumbnails of your site. As you might know, pictorial representation of anything would attract more people. Secondly, the search engine optimization. It is always better to be in the top of any list. Everyone of us are looking for SEO. Aren’t we? Jasmine business listing provides support for W3 css and HTML and promises us, the site owners that they are 100% SEO friendly.  As a extra feature, they also have 5 deep URL’s of our site listed. Hope to get good solutions from them.
The other things that are important for a blog to be well maintained include: Link building, Blog commenting, content writing and the traffic. The traffic will be generated only when a site is linked and listed with good web directories. So work on with the steps to get listed. Happy Blogging!

Friday, November 4, 2011

Its Winter

Hey buds, its Winter and it is definitely a chilly time of year, but it lends itself to fun. Not only are there snowballs to throw and snowmen to build, but a variety of games are available which add to the enjoyment of this time of year. Some of these are video games based around winter themes, playable online through a user's web browser. Others are physical games which will take you outside into your backyard or a nearby park.

You will need to set up a bull's eye target on the ground before you can play this snowball throwing contest. Start by arranging a circle in the snow using your boots, and then utilize food coloring in bottles to draft two, the scam are increasingly larger, rings around the central circle. You'll then need to assign a points system to the target, with each section being worth a different amount; 10, 25 and 50 points, for instance. Each player is given a bucket of snowballs and takes it in turns to chuck one of these at the target from a reasonable distance away. Assign one player to take a record of the points scored by each player each round; the game ends when one participant reaches a pre-determined number of points.

This online title is a variant on the dress up games which are a common sight across the Internet as well as The player is presented with a cartoon model and an array of clothing options, with which she can equip her subject by clicking on each clothing item and dragging it across to the model. In this particular game, the wardrobe is themed around winter clothing, with warm jackets, mittens and snug hats all available. The player can click the Tips button on-screen for hints on how to dress the model.

Tuesday, September 6, 2011

Deal with Fun

In the recent scenario, paid search confiscates too much of a website's value. Consider a site where the average order is $1,000 (quite modest) and has a conversion rate of  10%. That is, for every 100 users, the site closes one sale (either directly on the site, or indirectly after passing the lead to the sales channel). This amounts to sales of $10 per visitor. If we further assume a contribution margin of 40% after deducting COGS (cost of goods sold) and other marginal expenses, the site makes $4 per visitor. Now, experience shows that the average website can double its conversion rate by doing user testing and redesigning for increased usability. If our sample site runs a good usability project, it can therefore expect to see a conversion rate of 2%. Thus, will close two orders and make $2,000 in sales and $800 in contribution margin. As long as the competing sites stay the same, the managers of our sample site are happy: they still pay only $3.99 per click, so they pay $399 for the 100 clicks and their profit increases from $1 to $401 as a consequence of site improvements. If your search bid stays the same, your ad will sink off the page as more and more competing sites improve their design enough to afford higher bids. Our site therefore has no choice but to increase its own bid to $7.99 per click if it wants to stay in business.