0 - 11 of 11 tags for period
Query Needed to find Intersection Periods with minimum price

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.

By rajneesharora80, 10 Sep 2015 | Tagged: teradata period | 1 comment
Using periods with left outer join

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

By Miklos, 31 Oct 2014 | Tagged: period left outer join p_intersect
Getting an error: "6996: Invalid conversion or assignment operation on a Period." during MLOAD

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.

By subhadip, 24 Jan 2014 | Tagged: mload 6996 Invalid conversion or assignment operation on a Period period | 5 comments
Period Data Type and Derived Period Column Scenario

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:

By info-eng-team-td, 03 Oct 2013 | Tagged: scenario period data type period derived period v_database
Remove of Period '.' from my concatnated string.

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.
 

By ikonofamerica, 29 Jul 2013 | Tagged: concat format period string SPECIAL CHARACTER | 2 comments
Loading TD 13.10 Period Datatype with Informatica 9.1 workaround

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. 

By VandeBergB, 21 Sep 2012 | Tagged: period informactica td1310 | 1 comment
Teradata Temporal - Implementation Best Practices

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.

By DebraH, 06 Jun 2012 | Tagged: database temporal period geospatial timestamp time series
Split a row into two

So currently I have code that gives an output of

FY08 1 N 99999999 07200880977 20060401 A 5066.00 16.66

By RandomGuy234, 20 Jul 2011 | Tagged: period row split split bucket | 2 comments
Exploring Teradata 13's PERIOD Functions

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.

By RobG, 15 Feb 2011 | Tagged: temporal period sql dates programming functions v_database | 4 comments
Exploring Teradata 13's PERIOD Data Type

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.

By RobG, 16 Nov 2010 | Tagged: temporal period sql dates programming v_database | 9 comments
What’s a Period Data Type and Why do I Care?

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.

By dmoore, 29 Apr 2009 | Tagged: temporal period data types v_database | 2 comments