June 20, 2012 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 optionallength Right Finds Rightmost n characters of string Soundex Returns a string which identifies a set of words that arephonetically 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
June 6, 2012 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
June 6, 2012 Client components in Datastage 7.5 1) Datastage Designer 2) Datastage Director 3) Datastage Manager 4) Datastage Admin
June 5, 2012 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. BIapplications 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/
June 5, 2012 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
June 5, 2012 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.