Difference in datetime fields in Teradata

Recently I came across a need where I had to quickly find the execution times based start_date_time and end_date_time fields and check where my job stream taking longer time to answer one of the question of my manager.. I hope this might help few others if you are in need and new to Teradata.

Select

(Job_End_date_time - Job_Start_date_time day(4) to minute) as Execution_time, Job_start_date_time, Job_End_date_time, Job_Name from <ETLJOBRUNTABLENAME>where Job_start_date_time >='2012-03-13 00:03:35' -- The time you want to filter outAnd Job_start_date_time <='2012-03-13 23:59:20' -- The time you want to filter outorder by Execution_time Desc
Results would look like:
Execution_time,Job_start_date_time, Job_End_date_time, Job_Name
    0 00:06 3/13/2012 23:48:08 3/13/2012 23:54:06 J_XYZ

Interpreation: 0 days  0 hours 6 minutes is the execution time ot Turnaround time

select ( cast ('2012-03-13 00:03:35' as timestamp(0)) - cast ('2012-03-10 00:03:35' as timestamp(0)) day(4) to minute) as Execution_time
Results would look like:
 Execution_time
1     3 00:00

Can any one compare Informatica vs DMExpress in detail?

Here is a link that has nice article about the DMExpress capabilities.

http://www.businesscomputingworld.co.uk/syncsort-is-fast-really-fast/

Please share any comparative information that you have.

Cheers..

DMExpress Basics - Part1

Hi Friendz,

Recently I got a chance to work on DMExpress a Syncsort ETL tool. I would like to share few basics and as well as to see your inputs/experiences with this tool.

I would like to relate this ETL tool with Informatica ETL tool as I worked on this too. I would appreciate if you can do the same.

Types of tasks I worked with so far:

Copy Task - This is very similar to Expression Transformation in Informatica with which you can simply extract the data from a FlatFile/Relational..etc sources and load it into a target OR any intermediate file proprietary format of DMExoress. The same can be used to perform further transformations (like filter,aggregator..etc)  before loading into target.
It has many built in functions to perform calucalations/conversions..etc.

I will continue adding more details to this. And I welcome you all to share your experience/questions if any to help DMExpress user community.

Thanks,
Naresh