Blogs | Hexaware

Blogs


Latest Post
The traditional Application Service Provider - ASP Model is overrun by the upcoming Software as a service SaaS Model. Whether it is a deployment, upgrade or maintenence project - the onshore offshore model present in leading indian software companies were growing with a lot of money inflow as a result of ASP model. But In the present scenario, the companies like salesforce, workday are providing the software on demand services with client specific customizations based on the SAAS model also. In SaaS the customer pays for the services offered by the company/vendor and the cost involved in maintaining the application…
Posted by Pon ArunKumar Ramalingam
Comments (2)
October 25th, 2007
How to improve the performance of the SQR using Load Lookup Arrays? For Simple database related validation, we will fire a SQL to check the sanity of data. If this data validation is to be fired for each and every row of data, then it is better to go for Load-Lookup Arrays. This is like Prompt table validation in the case of Online Pages. In this way, we can reduce the database hits and thereby increasing the Performance of the SQR Program. For Eg: If we want to validate the Earnings Codes present in the file, we can use these…
Posted by Kannappan Krishnan
Comments (0)
October 23rd, 2007
One of the hallmarks of a good administrator is that they are already troubleshooting the problem before the users complain! The key to ensuring that the system does not spring surprises is to automate monitoring (without impacting the system performance). In my previous posts, I have provided steps to monitor the process scheduler and application server. This post will provide insights into monitoring the integration broker messages, publication and subscription contracts. Use the below SQLs for monitoring. SUBSCRIPTION SELECT A.CHNLNAME, DECODE(A.SUBCONSTATUS,0,'ERROR',1,'NEW',4,'DONE',A.SUBCONSTATUS) STATUS, COUNT(*) FROM PSAPMSGSUBCON A WHERE -- not older than 99 days A.LASTUPDDTTM >= sysdate - 99 -- in…
Posted by Nitin Pai
Comments (5)
October 19th, 2007
In some cases the two preferred methods for executing UPGCOUNT do not work for you because You do not have access to PSAE executable You have very limited access to the environment to successfully run the AE Here is a PL/SQL that you can use to provide similar result. set serverout on size 1000000 DECLARE CURSOR C1 IS SELECT RECNAME, SQLTABLENAME FROM PSRECDEFN WHERE RECTYPE = 0 ORDER BY RECNAME; VAR_COUNT NUMBER; VAR_REC_COUNT NUMBER :=0; VAR_SQLTEXT VARCHAR2(32000); VAR_RECNAME VARCHAR2(64); VAR_PAD VARCHAR2(100); VAR_DATE DATE; BEGIN SELECT SYSDATE INTO VAR_DATE FROM DUAL; DBMS_OUTPUT.PUT_LINE('Report for Record Rowcount'); DBMS_OUTPUT.PUT_LINE('START DATE AND TIME:'||TO_CHAR(VAR_DATE,'MM/DD/YYYY HH24:MI:SS')); DBMS_OUTPUT.PUT_LINE('RECNAME…
Posted by Nitin Pai
Comments (0)
October 16th, 2007
UPGCOUNT is an AE in current tools releases. Also, there is no delivered page to kick-off this process. The output from this report is critical to determine the success of a major migration (MP or multiple bundles or Upgrade). This helps validate the process to ensure that no data was lost as a result of the migration (running Data Mover scripts, data conversion, etc). Here are some methods that you can use to run this AE program. 1.Through App Designer Open the UPGCOUNT AE in App Designer Click on Run Program icon Choose appropriate options on the “Run Request” dialog…
Posted by Nitin Pai
Comments (1)
October 15th, 2007
Enabler 5 in my list for Business Intelligence Utopia are the ubiquitous, hard-working “Data Models”. Data Model is the heart of any software system and at a fundamental level provides placeholders for data elements to reside. Business Intelligence systems with all its paraphernalia – Data Warehouses, Marts, Analytical & Mining systems etc. typically deals with the largest volume of data in any enterprise and hence data models are highly venerated in the Data Warehousing world. At a high level, a good Data Warehouse data model has the following goals: (Corollary – If you are looking for a data modeler look…
Posted by Karthikeyan Sankaran
Comments (0)
October 15th, 2007
I have always recommended the following reports to determine a clean migration especially when there are a ton of objects to be migrated (PS Upgrade, Application of Maintenance Packs or Bundles, etc). Prior to application of the bundles execute the following. 1. SYSAUDIT 2. DDDAUDIT 3. ALTER AUDIT 4. UPGCOUNT (just prior to the actual migration) The first three can be executed a few hours or days before the actual migration as long as you ensure that no changes are migrated or performed in to the target environment which might cause an impact on these reports. However the UPGCOUNT process…
Posted by Nitin Pai
Comments (0)
October 8th, 2007
Interoperability and communication between applications plays a vital role in today's emerging business needs.One such component which helps the business to transfer data between different system is the Data Transformation Service Packages famously known as DTS packages.This pasage will cover the differences between SQL Server 2000 and SQL Server 2005 with respect to the DTS Packages.Enterprise Manager of the Microsoft SQL Server 2000 provides an inbuilt menu within its IDE and the dts packages are accessed using the SQL Server 2000 DTS Designer IDE. The DTS Designer 2000 allows us to perform the following tasks over a package such as…
Posted by Pon ArunKumar Ramalingam
Comments (0)
October 4th, 2007
Service Oriented Architecture (SOA) and its closest identifiable alter-ego “Web Services” is another example of hyped-up, much maligned technology buzzword that takes at least 2 or 3 slides in any “bleeding-edge” technology presentation. Having said that, whatever I have investigated on Service Oriented Architectural concepts till now, is enough to warrant its listing as enabler no. 4 for Business Intelligence Utopia. There are many powerful ways through which SOA can add significant value to the BI environment. The kind of BI, performance management and data integration artifacts that can be developed and published as web services include: Queries, Reports, OLAP…
Posted by Karthikeyan Sankaran
Comments (0)
October 3rd, 2007
In my development environment, I had a request to create 30 new OPRID’s cloning an existing developer id template. I was not interested in logging into PeopleSoft, navigating to PeopleTools > Security > User Profiles > Copy User Profiles, and creating the clone 30 times. Hmm… So here is what I did. 1.Create a dummy table create table hx_clone_ids (oprid varchar2(30)); 2.Insert all desired OPRID values. For example, INSERT INTO HX_CLONE_IDS SELECT 'HX_NPAI_'||ROWNUM FROM PSOPRDEFN WHERE ROWNUM < 31; 3.Execute below SQL’s (OPRID to be cloned is NPAI). INSERT INTO PSOPRALIAS SELECT HX.OPRID, OPRALIASTYPE, OPRALIASVALUE, SETID, EMPLID, CUST_ID, VENDOR_ID, APPLID,…
Posted by Nitin Pai
Comments (4)
October 1st, 2007
Contact Us