#DateForumTypeThreadPost
49616 Jan 2014 @ 03:06 PSTTeradata ApplicationsTopicUnity Source Link   DBCForeign.CreateLink!!!! will it accept to all DBs and even HIVE, HBASE, SQOOP etc?   Thanks and regards, Raja
49516 Jan 2014 @ 01:36 PSTDatabaseReplyHow to use regex in Teradata or 'LIKE' operator in teradataOops, I did not test it for data like '1a1'. Thanks ,
49416 Jan 2014 @ 12:31 PSTGeneralReplyOmit Rows From TableHi ShyMuk, It is difficult without proper info. If you are just looking for logic, then : It sounds like  a minus operation, set theory. But before using , since data have to be matched to t...
49316 Jan 2014 @ 12:22 PSTDatabaseReplyIssues with importing file with Date to TableHi, You have not shared you script settings. Are you using setting like : .import vartext file=/home/adc.dat;using id(varchar(20)) ..... Also, you can think of using CSVLD function too. Cheers,
49215 Jan 2014 @ 11:50 PSTDatabaseReplyColumn Addition in Teradata Also , today it so happened that I increased the length of a column of a populated table thus: alter table db1.raja_test1 add id format 'x(255)'  VARCHAR(255) ;--previousl...
49115 Jan 2014 @ 11:29 PSTDatabaseReplyHow to grant a role to public If I dont miss out:    create role role1;   GRANT EXECUTE......,DROP FUNCTION ON object1 TO role1;   grant role1 to xxxxxxxxxxx;   modify...
49015 Jan 2014 @ 10:01 PSTDatabaseReplyRegarding the constraintsYour table is empty, you can make a change. You cannot alter a populated primary‑indexed table to have a different set of primary index columns. Cheers,
48915 Jan 2014 @ 09:50 PSTDatabaseReplyHow to use regex in Teradata or 'LIKE' operator in teradataHi, I am not very sure how you represent data like above.   This is what I get: CREATE MULTISET TABLE db1.raja_test1 ,NO FALLBACK ,      NO BEFORE JOURNAL,  ...
48815 Jan 2014 @ 08:56 PSTDatabaseReplyQUERY BAND MEANING AND ERRORS This link may give a good picture of what Query band's purposes and keys:   http://developer.teradata.com/doc/connectivity/tdnetdp/13.11/webhelp/QueryBandReserved.html  ...
48715 Jan 2014 @ 08:17 PSTDatabaseReplyNew Features in Teradata 14Yes, Releases are good ones. I also like this link: http://www.teradatamagazine.com/v13n03/Tech2Tech/The-Greatest-Database-for-Analytics/ for 14.10 , for high level and non-technical. Cheers,
48615 Jan 2014 @ 02:49 PSTDatabaseReplyNew Features in Teradata 14 Teradata is so huge and vast . Which area or section you are looking from? Hardware/Software?BTEQ,IBM CICS interface, Teradata admin, BAR, CLI, ODBC, utilities...Wizards,  Tools and...
48514 Jan 2014 @ 08:04 PSTTrainingReplycertification TD 12 vs TD 14 BasicsHi Murli, There are lots of materials in  http://www.info.teradata.com Cheers,
48414 Jan 2014 @ 06:46 PSTDatabaseReplyassign ranks to top employeeHi Srikanth, select b.name,b.dept,b.amount,a.rnk from  (select name,sum(amount) as sumamt, rank() over (order by sumamt desc) rnk from db1.raja_test  group by 1) a, (s...
48313 Jan 2014 @ 07:46 PSTGeneralReplyTechnology change - Mainframe to TeradataHi Abjain, Obviously, they will look if it demands Teradata knowledge. But I feel that if you learn the technology and know how to sell and you have good luck too, then you can sail  through ...
48213 Jan 2014 @ 07:15 PSTDatabaseReplyStored Procedure Default Date Format To see the settings in session we use HELP SESSION;    We can set date settings for session:   SET SESSION DATEFORM = ANSIDATE;    select da...
48113 Jan 2014 @ 02:04 PSTThird Party SoftwareTopicExtracting and Transforming tools or RDBMS for unstructured and semi-structured dataWhich tools or RDBMS are best for extracting and Tranforming unstructured data? Or is it better to write unix, perl or python scripts? Load of stream data can be for long time. Thanks and regard...
48012 Jan 2014 @ 11:04 PSTDatabaseReplyWay to retrieve old definition of a view Did you check DBQL tables, if you enable them like Querytext from DBC.DBQLogTbl? BEGIN/REPLACE QUERY LOGGING: Also  I can think of Teradata MDS. I think like other repositories , it...
47912 Jan 2014 @ 08:59 PSTDatabaseReplyWay to retrieve old definition of a view Will this help you? example select requesttext,tablekind from dbc.tables where databasename='dbc' and tablekind='V'   and you can verify with. SHOW QUALI...
47812 Jan 2014 @ 12:01 PSTDatabaseReplyWay to retrieve old definition of a viewAFAIK, if dbc and backup are not possible, then I can think of Unity Director, if you have system1 and System2. Just my thought. Cheers,
47710 Jan 2014 @ 07:41 PSTConnectivityReplyMasking Password on the JDBC connectivity from Hadoop to Teradata.Many years ago, we put login credentials in a file. We open the file before logon. Read the values at the program. Once logged on, we remove the file. That file is read with ugo[r-w-x]  only r...
47610 Jan 2014 @ 07:17 PSTToolsReplyBTEQ ERROR CODE .QUIT 66 Logs off from Td Session. Format is  .QUIT n ERRORCODE ERRORLEVEL ACTIVITYCO   Where n A decimal number specified as the job step return code.To avoid exist...
47510 Jan 2014 @ 02:44 PSTGeneralReplyTechnology change - Mainframe to Teradata If you see the job requirements, (compare Mainframe and Teradata), Teradata has lots of reqts. Teradata connects well with Mainframe, if you look at tools and utilities. If you can get projects ...
47410 Jan 2014 @ 01:58 PSTConnectivityReplyMasking Password on the JDBC connectivity from Hadoop to Teradata. Can you try , if your unix env supports ftppwd, then you can encrypt your password. Remember to echo it after implementing and store in a good place. Cheers, Raja
47310 Jan 2014 @ 12:11 PSTToolsReplyCpu skew of Fastload Is it  set or multiset table. Whether UPI or NUPI  to narrow down the search. How many nodes, amps,application server, TPA node etc. If it is slow it could be due to network also. ...
47209 Jan 2014 @ 11:46 PSTToolsTopicUnity Ecosystem ManagerIs Unity Ecosystem Manager a monitoring tool only or we can schedule jobs too based on applications, maintaining depdendencies, even if it is hadoop jobs, ETL jobs, database jobs too? Cheers,

Pages