SriniTera

Technology creating jobs for new IT skills. New skills creating more job opportunities across the world. Open+Source+jobs    [Open Source Jobs] Open source experience and contributions  continue to rate highly with IT employers, especially those with significant big data and cloud initiatives on the books. Think along the lines of the aforementioned Hadoop, of course, but don’t forget about the broader ecosystem around it, which includes projects such as Cassandra, Hive, and Pig. Linux is another place to look, and the NoSQL world (see also: MongoDB) offers open source opportunities as well. SECURITY+jobs   [Security, Security, Security] Job titles range from security architect to the relatively recent executive suite addition of the CSO or CISO. There’s never been a better time to be a qualified security pro — at least from the standpoint of employability. Cyber-security was the fastest-growing skill area in terms of employer demand on tech jobs site Dice from January 2014

Secondary Indexes provide an alternate path to the data, and should be used on queries that run thousands of times. Teradata Secondary Index Teradata runs extremely well without secondary indexes, but since secondary indexes use up space and overhead, they should only be used on "KNOWN QUERIES" or queries that are run over and over again. Once you know the data warehouse, environment you can create secondary indexes to enhance its performance. Whenever a secondary index is created, Teradata creates a secondary index subtable on each AMP. All secondary index subtables contain: Secondary Index Value  Secondary Index Row ID  Primary Index Row ID Secondary indexes are two types A UNIQUE Secondary Index (USI) will improve data retrieval and can also be used to enforce uniqueness on a primary key. Typically, only two AMPs are used on a Unique Secondary Index (USI) access. A Non-Unique Secondary Index (NUSI) is AMP local and is an All AMP operation, but not a full tab

Teradata has a date function and a time function built into the database and the ability to request this data from the system. DATE was a valid data type for storing the combination of year, month and day, but TIME was not. Now, TIME and TIMESTAMP are both valid data types that can be defined and stored within a table. The Teradata RDBMS stores the date in YYYMMDD format on disk. The YYY is an offset value from the base year of 1900. The MM is the month value from 1 to 12 and the DD is the day of the month. Using this format, the database can currently work with dates beyond the year 3000. So, it appears that Teradata is Y3K compliant. Teradata always stores a date as a numeric INTEGER value. The following calculation demonstrates how Teradata converts a date to the YYYMMDD date format, for storage of January 1, 1999: The stored data for the date January 1, 1999 is converted to: YEAR: (1999-1900) * 10000 = 0990000 ->YEAR MONTH = 01*100= +0100 -> MONTH DATE=01