118 | 11 Apr 2012 @ 02:29 PDT | General | Topic | Tracking Database Change Requests |
Has anyone found a tool or product that has assisted them in managing change requests and details for changes to data models, database structures, and/or ETL code for their Teradata Data Warehou... |
117 | 09 Sep 2011 @ 08:06 PDT | Tools | Reply | Teradata SQL Assistant JAVA not seeing ODBC connections | I don't think the Java Edition uses ODBC connections. It uses JDBC connections. I believe there are some embedded drivers but you can also reference the external JDBC drivers as well. Under the ... |
116 | 08 Sep 2011 @ 09:51 PDT | Tools | Reply | FastLoad Loop Through Multiple Files for Single Table | Q hit the nail on the head with his answer. TPT is perfect for this kind of thing.
Another option would be to use some kind of script wrapper (Windows Batch/*nix shell) that could accept the li... |
115 | 06 Sep 2011 @ 09:55 PDT | Database | Reply | Timestamp Datatype | My understanding is the value in the (..) is basically the number of digits for fractions of a second that you want to store. So Timestamp(0) is accurate to the second, Timestamp(1) is accurate to... |
114 | 01 Sep 2011 @ 02:29 PDT | Database | Reply | Difference between 2 queries | Well, first you're missing a ")" in the first query. Before the last group by.
But to your original question, it appears that the two should return the same result set, although with vastly d... |
113 | 01 Sep 2011 @ 09:57 PDT | Database | Reply | how to hashing primary index value | This is done automatically. You define a primary index as a set of columns and then when new data is loaded, Teradata will take the values in those columns, apply a hashing algorithm to them, and ... |
112 | 01 Sep 2011 @ 09:53 PDT | Database | Reply | Table Growth using dictionary tables | If you have PDCR implemented, you can look in those tables. It will capture your history of table space as it changes daily and from there you can calculate your growth rate. |
111 | 31 Aug 2011 @ 11:33 PDT | General | Reply | Modelling Hierarchies with dynamic levels | We load it using BTEQ and recursive SQL. Our hierarchies aren't that large so it wasn't a performance issue. |
110 | 29 Aug 2011 @ 12:54 PDT | Database | Reply | How to limit the number of rows returned | You should be able to do what you're asking in Java, not in SQL. There are several parameters on your statement, resultset, or connection that can be defined in JDBC to control how many records ar... |
109 | 29 Aug 2011 @ 08:39 PDT | General | Reply | Modelling Hierarchies with dynamic levels | One technique I've used involves something called a "bridge" table. Essentially, we load a dimension table with all of the parent or child objects in the hierarchy. Then, we build this bridge tab... |
108 | 29 Aug 2011 @ 07:58 PDT | Database | Reply | Preferred approach to application installation | I'd suggest looking at using ant to execute these. There's a nice article on here somewhere that suggests how you would use ant to automate database tasks. It would allow you to define multiple s... |
107 | 25 Aug 2011 @ 10:58 PDT | Database | Reply | Handling missing dates | For that, you'll need a list of all of the departments.
Do you have a department table? If so, you can include that in as an outer join as well. It will function similarly to the calendar join... |
106 | 24 Aug 2011 @ 07:55 PDT | Database | Reply | Teradata Foreign Key side effects | This is a table for tracking foreign key violations. It exists because you defined "Hard RI", or database-enforced RI. Using Soft RI (WITH NO CHECK OPTION) in your FK declaration will inform the ... |
105 | 23 Aug 2011 @ 03:05 PDT | Database | Reply | Table or view that contains the NumberOfRows & NumberOfColumns? | Column information is stored in DBC.Columns. SELECT DatabaseName, TableName, COUNT(*) AS NumberOfColumns FROM DBC.Columns GROUP BY 1,2; will give you the NumberofColumns. DBC doesn't store row co... |
104 | 12 Aug 2011 @ 09:27 PDT | Database | Reply | Issue when exporting data to Excel using Bteq | This may just be a display issue in Excel. Try playing with the format of that column and change it to Text or something other than numeric. This should force them to display the leading zeroes. ... |
103 | 11 Aug 2011 @ 09:50 PDT | Viewpoint | Topic | Multiple Portlet Installations | We only have a single Viewpoint system and I've had less than stellar success getting the PDK sample Viewpoint instance up and running and I need the ability to test changes to an existing in-use p... |
102 | 03 Aug 2011 @ 02:44 PDT | Database | Reply | UDF's for column security | Something like this.
REPLACE VIEW DB.MaskView
AS LOCKING ROW FOR ACCESS
SELECT
Column1
,Column2
,CASE WHEN USER IN ('User1','User2') THEN '*********' ELSE Column3 END AS MaskedColumn
FRO... |
101 | 03 Aug 2011 @ 08:56 PDT | Database | Reply | Data Cleansing using SQL | Restore from backup? Unfortunately, I'm not sure there is a good option here. What column(s) make up your primary key of this table? Is there a process that introduces this kind of error? Can y... |
100 | 02 Aug 2011 @ 07:47 PDT | Tools | Reply | Performance Tuning | What error are you getting exactly? In general you should collect statistics on columns used in joins and WHERE clauses. |
99 | 28 Jul 2011 @ 08:19 PDT | UDA | Reply | Key Level Duplicates | OK. I think I understand better what's going on now. You just want to get the first occurance (for some definition of first) for each key value pair, regardless of how many rows have that key.
... |
98 | 25 Jul 2011 @ 01:03 PDT | Database | Reply | How to import data from Oracle using SQL Assistant | Your input needs to be a file and it needs to be some form of delimited. In the SQLA options, you can specify the delimiting character. I think the default is | but I could be wrong. Once you've... |
97 | 25 Jul 2011 @ 09:53 PDT | Database | Reply | Calling Only Closed Records | I'm not terribly familiar with the temporal keywords. I've only experimented with them a little, but couldn't you do basically what you describe in the last sentence? Could you construct a query ... |
96 | 25 Jul 2011 @ 09:49 PDT | Database | Reply | Compare database between prod and dev | Well, AtanaSuite has a tool called the Delta Tool that does exactly this. You point it to the source (reference) and target (comparison) systems, specify the database(s) you want to compare and ch... |
95 | 22 Jul 2011 @ 09:51 PDT | Connectivity | Reply | identify which jobs make a connection to a specific Database source | You have to enable DBQL Object Logging in Teradata. Work with your DBAs to get that done. |
94 | 22 Jul 2011 @ 08:00 PDT | Database | Reply | Query on Collect stats | First, I'm guessing that's a typo in your query and the last line should read and T1.Col2 = T2.Col2; ;)
Carrie Ballinger has some good blog posts on this site about statistics and multi-column ... |