Tags for data
Pivot based on date
Good day all, I have data that consists of 3 months of charges for each line item. Bill_No                Bill_Month                     Charge 00121       4/10/2015 12:00:00 AM           1300.00 00121       5/10/2015 12:00:00 AM           1300.00 00121      6/10/2015 12:00:00 AM            1400.00  
sql pivot data date
Dependancies on DBC for Data Processing
Hi guys, I would like to understand peoples views on utilising DBC for dynamically generating scripts for data processing. Considering DBC is Teradata's own metadata store and the development of this is owned and managed by Teradata do you feel it appropriate to develop frameworks for processing data based upon this?
dbc tpt data Processing etl elt analytics active data warehouse business rules; business modeling; data warehouse planning; business objectives
Load data into Teradata from SQL Server
Hi gurus, I have an application where i have to download data from Teradata into SQL Server, update data in SQL Server and push it back to Teradata server. I am able to import data from Teradata into SQL server using SQL Bulk Copy. I am trying to see how to push data to Teradata.
teradata sql server push data bulk copy
BTEQ or Fast Load or Multi Load
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
teradata dml bteq update insert mload fast load delete row column file data staging table upsert header
creation and usage of custom Postgres DB Table for data storage, from a Portlet.
Hi Guys, Our portlet has to store a considerably large amount of data. Is there a way to "create" a custom table in the Postgres SQL DB for storing this Data. And afterwards be able to query this table and also do inserts and updates?
portlet insert table data select postgres sql