|20199||20 Jul 2011 @ 04:54 PDT||redravi207||General||Reply||Restarting 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.
|20198||20 Jul 2011 @ 03:54 PDT||VandeBergB||UDA||Reply||Key Level Duplicates||did you try something like...
group by 1,2
--for the non duplicates, if you'd like to find the duplicat... |
|20197||20 Jul 2011 @ 03:39 PDT||Ashok Pentapati||UDA||Topic||Key Level Duplicates||Hi All,
I was trying to select all the columns which are not key level duplicates.For that I have written a query as
QUALIFY ROW_NUMBER() OVER (partition by col1,col2 ... |
|20196||19 Jul 2011 @ 10:10 PDT||stever||Viewpoint||Reply||how to make Portlet's service implementation class non-singleton||All 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 ... |
|20195||19 Jul 2011 @ 09:33 PDT||bilal.farooq||Viewpoint||Topic||how to make Portlet's service implementation class non-singleton||Hi,
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... |
|20194||19 Jul 2011 @ 08:12 PDT||tdstar.rams||Training||Reply||Teradata 12 Certification||I want to give attempt for TD12 certification.if anybody completed TD12 certification,please forward the any TD12 certificate dumps or material... |
|20193||19 Jul 2011 @ 04:10 PDT||Kishore_1||Database||Topic||grouping on character fields||Hi,
A table tab_1 is defined with 2 columns: group_name and email_ids.Sample data in tab_1 is as follows:
group1 abc@xyz... |
|20192||19 Jul 2011 @ 02:21 PDT||dnoeth||Analytics||Reply||need 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... |
|20191||19 Jul 2011 @ 01:17 PDT||stever||Viewpoint||Reply||Bulk Load for Viewpoint users||You 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... |
|20190||19 Jul 2011 @ 01:11 PDT||sk73||Analytics||Reply||need 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... |
|20189||19 Jul 2011 @ 01:07 PDT||stever||Viewpoint||Reply||Viewpoint / TASM Alerting||For 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... |
|20188||19 Jul 2011 @ 12:53 PDT||mnylin||Analytics||Reply||need SQL help (The Output does not contain correct number of rows)||what do the explain plans show between the two queries? |
|20187||19 Jul 2011 @ 12:52 PDT||mnylin||Database||Reply||How 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.
|20186||19 Jul 2011 @ 12:46 PDT||mnylin||Database||Reply||Qry runs long||Have 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 * ... |
|20185||19 Jul 2011 @ 12:35 PDT||vhari||Connectivity||Reply||Error: 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... |
|20184||19 Jul 2011 @ 11:40 PDT||teradatatester||Database||Reply||Teradata to teradata replication using Golden Gate||You could use the ETL software Talend
|20183||19 Jul 2011 @ 11:37 PDT||teradatatester||Database||Reply||Regular Expressions?||Are there any plans for Regular Expressions to be available in the future without needing rights to create a UDF? |
|20182||19 Jul 2011 @ 11:37 PDT||Jim Chapman||Cloud Computing||Reply||How to setup Cloud??||I think this explains it:
|20181||19 Jul 2011 @ 11:16 PDT||msschenck||Connectivity||Topic||Cannot deploy JDBC driver to WebLogic 10.3.4||Am 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..... |
|20180||19 Jul 2011 @ 11:12 PDT||Tnewbee||Database||Topic||Qry runs long||Hi !
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 ... |
|20179||19 Jul 2011 @ 10:57 PDT||tdstar.rams||Database||Reply||Global temporary tables||Thanks a lot |
|20178||19 Jul 2011 @ 10:56 PDT||sixpakvb||Viewpoint||Topic||Viewpoint / TASM Alerting||We 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... |
|20177||19 Jul 2011 @ 10:37 PDT||mnylin||Database||Reply||Performance Tuning Factors||It'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 ... |
|20176||19 Jul 2011 @ 10:36 PDT||sanjibkp||Database||Topic||How 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... |
|20175||19 Jul 2011 @ 10:34 PDT||mnylin||Database||Reply||Throughput||Through-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... |