Author: Bert Swope

Infosphere Datastage – Useful Date Transformations

2015-10-26

Here are few Datastage date transformation, which I have found useful, many of these can Also be accomplished in SQL, if sourcing your data from an RDBMS. Useful Date Transformations Item Description Result Tomorrow DateFromDaysSince(1, CurrentDate())   Yesterday DateFromDaysSince(-1, CurrentDate())   Convert date to string with dashes DateToString((<< Date_Field or CurrentDate() >>,”%,”%YYYY-%MM-%DD”) 2011-11-02 Convert date … More Infosphere Datastage – Useful Date Transformations

Oracle SQL Date Formatting Examples

2015-10-26

Below is a SQL of various examples of Oracle date formats, which I have found to be a useful reference. Select SYSDATE, TO_CHAR(SYSDATE,’YYYY-MM-DD AD’) AS ANNO_DOMINI, TO_CHAR(SYSDATE,’YYYYMMDD’) AS SORT_PATTERN1, TO_CHAR(SYSDATE,’YYYY/MM/DD’) AS DATE_PATTERN1, TO_CHAR(SYSDATE,’DD/MM/YYYY’) AS DATE_PATTERN2, TO_CHAR(SYSDATE,’DD/MON/YYYY’) AS DATE_PATTERN3, TO_CHAR(SYSDATE,’DD-MON-YY’) AS DATE_PATTERN4, TO_CHAR(SYSDATE,’CC’) AS CENTURY, TO_CHAR(SYSDATE,’YYYY’) AS FOUR_DIGIT_YEAR, TO_CHAR(SYSDATE,’YY’) AS YEAR_OF_CENTURY, TO_CHAR(SYSDATE,’J’) AS JUALIAN_DATE, TO_CHAR(SYSDATE,’Q’) AS … More Oracle SQL Date Formatting Examples

InfoSphere DataStage Performance Factors

2015-10-26

It seems that the factors affecting Infosphere Datastage keep coming up, so, I thought it might be good to have an organized representation of what some of the major performance factors are and where they fit in the mix. Load Strategy Zones Source System RDBMS Indexes Partitioning Striping Parallelism Timestamps Business rules SQL Quality Architecture … More InfoSphere DataStage Performance Factors

Oracle SQL – Trimming a Specific Literal from a Field

2015-10-26

I have frequently used the trim command for one purpose or another, but I have not used it to extract a literal out of a field, which I recently used to extract invalid values from a field in SQL.  So, I am providing a sample SQL for Future reference. SQL Pattern:   Select trim (‘I’ FROM … More Oracle SQL – Trimming a Specific Literal from a Field

How to Purchase Winter Squash and Pumpkins

2015-10-25

If you’ve never heard of Kabocha, Sugar pumpkin, Sweet Dumpling, or Cushaw Green Striped, then this article is for you! These varieties are gaining popularity in the US and Canada these days. Listed below are some tips for picking the best winter squash. Try them out and see what your family and friends think! They … More How to Purchase Winter Squash and Pumpkins

Winter Squash – Thelma Sanders Acorn

2015-10-22

A productive and delicious heirloom acorn squash, which as, deeply ridged, cream-colored acorn squash.  This is also known as the Thelma Sanders Sweet Potato.   Classification Days To Maturity Fruit Size Weight Skin Color Habit Squash 85-95 6 inches ½ -1 pound Light beige to pale gold Vining Seed Depth Seeds Per group Seed Spacing … More Winter Squash – Thelma Sanders Acorn

Is the Strawberry a Fruit?

2015-10-21

Whether the Strawberry is a fruit or not depends on the definition used. The question of “Is the Strawberry a Fruit?” has prompted a series of experiments involving strawberries. Undergraduates in Edinburgh have tempted strawberries with cheese, harshly interrogated them, and even given them money to go shopping. While the results are not yet conclusive, … More Is the Strawberry a Fruit?

Origins Of Pumpkins And Winter Squash?

2015-10-21

The common species of squashes and pumpkins used by gardeners are native to the Western Hemisphere and wild varieties can occasionally be found in their native environments. C. maxima – Represented by the Hubbard, Delicious, Marblehead, Boston Marrow, and Turks Turban are varieties thought to have originated in northern Argentina, near the Andes, or in … More Origins Of Pumpkins And Winter Squash?

Can All Pumpkins and Winter Squashes Be Eaten?

2015-10-21

All pumpkins and squash commonly grown in the vegetable garden or purchased in the grocery store and/or your local farmers market may be eaten, but there is a big difference among varieties, which are typically grouped by their most common usage: Ornamental — Ornamentals are pumpkins and winter squashes which American children and patient parents … More Can All Pumpkins and Winter Squashes Be Eaten?

Netezza [HY000] ERROR: Please issue a groom on table

2015-10-20

While altering a Netezza table this error was produced: ERROR [HY000] ERROR: Please issue a groom on table ‘<<TableName>>’, maximum table versions exceeded. The error was resolved by running these commands on succession: GROOM TABLE ‘<<TableName>> VERSIONS; GROOM TABLE ‘<<TableName>> PAGES ALL; Related References Groom Table PureData System for Analytics, PureData System for Analytics 7.2.0, … More Netezza [HY000] ERROR: Please issue a groom on table

Netezza/PureData – Does a Table Truncate require a groom?

2015-10-20

I had a question today while considering the way to [potentially improve performance and stability of my ETL’s.  Basically, does Netezza need to be groomed when truncating a table as part of a destructive load strategy?  The answer is no, a Netezza table does not need to be groomed after a truncate operation—see IBM Tip … More Netezza/PureData – Does a Table Truncate require a groom?

Winter Squash – Long Island Cheese

2015-10-17

One of the oldest cultivated moschatas in the U.S.A. Medium-large size and flattened shape and smooth heavily ribbed tanned skin (suggest a wheel of cheese), having a slender woody stem, and deep orange, moderately sweet flesh. Not very prolific but one of our favorite baking varieties. Grows well in the south. Classification DaysTo Maturity Fruit … More Winter Squash – Long Island Cheese

How To Grow The Hercules Butternut Winter Squash

2015-10-17

  If you’re interested in growing winter squash, you’ve come to the right place! In this article, you’ll learn when to plant Hercules butternut winter squash and where to find the best varieties. It’s easy to grow this delicious, nutritious squash – just follow these tips and you’ll have a harvest in no time! Listed … More How To Grow The Hercules Butternut Winter Squash

Winter Squash – Green and White Striped Cushaw

2015-10-17

Also, known as the Tennessee Sweet Potato. Fruits are pear-shaped with a crookneck. Flesh is pale yellow, thick, medium coarse with the sweet Cushaw flavor. This has long been a southern favor for gardeners. The green-striped Cushaw’s large, vigorous vines are resistant to the squash vine borer, which kills other squash and pumpkin plants Classification … More Winter Squash – Green and White Striped Cushaw

How To Grow The Golden Nugget Winter Squash

2015-10-17

The Golden Nugget is a prolific bush winter squash bred to resemble a sweet potato. Its orange flesh is sweet and buttery, and the immature fruit can be cooked and stored like a summer squash. Plants can be started indoors after the last frost, or seeded directly into the field when soil temperature reaches 72degF. … More How To Grow The Golden Nugget Winter Squash

How To Grow A Boston Marrow Winter Squash

2015-10-17

f you are wondering about How To Grow Boston Marrow Winter Squashes, this article will help you. In this article, we’ll discuss when and where to plant them, and what varieties to choose. Choosing the right variety for your garden will allow you to enjoy the benefits of growing this delicious winter squash year round. … More How To Grow A Boston Marrow Winter Squash

How To Grow The Blue Hubbard Winter Squash

2015-10-17

This article will explain where to plant your Blue Hubbard winter squash. Then, learn about the varieties available and when to plant them. This article will also cover the best varieties of blue hubbard winter squash. To help you grow this delicious squash, we’ve listed some tips for growing this winter squash. Using the tips … More How To Grow The Blue Hubbard Winter Squash