Datastage String Functions

Function Usage
AlNum Cab be used to check if the given string has alphanumeric characters
Alpha TRUE if string is completely alphabetic
CompactWhiteSpace all consective whitespace will be reduced to single space
Compare Compares two strings for sort
ComparNoCase Compare two strings irrespective of Case in-sensitiveness
ComparNum Compare the first n characters of the two strings
CompareNumNoCase Compare first n characters of the two strings irrespective of case in-sensitiveness
Convert Replace character in a string with the given character.
Count Count number of times a given substring occurs in a string
Dcount Returns count of delimited fields in a string
DownCase Change all uppercase letters in a string to lowercase
DQuote Enclose a string in double quotation marks
Field Return 1 or more delimited substrings
Index Find starting character position of substring
Left Finds leftmost n characters of string
Len Length of the string or total number of characters in a string
Num Return 1 if string can be converted to a number
PadString Return the string padded with the optional pad character and optional
length
Right Finds Rightmost n characters of string
Soundex Returns a string which identifies a set of words that are
phonetically similar
Space Return a string of N space characters
Squote Covers a string into single quotation marks
Str Repeat a string
StripWhiteSpace Return the string after removing all whitespace
Trim Remove all leading and trailing spaces and tabs. Also reduce the internal occurrences of spaces and tabs into one.
TrimB Remove all trailing spaces and tabs
TrimF Remove all leading spaces and tabs
Trim Returns a string with leading and trailing whitespace removed
Upcase Change all lowercase letters in a string to uppercase

Datastage Architecture

Datastage needs to be installed on a server. Most servers supported by IIS are based on Windows/Unix/Linux/AIX operating systems. Datastage Clients would be installed on the users workstations/laptops. Users would include Developers, testers, business analyst, operations team member (like production support).

Client Components are explained here. http://datastageetlexpert.blogspot.com/2012/06/client-components-in-datastage-75.html

What is BI/Business Intelligence?

Business intelligence (BI) is a broad category of application programs and technologies for gathering,
storing, analyzing, and providing access to data to help enterprise users make better business decisions. BI
applications include the activities of decision support, query and reporting, online analytical processing
(OLAP), statistical analysis, forecasting, and data mining.
Examples : BusinessObjects http://www.businessobjects.com/

What is ETL

Extract -> Transform -> Load

A process of gathering, converting and storing data, often from many locations. The data is often converted from one format to another in the process.

Examples: IBM Datastage, Informatica

Data Warehousing

A data warehouse is a collection of data gathered and organized so that it can easily by analyzed, extracted, synthesized, and otherwise be used for the purposes of further understanding the data. It may be contrasted with data that is gathered to meet immediate business objectives such as order and payment transactions, although this data would also usually become part of a data warehouse.