#DateForumTypeThreadPost
2007 Jul 2016 @ 11:04 PDTDatabaseTopicAny dynamic lookup concept in teradata?Hi all, Was wondering if there is anything like dynamic lookup concept where duplicates from source can be prevented from loading into target table? Source table col1 | col2 | col3 | col4 | col5...
1928 Jun 2016 @ 07:30 PDTDatabaseTopicTransaction control in BTEQ scriptHi all, I am coding for SCD (Slowly changing Dimension) 2 in BTEQ script. What should be ideal code to avoid mess up of data considering SCD-2? As of now, if there is an error we quit but is ther...
1802 Sep 2013 @ 12:52 PDTDatabaseReplyVMWare Teradata 14.00 - Error while loading data into tableThanks. Now the problem got resolved. No change in host file is required if running from within vmware. I missed out the -h parameter while invoking the tdload command. The tdload command is ...
1702 Sep 2013 @ 07:16 PDTDatabaseReplyVMWare Teradata 14.00 - Error while loading data into tableHello, I am running this command from inside the VMWare. 
1602 Sep 2013 @ 04:54 PDTDatabaseTopicVMWare Teradata 14.00 - Error while loading data into tableI am using VMWare Teradata 14.00 - 4 GB to test out certain functionality. While loading a file into a database table, i am getting following error.   TPT_INFRA: TPT05004: CLI error 224 ...
1502 Sep 2013 @ 03:33 PDTDatabaseReplyWhich column should i select for Index creationSeems the counts are not readable. Following should be helpful.   Amp # 0 col1: 58 col2: 54 col3: 47 col4: 50   Amp # 1 col1: 43 col2: 47 col3: 54...
1402 Sep 2013 @ 03:31 PDTDatabaseReplyWhich column should i select for Index creationI have 2 amps and have a table of 4 columns col1,col2,col3 and col4. Following is the ouput of hashamp query. As can  be seen except col1, other columns distribute row across amps appropriate...
1324 Aug 2013 @ 12:35 PDTDatabaseTopicWhich column should i select for Index creationHi All, I have data in an csv file and I am planning to create an table in Teradata and insert these records. I then need to create an PI after the analyzing the data properties. I somehow need ...
1212 Jul 2013 @ 02:01 PDTDatabaseTopicPDO is not possible with Teradata 12 and Informatica 9.5.1I recently came across a discussion which was debating that PDO is not possible with Teradata 12 and Informatica 9.5.1. I tried looking for answers but could not find a convincing one. Any id...
1106 Jun 2013 @ 01:36 PDTDatabaseReplyNeed more information about the temporary data retrival of TERADATA viewsTemp space is primarily used by temporary tables which have a persistent definition in the Data Dictionary but within a given session. Once the session is over, they are discarded. Now coming to y...
1006 Mar 2013 @ 01:30 PSTDatabaseTopicCalculating Access Demographic for Primary IndexHello Friends, 1) Access Demographics: Is there a formula to calculated access demographic for a primary index in Teradata? For secondary index, the following formula is often used. Access Rati...
924 Feb 2013 @ 09:17 PSTDatabaseReplyHow to validate whether my PI selection is right?Friends, Continuing on the above.. We have the concepts of foreign keys (either Soft RI or hard RI). It is oftne recommended to go for soft RI since it wont hard stop any insertion of records as ...
823 Feb 2013 @ 12:30 PSTDatabaseReplyHow to validate whether my PI selection is right?Thanks Blaine and Wasif for wonderful replies. Blaine, your reply was surely very insightful and would help me a lot.  
722 Feb 2013 @ 11:20 PSTDatabaseTopicHow to validate whether my PI selection is right?Friends, I have defined a PI for an table. Now I need to validate whether the columns selected for PI are the right candidate. What are the ways to go for it? How can I showcase whether all the A...
614 Feb 2013 @ 09:03 PSTDatabaseTopicBoils down to the difference between user and databaseHello, I have set of tables defined in Teradata and need those to be imported into Informatica ETL tool. I setup the connections using user id and pwd (different from database name) and connect. I...
511 Feb 2013 @ 11:35 PSTDatabaseReplyMoving window functionThanks Dieter, this is very helpful. Not only the code is efficient, it is short and well written.
410 Feb 2013 @ 09:23 PSTDatabaseTopicMoving window function  This query is regarding moving window function.   What to implement? : I need to have next row start date as current row end date in a teradata table. Following are the impo...
330 Jan 2013 @ 11:51 PSTGeneralTopicHow to check which data has an errorI am using Fast load script to load close to 7 million records into a Teradata table. Around 1k records are getting into error table (err1). I am not able to figure out which record has erroneous v...
223 Jan 2013 @ 06:41 PSTDatabaseTopicunable to run query in Teradata Studio Express while being used in VMware player  This is regarding Teradata Studio Express being used in VMware player.   I am trying to execute a query but unable to do so. Instead, i am facing following issue.  ...
115 Dec 2009 @ 06:48 PSTUDAReplycreating stored proceduresChild user does not necessarily inherit all the rights and privileges of the parent user. In other words, inspite of your user being under DBC user, you need to explicitly provide appropriate right...