0 - 5 of 5 tags for dml

The presentation is to acquaint business users with Structured Query Language (SQL) and some interesting techniques to access their data with examples for using CASE; Subqueries and Correlated Subqueries; Types of SQL joins and how they are implemented on Teradata; facts about NULLs; Derived Table usage and other interesting optimizer information.

Hi everyone! I am currently studying Teradata and currently working on this problem of mine. You see, i have this set of data on a flat file that needs to be loaded in a table based on a condition.

This is what my flat file looks like:

##Flatfile
SOR|03/17/2012|2 -- This is a header

Hello,

hi

can anyone help me about how to learn and practice teradata......
i am a beginner....and also provide the h/w and s/w requiremnts for using teradata.....
hyperlinks for practicsing teradata are also welcomed.....
plzzzzz.....help me on this regard.....

thanks in advance....
kundan

Teradata XML Services provide assistance in database transformation of XML structures to and from relational structures. This is primarily an enterprise fit feature. XML in this context is regarded as a data format that is used to describe incoming or outgoing warehouse data. A key concept for this feature is that we are not transforming to store XML but rather to maintain a relational data model or to integrate relational data into an enterprise XML message structure! The relational data model is bested suited for enterprise analytics. XML structures are best suited for enterprise integration.