Parameters are a very big key in, Infosphere Information Server (IIS), to process flexibility in sequences, DataStage jobs, and DataQuality jobs. Parameterization also helps reduce development effort, reduce the number of jobs required, and reuse of jobs, by allowing construction of multi-instance jobs, which are essentially reused code. However, sometimes when starting a project, parameters need to created and doing so from memory, doesn’t always achieve the best results. So here is a quick starter list of parameters, which seem to be commonly encountered. Hopefully, this list will aide in your parametrization efforts and setup. Type Prompt Description Example String …
Tag
Showing: 21 - 30 of 349 RESULTS
Information Technology
IT facilitates the production and distribution of digital goods and services like electronic books and video games. It plays an integral role in our daily lives as well as being a major factor for human progress.
Internet infrastructure plays a significant role in government and business operations. From neighborhood lemonade stands to the e-commerce giants like eBay, Amazon and Alibaba, IT serves as the backbone for everything.
Personas Vs. Roles – What Is The Difference?
Personas and roles are user modeling approaches that are applied in the early stages of system development or redesign. They drive the design decision and allows programmers and designers to place everyday user needs at the forefront of their system development journey in a user-centered design approach. Personas and user roles help improve the quality of user experience when working with products that require a significant amount of user interaction. But there is a distinct difference between technology personas vs. roles. What then exactly is a persona? What are user roles in system development? And, how does persona differ from …
Technical Debt
During the software engineering process, there are different issues which should be dealt with or else they will subject the project to unnecessary costs later. The technical debt perspective should be considered in each step of software development. For instance, when analyzing the cost of cloud approaches, you need to take into consideration the technical debt. You should as well factor the engineering aspect when making technical decisions such as choosing between cloud services vs. homegrown solutions. What is technical debt? Technical debt refers to the implied cost which will be incurred to do additional rework on a system after …
How to Determine the Last Run Time of a Stored Procedure in Microsoft SQL Server
Understanding when a stored procedure was last executed can be crucial for database administrators and developers. It helps in performance tuning, auditing, and troubleshooting applications. Microsoft SQL Server, one of the most popular relational database management systems, does not directly store metadata about the execution history of stored procedures. However, there are several techniques you can employ to find out when a stored procedure was last run. This article explores various methods to achieve this, ranging from simple SQL queries to more advanced monitoring techniques. Method 1: Using the SQL Server Profiler SQL Server Profiler is a powerful tool that …
How You Can Leverage Pronouns To Improve Your Blog Article SEO
Despite all the hype around search engine optimization (SEO), there are some very simple things that a writer can do while creating their blog posts which will improve their SEO and in some ways make the blog procedure read. Perhaps, the easiest way to do this is to replace pronouns with the actual name of the person object or subject being described or discussed. Instead of saying ‘it’, say car, barn, bus, or whatever ‘it’ refers to. With a little practice and some careful editing this is a simple approach which can add much SEO value to your writing. Table of Pronouns Here’s a quick list of …
Netezza: List Of Views Against A Table
I have found myself using this simple, but useful SQL time in recent weeks to research different issues and to help with impact analysis. So, I thought I would post it while I’m thinking about it. It just gives a list of views using a table, which can be handy to know. This SQL is simple and could be converted to an equi-join. I used the like statement mostly because I sometimes want to know if there are other views a similar nature in the same family (by naming convention) of tables. Select All Fields From The _V_View This is …
Netezza: How to replace or trim CHAR(0) is NULL characters in a field
Occasionally, one runs into the problem of hidden field values breaking join criteria. I have had to clean up bad archive and conversion data with hidden characters serval times over the last couple of weeks, so, I thought I might as well capture this note for future use. I tried the Replace command which is prevalent for Netezza answers to this issue on the web, but my client’s version does not support that command. So, I needed to use the Translate command instead to accomplish it. It took a couple of searches of the usual bad actors to find the …
Big Data vs. Virtualization
Globally, organizations are facing challenges emanating from data issues, including data consolidation, value, heterogeneity, and quality. At the same time, they have to deal with the aspect of Big Data. In other words, consolidating, organizing, and realizing the value of data in an organization has been a challenge over the years. To overcome these challenges, a series of strategies have been devised. For instance, organizations are actively leveraging on methods such as Data Warehouses, Data Marts, and Data Stores to meet their data assets requirements. Unfortunately, the time and resources required to deliver value using these legacy methods is a …
Major Cloud Service Models
Cloud computing enables convenient, ubiquitous, measures, and on-demand access to a shared pool of scalable and configurable resources, such as servers, applications, databases, networks, and other services. Also, these resources can be provisioned and released rapidly with minimum interaction and management from the provider. The rapidly expanding technology is rife with obscure acronyms, with major ones being SaaS, PaaS, and IaaS. These acronyms distinguish the three major cloud computing models discussed in this article. Notably, cloud computing virtually meets any imaginable IT needs in diverse ways. In effect, the cloud computing models are necessary to show the role that …
SQL Server – how to know when a stored procedure ran last
This week I needed to know if a stored procedure was running when expected during our batch. So, here is a quick couple of SQL to answer the question: When a Stored Procedure was run last This version of the SQL gives the date for the last time the Stored Procure was run: select distinct top 1 s.last_execution_time from sys.dm_exec_query_stats s cross apply sys.dm_exec_query_plan (s.plan_handle) p where object_name(p.objectid, db_id(‘<<DATABASE_NAME>>’)) = ‘<<STORED_PROCEDURE_NAME>>’ Order by s.last_execution_time desc Get a list of when Stored Procedure has been run This version of the SQL provides a list of dates of when Stored Procure has …