![]() |
Hi,
10 Sep 2015
| 1 comment
,
|
![]() |
Let's create two simple tables using the same ID column, some attributes (A_CDC and B_CDC) and a date period.
31 Oct 2014
,
|
![]() |
Hi All,
24 Jan 2014
| 5 comments
,
|
![]() |
Overview: Period Data Types and Derived Period Columns
Teradata Database supports storage and manipulations that involve durations, spans of time defined by a beginning and ending bounds:
03 Oct 2013
,
|
![]() |
I want to remove periods from the concatenated string. Please help as I tried all options inlcuding Cast, Format etc.
29 Jul 2013
| 2 comments
,
|
![]() |
My ETL team is in search of a workaround to load a period data type with INFA 9.1. We've tried casting period(current_date,until_changed) as a string and nearly every other workaround we can think of.
21 Sep 2012
| 1 comment
,
|
![]() |
The Teradata Temporal feature, available with Teradata 13.10 allows the customer to capture, track, and analyze the full history of evolving business data rather than just the most current updates.
06 Jun 2012
,
|
![]() |
So currently I have code that gives an output of FY08 1 N 99999999 07200880977 20060401 A 5066.00 16.66
20 Jul 2011
| 2 comments
,
|
![]() |
The PERIOD data type was introduced in Teradata 13.0. This follow-on article builds on the first article (Exploring Teradata 13's PERIOD Data Type) and will again make heavy use of examples, but this time we will dig into the functions that are part of this new feature set. If you have not read the first article, consider doing that now and then returning here. The examples here will use the tables introduced in the first article and add a few more.
15 Feb 2011
| 4 comments
,
|
![]() |
The PERIOD data type was introduced in Teradata 13.0. This first article will use examples to dig into the concepts that are part of this new feature. The second article will use examples to examine all the functions available in version 13.0.
16 Nov 2010
| 9 comments
,
|
![]() |
More than likely, you need to keep track of the beginning and ending of some kind of an event. Maybe you track how long employees have been with your company, how much time users spend on a particular web site, or the duration of insurance policies.
29 Apr 2009
| 2 comments
,
|