Friday, May 18, 2018

Good Old Days

Thinking about the days I started my blog. oh yeah! its been almost 12 years now. Had a great time blogging my views about the society, the social happenings, my friends and lot more. Hope to start writing again with good content. Days have changed, over a decade, the internet has become a necessaity in everyone's life. With costliest gadgets in hand, people have become more inclined to use internet. 

Tuesday, February 7, 2017

CHENNAI

#Chennai seem to be a better city over the past decade. Chennai has renovated both international and domestic terminals and the airport has now become a central hub in India. With lots of improvements with regards to roadways, flyovers, foot over bridges, Chennai looks awesome. Despite being hit by #Vardha cyclone in 2016, the city looks Green and the entire credit goes to those people who have an intent to plant trees. The number of shopping malls, the big restaurants, good acoustic cinema halls are attracting tourists every now and then. The demonetization has greatly affected every vendor and the public over the last 3 months and it has now been driven into a good shape. with #ProtestForJallikattu, Chennai's #Marina has seen the largest crowd ever and the protest made Jallikattu happen. I personally feel proud being a Chennaite. More about Chennai in my next post!

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.

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 Spreety.com 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.

Good Old Days

Thinking about the days I started my blog. oh yeah! its been almost 12 years now. Had a great time blogging my views about the society, the...