Introduction: Informatica is a tool, supporting all the steps of Extraction, Transformation and Load process. Now a days Informatica is also being used as an Integration tool. Informatica is an easy to use tool. It has got a simple visual interface like forms in visual basic. You just need to drag and drop different objects (known as transformations) and design process flow for Data extraction transformation and load Training Features: *Mock interview sessions are conducted every week. *You can ...
Read More
EBCDIC to ASCII Recently I was given 200 EBCDIC .dat files with 5 to 500 columns and various rows per file. This data then needs to be mapped to an existing db.table.column in sql r2. I reviewed and article by http://mikedavissql.com/2011/08/31/convert-ebcdic-to-ascii-in-ssis/ which offers a solution. The problem is the time involved mapping column0 to column500 to a corresponding db.table.column in sql server r2. What I would ideally like is to use is bcp ( bcp db1.eb.h_plan_type in C:\fmt\ebci...
So today I was firing up my vm to do some work with Analysis Services Multidimensional. I booted it up, opened up SSMS, and went to connect to my AS instance. Then I received a pretty straightforward error message: Ok, I thought, no big deal. Start –> Administrative Tools –> Services, find the service and start it. After clicking Start, I then got this error message: Wait, what? Not nearly as helpful or straightforward as my last one. Well, that’s interesting. Windows cou...
Blog #1 – Non Tech – Good Customer Service is no longer enough in today’s times Having been born and raised in Orlando, Florida and going to Disney theme parks consistently throughout my childhood, I can attest that the experience is one of a kind. They’ve got the customer service formula for greatness down. I just finished reading “The Disney Way – Harnessing the Management Secrets of Disney in Your Company” by Bill Capodagli and Lynn Jackson. Within th...
Step by step instructions on using the BI Documenter commandline with the Windows Task Scheduler. Create your Solution in BI Documenter. Add all the objects from your BI Stack that you would like to be documented. Select Schedule Snapshot on the bottom right hand side on the Review Your solution screen. Select your options in the build window. I think it is good business practice to add a date to the file name. It gives you more information on when you recorded the snapshot. It’s useful if...
I started on a quest to learn more about Metadata. I did not realize that there were different types of metadata; Structural, Administrative, Guide, Technical/Business/Process and Descriptive. This quest has become quite the learning experience. The three main types of metadata are: Structural Metadata describes the physical and/or logical structure of digital resources; it expresses the intellectual boundaries of complex objects. The best example I found of this was a slide presentation with a ...
Key Performance Indicators (KPI), they are a collection of calculations associated with a measure group in a cube. Typically these calculations are a combination of Multidimensional Expressions (MDX) or calculated members. A simple KPI object is composed of: basic information, the goal, the actual value achieved, a status value, a trend value, and a folder where the KPI is viewed. They are used to determine or express the quantity of critical success factors of an organization. The KPI’s s...
For all of its life, there have always been a lot of questions circulating around about data types in SSIS. What does an int in SQL map to in SSIS? What about a varchar? nvarchar? The questions could just go on and on. But, finally, we have an answer. In the all new SSISDB in 2012, there is a table built specifically to answer all of these questions. It’s called data_type_mapping, and exists as an actual table in the internal schema in tables. It’s a pretty small table, but it’...
It is common at the end of the year to look back over the previous 12 months and think about what one has accomplished in professional and personal areas of life. We humans like to divide time up into measurable chunks and, when a new cycle starts, such as a new year, we often set goals for ourselves to accomplish before the cycle is completed. Often, we fail miserably, but sometimes we are successful. 2012 was another big year of change for me. Personally, I became the grandmother of two new gr...
I’ve been playing with data taps in SSIS 2012 lately, and they are definitely one of my favorite new features of SSIS in the 2012 release. Data taps are very similar conceptually to the Data Viewer when you’re developing an SSIS package, but the problem they’ve always had is you can’t use Data Viewers in a production package, and since they’re only around for the duration of the package run, as soon as it completes they’re gone. Previously, if you’ve had...
Holiday Greetings and Best Wishes for a New Year of Happiness in a world of peace. Christmas n NewYear Offer : Register For Free DEMO and Get More Discounts On IT( software ) Online Training. Information technology will be an employment machine, generating 5.8 million new jobs in the coming four years, according to International Data Corporation (IDC) research released. H2Kinfosys is E-Verified business based in Atlanta, Georgia , United States. H2Kinfosys, the best learning platform that provid...
I have learned something new this week. Of course I learn a lot of things but because this question has arose twice in one week I locked this in to my memory. How do I get a description of my Table or Database in the documentation of BI Documenter? This is actually achieved by going into your Management Studios and right clicking on the Database/Table you want to add a description about and click on properties. Once in the Properties, click on Extended Properties. You will see the MS_Description...
I read a book today called "The Simple Truths of Service" by Ken Blanchard and Barbara Glanz. As a support engineer at Pragmatic Works, I’m always looking for ways to add value and help clients resolve any issues they experience. At the end of the day we feel that great customer service breeds customer loyalty. So how exactly do we do that? From our support team to the owners, we try our hardest to deliver to our customers substantial quality service. We put a personal touch on everything ...
I've written a number of posts recently about the new T-SQL features. I thought it would be helpful for you to have a list with links to each one. You may also be interested in a Training on the T's webinar I did a couple of months ago where I demonstrated several of the features. Using First_Value and Last_value Percentile_Cont and Percentile_Disc Paging Percent_Rank and Cume_Dist Lag and Last Are the new T-SQL features ANSI compliant? Using the Sequence Object Enjoy!
In SSIS in SQL Server 2012, it is no longer necessary (for new installations/packages) to install a separate integration services instance onto the server. It can all be managed from within the database engine. In order to be able to utilize this feature, you’ll need to create an SSIS catalog. When you connect to the database engine instance of a SQL Server 2012 instance, the last folder before SQL Server Agent is a folder called “integration services catalogs” Right click, and...
IT to generate 5.8 million new jobs by 2013: IDC Information technology will be an employment machine, generating 5.8 million new jobs in the coming four years, according to International Data Corporation (IDC) research released. H2Kinfosys is E-Verified business based in Atlanta, Georgia , United States. H2Kinfosys, the best learning platform that provides online IT Education, Training and Assessment with ability to write real code and real life projects. H2Kinfosys has cloud test lab in which ...
Every week our students get placed in various BA jobs across the USA in different domains. Do you want to be part of that success story? Give us 80 hours of your life and we will help you win a BA job and therefore achieving success. We not only teach BA concepts, but build confidence and develop a personality that will enable you to succeed in your endeavors. We are the best BA training providers as mentioned by our past students. Check out our testimonials at http://www.kudzu.com/m/H2K-Infosys...
Today I’d like to talk to you a bit about LEFT OUTER JOINs and what to watch out for. LEFT OUTER JOIN, or LEFT JOIN as I usually type it, returns all of the qualifying rows from the table on the LEFT side of the join and any rows on the RIGHT side that match. If you continue to join to more tables on the RIGHT side, you will need to continue using LEFT JOIN. For example, if I want a list of all the customers in AdventureWorks along with their SalesOrderIDs and OrderDates for any orders the...
I’ve been blogging a lot lately about the new analytic functions introduced with SQL Server 2012. I have two more to talk about: PERCENTILE_DISC and PERCENTILE_CONT. Previously, I covered CUME_DIST and PERCENT_RANK . Those two functions give you a percent ranking compared to a series of values. The PERCENTILE_DISC and PERCENTILE_CONT functions do the opposite. Given a series of values, which value is located at a certain percent rank? The most common example would be to find the median or ...
About H2kinfosys: H2KInfosys is based in Atalnta, GA providing Instructor led face2face Live online Software Training classes for everyone from any part of the world. Course Highlights: 100% Job Oriented MICROSOFT .NET Training Instructor Led - Face2Face True Live Online class More interaction with student to faculty and student to student. Detailed presentations. Soft copy of Materiel to refer any time. Practical oriented / Job oriented Training. Practice on Software Tools & Real Time proje...
How many times have you found yourself building the same SSIS packages over and over again? This Thursday, I will be presenting a free webinar for Pragmatic Works? Free Training on the T?s. In the webinar, I will demonstrate how to use BI xPress to create reusable package templates to quickly recreate packages with very little effort. Learn how to kill redundancy. You know you want to attend. At least for Rachel?s pre-webinar trivia. Sign up HERE .
Today I got a very interesting request from the client I’ve been working with. They loved the new features of PowerView, and wanted to embed the image of their powerview report on the home page of their BI Center site. My first reaction was, this is SharePoint 2010 and PowerView came out in 2012, so no way, ain’t gonna happen. But then I thought about a few more minutes and thought, why not? All PowerView really is to SharePoint is a Silverlight plug in, so it should be doable, right...
Let me start by saying that Excel makes for a horrible source. I have used SSIS packages to loop through files many times before, but never Excel (until recently). I know what you?re thinking. ?Gee, what makes Excel files so different?? Well, you can?t just use a single variable to update the connection string for the Excel connection manager. That would be way too easy. Here are the steps I had to take to get this to work. First, of course, configure the data flow to pull from an Excel s...
The Pivot Transform is a very powerful tool but often overlooked and isn't the first thing to come to mind when you need it most. Imagine you have a table that has an employee listing for each type of phone number. For example, you have one row for business phone, personal phone, and cell phone. We want to clean this data up and put all these phone numbers in one row on with only one listing per employee. Well this is the situation I was presented with recently. The great news is with the Pivot ...
I’m very excited to announce that you can now purchase my latest release book: Knight’s Microsoft SQL Server 2012 Integration Services 24-Hour Trainer . The 24-Hour series of books offered by Wrox is a great way to get kick started into learning a new tool. Not only are the lessons very focused, making it easier to learn something new, but you also receive a DVD that accompanies the book. The DVD walks you through each of the lessons with the author showing you an example of solving ...