52305 Feb 2014 @ 11:50 PSTCloud ComputingReplyNo internet connection in VMWAREI had the similar issue, resolved by resetting the VM and disabling/enabling DHCP on host.
52205 Feb 2014 @ 11:45 PSTData ModelingReplyLineageETL or ETL supporting tools can provide this functionality. Have you worked with Teradata Mapping Manager?
52105 Feb 2014 @ 11:37 PSTData ModelingReplyFinancial.... LDMDo you have access to TD University?
52005 Feb 2014 @ 11:35 PSTData ModelingReplyWhat 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...
51905 Feb 2014 @ 11:31 PSTData ModelingReplyUsing a PPI column in PICan you choose a better PI [single or combination of columns] excluding timestamp column?
51805 Feb 2014 @ 11:30 PSTData ModelingReplyUsing a PPI column in PIDuplicate post. http://forums.teradata.com/forum/data-modeling/using-a-ppi-column-in-pi-0
51705 Feb 2014 @ 11:29 PSTData ModelingReplyMini Cylpack vs Cylinder migrationFor complete process checkout joedsilva's reply on following link:   http://forums.teradata.com/forum/database/difference-between-cylinder-migrate-and-cylinder-split
51605 Feb 2014 @ 11:28 PSTData ModelingReplyMini 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...
51505 Feb 2014 @ 11:18 PSTGeneralReplyCreate 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...
51405 Feb 2014 @ 11:13 PSTGeneralReplyMVC ToolCan you share your logic briefly on deciding which values will be selected for MVC?
51305 Feb 2014 @ 11:11 PSTDatabaseReplyHow to setup and run Higa macrosYou can find them at T@Ys, you need customer master number for login creation.
51205 Feb 2014 @ 11:10 PSTDatabaseReplyLarry Higa MacrosYes, T@YS works on customer number basis. And they are available there for download.
51105 Feb 2014 @ 10:58 PSTGeneralReplyAutomation of Stats CollectionYou 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.
51005 Feb 2014 @ 10:43 PSTDatabaseReplyVarchar to date conversion - interesting observation2-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.
50905 Feb 2014 @ 10:40 PSTDatabaseReplyInvalid session mode for procedure executionYes, it will work with both solutions above.
50805 Feb 2014 @ 10:37 PSTDatabaseReplyUse of NOT IN for a fact joinAm 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...
50705 Feb 2014 @ 10:34 PSTDatabaseReplyDeveloper PrivilegesAlso, backup tables dont have anything to do with collecting stats.   HTH!
50605 Feb 2014 @ 10:33 PSTDatabaseReplyDeveloper PrivilegesIdeally, 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...
50505 Feb 2014 @ 10:31 PSTDatabaseReplyExport from SQL Server to Teradata Temp tablesAlso, any specific error you are facing?
50405 Feb 2014 @ 10:30 PSTDatabaseReplyTeradata lookup reference table/dataYou 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!
50305 Feb 2014 @ 10:28 PSTDatabaseReplyExport from SQL Server to Teradata Temp tablesAny specific need of using temp table? And is it global temporary or volatile table?
50205 Feb 2014 @ 10:26 PSTDatabaseReplyHow 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...
50103 Feb 2014 @ 10:39 PSTPrivate Forum
50003 Feb 2014 @ 10:37 PSTPrivate Forum
49903 Feb 2014 @ 10:31 PSTPrivate Forum