All forum activity

#DateUserForumTypeThreadPost
2019920 Jul 2011 @ 04:54 PDTredravi207GeneralReplyRestarting Mload delete job.Jim, Could you please explain me the Mload restart in Acquisition and Application Phase in details. like how it works in both the phases and how the Checkpoint helps.
2019820 Jul 2011 @ 03:54 PDTVandeBergBUDAReplyKey Level Duplicatesdid you try something like... select key_field_1 ,key_field_2 ,count(*) from table_a having count(*)=1 group by 1,2 --for the non duplicates, if you'd like to find the duplicat...
2019720 Jul 2011 @ 03:39 PDTAshok PentapatiUDATopicKey Level DuplicatesHi All, I was trying to select all the columns which are not key level duplicates.For that I have written a query as SELECT * FROM Tab_a QUALIFY ROW_NUMBER() OVER (partition by col1,col2 ...
2019619 Jul 2011 @ 10:10 PDTsteverViewpointReplyhow to make Portlet's service implementation class non-singletonAll controller classes in Spring MVC should be singletons. If you use a prototype bean, then the way that it is mapped to the URL changes. The Viewpoint PDK does not document this approach since ...
2019519 Jul 2011 @ 09:33 PDTbilal.farooqViewpointTopichow to make Portlet's service implementation class non-singletonHi, Our Portlets Service Implementation class has to contain some "state" information, how can it be made a non-singleton...? I tried singleton="false" in the bean declaration in applicationCon...
2019419 Jul 2011 @ 08:12 PDTtdstar.ramsTrainingReplyTeradata 12 CertificationI want to give attempt for TD12 certification.if anybody completed TD12 certification,please forward the any TD12 certificate dumps or material...
2019319 Jul 2011 @ 04:10 PDTKishore_1DatabaseTopicgrouping on character fieldsHi, A table tab_1 is defined with 2 columns: group_name and email_ids.Sample data in tab_1 is as follows: group_name email_ids ---------------- -------------- group1 abc@xyz...
2019219 Jul 2011 @ 02:21 PDTdnoethAnalyticsReplyneed SQL help (The Output does not contain correct number of rows)Hi Sree, check the table definition if there's a FOREIGN KEY WITH NO CHECK OPTION REFERENCES tableA(id) The optimizer might do a join elimination if tableA.id is defined as NOT NULL (i.e. alway...
2019119 Jul 2011 @ 01:17 PDTsteverViewpointReplyBulk Load for Viewpoint usersYou would have to deploy PMON to the desktops of all those 100 users, so I don't think it's fair to compare the user provisioning for Viewpoint to PMON. The recommendation would certainly be to us...
2019019 Jul 2011 @ 01:11 PDTsk73AnalyticsReplyneed SQL help (The Output does not contain correct number of rows)The explain in the second case does the join whereas in the first case, there is no join and the output is a straight SELECT from table b. The id field in table A and the id field in table B is...
2018919 Jul 2011 @ 01:07 PDTsteverViewpointReplyViewpoint / TASM AlertingFor session alerts from Viewpoint, the username has always been included in the body of the email, if that's the type of alert action being executed. Starting with Viewpoint 13.11.00.05, which was...
2018819 Jul 2011 @ 12:53 PDTmnylinAnalyticsReplyneed SQL help (The Output does not contain correct number of rows)what do the explain plans show between the two queries?
2018719 Jul 2011 @ 12:52 PDTmnylinDatabaseReplyHow to find the find the 3 highest designation for a particular employee.This is usually the kind of problem that Recursive SQL was made for, but with your already flattened structure, that becomes no longer works. I guess you'd need to use a CASE statement. Someth...
2018619 Jul 2011 @ 12:46 PDTmnylinDatabaseReplyQry runs longHave you checked DBQL to see which individual steps are taking the longest? In terms of filtering, if you can put a PPI on the M_DT field, use a between filter instead of the Extract. SELECT * ...
2018519 Jul 2011 @ 12:35 PDTvhariConnectivityReplyError: SQL Error:Specified driver could not be loaded due to system error- Make sure you have 13.10.0.x ICU & TeraGSS pkg. installed. - Make sure you have a ODBC DSN created using 64-bit ODBC Administrator. - If you have installed Teradata pkgs. while linked server is...
2018419 Jul 2011 @ 11:40 PDTteradatatesterDatabaseReplyTeradata to teradata replication using Golden GateYou could use the ETL software Talend http://www.talend.com/demo/
2018319 Jul 2011 @ 11:37 PDTteradatatesterDatabaseReplyRegular Expressions?Are there any plans for Regular Expressions to be available in the future without needing rights to create a UDF?
2018219 Jul 2011 @ 11:37 PDTJim ChapmanCloud ComputingReplyHow to setup Cloud??I think this explains it: http://xkcd.com/908/
2018119 Jul 2011 @ 11:16 PDTmsschenckConnectivityTopicCannot deploy JDBC driver to WebLogic 10.3.4Am trying to deploy the JMS Universal Connector to WLS 10.3.4. I have tried finding out the 'How-To' documents related to deploying JDBC driver mentioned in the JMSUC Install Guide, no success.....
2018019 Jul 2011 @ 11:12 PDTTnewbeeDatabaseTopicQry runs longHi ! This query runs for a long time . I can see that there is a left outer join and a full outer join. I tried filtering out the roiws from the tables before the join like ' Sel * from table ...
2017919 Jul 2011 @ 10:57 PDTtdstar.ramsDatabaseReplyGlobal temporary tablesThanks a lot
2017819 Jul 2011 @ 10:56 PDTsixpakvbViewpointTopicViewpoint / TASM AlertingWe are receiving alerts from Viewpoint with no problem, however, the information being passed is not completely helpful just from the alert message. Is there anyway to change what is passed back in...
2017719 Jul 2011 @ 10:37 PDTmnylinDatabaseReplyPerformance Tuning FactorsIt's been a while, but if I remember correctly, impact CPU is a way of measuring the impact that a particular highly skewed query has on the system. It takes a look at the highest CPU across each ...
2017619 Jul 2011 @ 10:36 PDTsanjibkpDatabaseTopicHow to find the find the 3 highest designation for a particular employee.Hi, I am working on certain requirement, where we need to so all the employees directly or indirectly reporting to him. The very 1st step, i have created a hierarchical structure displaying t...
2017519 Jul 2011 @ 10:34 PDTmnylinDatabaseReplyThroughputThrough-put typically has to do with the number of queries processed in a given period of time. Can be expressed as queries per second or minute. Response time is the time it takes for a given qu...

Pages