171 | 10 Nov 2013 @ 10:15 PST | Analytics | Topic | Surrogate 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... |
170 | 10 Nov 2013 @ 09:59 PST | Data Modeling | Topic | Calendar dimension | Hi,
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( ... |
169 | 10 Nov 2013 @ 09:51 PST | General | Topic | TD Mapping manager | Hi,
Is Teradata Mapping manager working well with Erwin and does it save cost?
Thanks and regards,
Raja |
168 | 10 Nov 2013 @ 09:50 PST | Database | Reply | Move column data as rows | You 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... |
167 | 08 Nov 2013 @ 09:08 PST | Database | Reply | Dynamic Table Names | Hi Lam,
I suggest you read Teradata material on partition and see how it suits your requirements. It is easy.
Cheers,
Raja
|
166 | 08 Nov 2013 @ 09:01 PST | Third Party Software | Reply | Scheduling 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... |
165 | 08 Nov 2013 @ 08:44 PST | Database | Reply | Joining tables from two different servers | Hi,
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... |
164 | 07 Nov 2013 @ 10:54 PST | Tools | Reply | SQL 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
|
163 | 07 Nov 2013 @ 10:34 PST | Aster | Topic | Hadoop Ecosystem | Hi,
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... |
162 | 07 Nov 2013 @ 08:53 PST | Teradata Applications | Reply | ProductJoin 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... |
161 | 07 Nov 2013 @ 03:44 PST | Database | Reply | Algorithm 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... |
160 | 07 Nov 2013 @ 03:30 PST | General | Reply | Need equivalent table for dbc.qrylog in Oracle,SQL server,DB2 environment | Hi 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... |
159 | 07 Nov 2013 @ 02:35 PST | Database | Reply | Throughput | I feel c and b.
Cheers,
Raja
|
158 | 07 Nov 2013 @ 02:28 PST | UDA | Topic | Relay Services Gateway | Hi,
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
|
157 | 07 Nov 2013 @ 02:04 PST | Data Modeling | Reply | Understanding 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... |
156 | 06 Nov 2013 @ 11:57 PST | Viewpoint | Reply | Queries used by Data Collectors | Hi,
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
|
155 | 06 Nov 2013 @ 11:10 PST | Data Modeling | Reply | PPI 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 ... |
154 | 06 Nov 2013 @ 10:40 PST | Database | Reply | Dynamic 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... |
153 | 05 Nov 2013 @ 12:08 PST | UDA | Topic | Logical Clustering of amps | Hi,
Is logical clustering of amps done by DBA or TD personnel?
Thanks and regards,
Raja
|
152 | 05 Nov 2013 @ 12:02 PST | UDA | Topic | Hot Standby Nodes | Hi,
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
|
151 | 04 Nov 2013 @ 10:53 PST | Data Modeling | Reply | PPI 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... |
150 | 04 Nov 2013 @ 08:37 PST | Data Modeling | Reply | PPI 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
|
149 | 04 Nov 2013 @ 03:50 PST | Data Modeling | Topic | PPI 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
|
148 | 03 Nov 2013 @ 11:27 PST | Jobs | Reply | what 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... |
147 | 03 Nov 2013 @ 10:50 PST | UDA | Topic | Appliance 2690 | DW appliance 2690 has 8 nodes per cabinet. Does it mean we can put all in the same clique?
Thanks and regards,
Raja
|