#DateForumTypeThreadPost
17110 Nov 2013 @ 10:15 PSTAnalyticsTopicSurrogate key when need Hi,   I feel that if I need ;a surrogate key, I can generate from my query itself, even though if my edw is fed from heteregeneous sources, I can identify my sources with constant c...
17010 Nov 2013 @ 09:59 PSTData ModelingTopicCalendar dimensionHi, Does anybody have calendar dimension design and scripts. If it is big, can you please mail to my id ktraj1@gmail.com? I want to have holiday, weekend,  and more indicators country( ...
16910 Nov 2013 @ 09:51 PSTGeneralTopicTD Mapping managerHi, Is Teradata Mapping manager working well with Erwin and does it save cost? Thanks and regards, Raja
16810 Nov 2013 @ 09:50 PSTDatabaseReplyMove column data as rowsYou select a field from the table union all with the second field and union all with the third field. You can convert the data type to the same for all. You can select distinct for the one you want...
16708 Nov 2013 @ 09:08 PSTDatabaseReplyDynamic Table NamesHi Lam, I suggest you read Teradata material on partition and see how it suits your requirements. It is easy. Cheers, Raja    
16608 Nov 2013 @ 09:01 PSTThird Party SoftwareReplyScheduling stored procedures/SQL My way of solving this is have a master stored procecdure. Inside this stored procedure, you can  call other stored procs and queries.Each and every step I make sure that I have variabl...
16508 Nov 2013 @ 08:44 PSTDatabaseReplyJoining tables from two different serversHi, You  can fastexport the data from source and then fload into your target. Also you can ask your DBA to do this task. There are other ways to do but these are common and simple ones for on...
16407 Nov 2013 @ 10:54 PSTToolsReplySQL Assistant upgrade causing heartburn!Hi, I am just curious and  thinking that people are using Teradata studio instead of SQL Assistant or is it more handy to use the same tool? Thanks and regards, Raja
16307 Nov 2013 @ 10:34 PSTAsterTopicHadoop EcosystemHi, Do you suggest for data storage and data processing to be done in Hadoop Ecosystem and from there load to edw or what is a better option? Data maybe from Cloudstore, NFS with MapR, S3 o...
16207 Nov 2013 @ 08:53 PSTTeradata ApplicationsReplyProductJoin join condition of ("LOGGING_KEY = ETL_TEMP_HIX_DEV.TABLE4.LOGGING_KEY" Hi,   Is it possible for you to share the explain and masking the db objects.It is all upto the optimizer to think. However, some remedial ways can be found to make it faster. It de...
16107 Nov 2013 @ 03:44 PSTDatabaseReplyAlgorithm and sql ways for Sorting and matching data Hi, Your problem seems weird. When I see at P2, I can see Es1 two times. Maybe you can explain  more about the problems till the end and what are those conditions.   &n...
16007 Nov 2013 @ 03:30 PSTGeneralReplyNeed equivalent table for dbc.qrylog in Oracle,SQL server,DB2 environmentHi Priti, From Teradata as you know these tables are there and you can chose what you want.   DBC.ResUsageScpu -----For CPU per node DBC.ResUsageSPdsk------disk level data DBC.ResUsage...
15907 Nov 2013 @ 02:35 PSTDatabaseReplyThroughputI feel c and b. Cheers, Raja
15807 Nov 2013 @ 02:28 PSTUDATopicRelay Services GatewayHi, Is Relay Services Gateway coming along with AEDW or all do we need to have when we have Teradata unity or MDS? Thanks and regards, Raja
15707 Nov 2013 @ 02:04 PSTData ModelingReplyUnderstanding on Data modeling concepts I do care very much for novice. For modeling, you can start with why,what,when,how, which and all possible questions to yourself because we leave out what we require always :)? Usually it is bus...
15606 Nov 2013 @ 11:57 PSTViewpointReplyQueries used by Data CollectorsHi, I think you can have a look at populating QCD tables and look further ahead. If this is what you require, I can help you. Cheers, Raja
15506 Nov 2013 @ 11:10 PSTData ModelingReplyPPI table having a column for same PI and SI Hi, It makes sense also for some business cases to have this feature (PPI+PI+SI) To be very honest, I find that it is always a  learning. Dieter is always a man. I dont know elsewhere was a ...
15406 Nov 2013 @ 10:40 PSTDatabaseReplyDynamic Table Names Hi, Run in a bteq with your script in a run file. Get the date from any where like dictionary table concatenate with your creation script .  use run file. Hope this clue is enou...
15305 Nov 2013 @ 12:08 PSTUDATopicLogical Clustering of ampsHi, Is logical clustering of amps done by DBA or TD personnel? Thanks and regards, Raja
15205 Nov 2013 @ 12:02 PSTUDATopicHot Standby NodesHi, I am always looking for opportunities to sell ideas and solutions. Can I give suggestion to the client to put Hot standby nodes for DM appliance or DW appliance? Thanks and regards, Raja
15104 Nov 2013 @ 10:53 PSTData ModelingReplyPPI table having a column for same PI and SI Hi Dieter, Thanks a lot. Yes , I did mention about partition in my original posting "  My date range partition for now" . So I will go ahead with my thought. Thanks and r...
15004 Nov 2013 @ 08:37 PSTData ModelingReplyPPI table having a column for same PI and SI Hi, Of course, I mean NUPI and USI. I think from the standpoint of distribution and demography cases. Thanks and regards, Raja
14904 Nov 2013 @ 03:50 PSTData ModelingTopicPPI table having a column for same PI and SI Hi,   Please suggest this design if I define PI and USI for the same column. My date range partition for now.   Thanks and regards, Raja
14803 Nov 2013 @ 11:27 PSTJobsReplywhat about the oppurtunities to fresher who learn teradata?Hi RajaReddy, You have lots of opportunities. Understand basics and lots of documents to learn. Teradata is a vast ocean. I believe in self-learning as it motivates me to be self-starter else we e...
14703 Nov 2013 @ 10:50 PSTUDATopicAppliance 2690 DW appliance 2690 has 8 nodes per cabinet. Does it mean we can put all in the same clique?   Thanks and regards, Raja

Pages