523 | 05 Feb 2014 @ 11:50 PST | Cloud Computing | Reply | No internet connection in VMWARE | I had the similar issue, resolved by resetting the VM and disabling/enabling DHCP on host.
|
522 | 05 Feb 2014 @ 11:45 PST | Data Modeling | Reply | Lineage | ETL or ETL supporting tools can provide this functionality. Have you worked with Teradata Mapping Manager?
|
521 | 05 Feb 2014 @ 11:37 PST | Data Modeling | Reply | Financial.... LDM | Do you have access to TD University?
|
520 | 05 Feb 2014 @ 11:35 PST | Data Modeling | Reply | What is a building block approach to building semantic data models? | It is recommended because you have better security, and can expose only what user wants .... to a multiple set of users .... like its a possibility that a user A might require 3 columns for table-A... |
519 | 05 Feb 2014 @ 11:31 PST | Data Modeling | Reply | Using a PPI column in PI | Can you choose a better PI [single or combination of columns] excluding timestamp column?
|
518 | 05 Feb 2014 @ 11:30 PST | Data Modeling | Reply | Using a PPI column in PI | Duplicate post.
http://forums.teradata.com/forum/data-modeling/using-a-ppi-column-in-pi-0
|
517 | 05 Feb 2014 @ 11:29 PST | Data Modeling | Reply | Mini Cylpack vs Cylinder migration | For complete process checkout joedsilva's reply on following link:
http://forums.teradata.com/forum/database/difference-between-cylinder-migrate-and-cylinder-split
|
516 | 05 Feb 2014 @ 11:28 PST | Data Modeling | Reply | Mini Cylpack vs Cylinder migration |
MiniCylpack - MC .... is the process used by Teradata filesystem to freeup space. It frees exactly one cylinder. It is the last step system can take in order to recover space for writing data. T... |
515 | 05 Feb 2014 @ 11:18 PST | General | Reply | Create a macro that chooses from teo different select staments depending on a given parameter. | Best options seems Stored Procedure. You can manage conditional logic very solidly in SPs. Macros doesnt support such functionality.
You can also achieve this using bteq/shell script combo... |
514 | 05 Feb 2014 @ 11:13 PST | General | Reply | MVC Tool | Can you share your logic briefly on deciding which values will be selected for MVC?
|
513 | 05 Feb 2014 @ 11:11 PST | Database | Reply | How to setup and run Higa macros | You can find them at T@Ys, you need customer master number for login creation.
|
512 | 05 Feb 2014 @ 11:10 PST | Database | Reply | Larry Higa Macros | Yes, T@YS works on customer number basis. And they are available there for download.
|
511 | 05 Feb 2014 @ 10:58 PST | General | Reply | Automation of Stats Collection | You can may be use the info in a script to generate and execute COLLECT STATS command. Or simple generate it once and schedule it .... the easy way.
|
510 | 05 Feb 2014 @ 10:43 PST | Database | Reply | Varchar to date conversion - interesting observation | 2-digit year is always tricky to handle. Causing issues with leap-year-february, or confusion between year 20** or 19**. Do check your data after insert if its correct.
|
509 | 05 Feb 2014 @ 10:40 PST | Database | Reply | Invalid session mode for procedure execution | Yes, it will work with both solutions above.
|
508 | 05 Feb 2014 @ 10:37 PST | Database | Reply | Use of NOT IN for a fact join | Am still not clear ....
if I am running for October 2013, I will compare all months of the year (till Jan 2013) one by one with October data and load record in FACT_NEW if recor... |
507 | 05 Feb 2014 @ 10:34 PST | Database | Reply | Developer Privileges | Also, backup tables dont have anything to do with collecting stats.
HTH!
|
506 | 05 Feb 2014 @ 10:33 PST | Database | Reply | Developer Privileges | Ideally, production environment shouldnt be exposed to developers. And they shouldnt be creating tables there. Collecting stats or creating indexes should be in the hands of DBA .... developers can... |
505 | 05 Feb 2014 @ 10:31 PST | Database | Reply | Export from SQL Server to Teradata Temp tables | Also, any specific error you are facing?
|
504 | 05 Feb 2014 @ 10:30 PST | Database | Reply | Teradata lookup reference table/data | You can use the patterns in the table, to generate and execute INSERTs in an SP to get only the data that qualifies your criteria. And then you can use that table for your needs.
HTH!
|
503 | 05 Feb 2014 @ 10:28 PST | Database | Reply | Export from SQL Server to Teradata Temp tables | Any specific need of using temp table? And is it global temporary or volatile table?
|
502 | 05 Feb 2014 @ 10:26 PST | Database | Reply | How do you secure sensitive data from DBAs and IT staff? | Primarily, i have seen following approaches:
- Basic one, get them sign NDA .... and enforce it
- Give access via views and encrypt data
- For selected few reports having sensitve inform... |
501 | 03 Feb 2014 @ 10:39 PST | Private Forum |
500 | 03 Feb 2014 @ 10:37 PST | Private Forum |
499 | 03 Feb 2014 @ 10:31 PST | Private Forum |