0 - 11 of 11 tags for period

Hi,
I have the following table with columns:
id     fr_dt       to_dt      price
The idea is to find minimum price for overlapping periods and for non-overlapping periods, show the price. The final output should contain non-overlapping periods spanning from minimum of the fr_dt and maximum of to_dt.
 
e.g.

Let's create two simple tables using the same ID column, some attributes (A_CDC and B_CDC) and a date period.

Hi All,
I've a table which is being loaded through Informatica ETL tool. One column in the table is defined as PERIOD(TIMESTAMP(6) WITH TIME ZONE). There is no such datatype i found in the ETL tool. As the field is straight move from the source(flat file), I've made the datatype CHAR(72) in the ETL Tool.

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:

I want to remove periods from the concatenated string. Please help as I tried all options inlcuding Cast, Format etc.
 
My query is
SEL CONCAT(id, rec_num, line_no, dep_no, asp_num, pr_num) as mystr
from table_oemsp
 
I get the output as
mystr
0.0.300.900.0
11.20.123.123.20
etc.
 

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. 

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.

So currently I have code that gives an output of

FY08 1 N 99999999 07200880977 20060401 A 5066.00 16.66

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.

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.

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.