Blogs | Hexaware

Blogs


Latest Post
Perils of DataMover Access– Part 2a PeopleSoft provides trigger-based auditing functionality as an alternative to the record-based auditing that PeopleSoft Application Designer provides. Perform the following steps to setup trigger based auditing for PSAUTHITEM. 1.  Create a custom table to store the audit data for PSAUTHITEM. And build the record in the database. 2.  Navigate to PeopleTools --> Utilities --> Audit --> Update Database Level Auditing. 3.  Add a New Value and select Record Name PSAUTHITEM 4.  Select the record AUDIT_AUTHITEM (we created in step 1) as the Audit Record.   5.  Check all the audit options. 6.  Click on…
Posted by Nitin Pai
Comments (2)
June 5th, 2007
ETL represents the three basic steps: Extraction of data from a source system Transformation of the extracted data and Loading the transformed data into a target environment In general 'ETL' represented more of batch process and that of gathering data from either flat files or relational structure. When ETL systems started supporting data from wider sources like XML, industry standard format like SWIFT, unstructured data, real time feeds like message queues etc ‘ETL’ got evolved to ‘Data Integration’. That’s the reason why now all ETL product vendors are called Data Integrators. Now let us see how Data Integration or ETL…
Posted by Muneeswara C Pandian
Comments (0)
June 1st, 2007
People who read the last post on this blog "What is a Data Warehouse" would probably accept my view that for an organization to get better at anything worthwhile, "data" is everything. If you accept this notion, I propose the immediate creation of a new 'C' level organizational position - Chief Data Officer (CDO). To me, the CDO is a more important position than the more glamorous CIO (Chief Information Officer). After all, the input to any strategic information is raw data and many organizations don’t have a comprehensive focus on data that is present within its boundaries. It is…
Posted by Karthikeyan Sankaran
Comments (0)
May 30th, 2007
First of all, I am going to tell you something about IPC System on Unix Operating System and how it is related managing a Peoplesoft based environment. I took this topic first since PeopleSoft uses this for the application server and Process Scheduler server level; we need to know IPC System to understand how these PeopleSoft server processes work. We normally face issues related to this during our real-time supporting a Peoplesoft environment. A process, in Unix perspective, is a running program, created by the fork() system call. That's all. We can say, processes are created by 'forking'.  Forking means…
Posted by Vijayakumar Chinnasamy
Comments (0)
May 30th, 2007
Did you know that users connected to DataMover will have database access similar to access id? What does this mean for you in a Production Environment? This can be really scary if you do not have security in place to ensure that DataMover access is restricted and controlled. Use the below SQL to determine who has access to DataMover, through which permission list and role. SELECT DISTINCT A.CLASSID, B.ROLENAME, C.ROLEUSER FROM PSAUTHITEM A, PSROLECLASS B, PSROLEUSER C, PSOPRDEFN D WHERE A.CLASSID = B.CLASSID AND B.ROLENAME = C.ROLENAME AND A.MENUNAME = 'DATA_MOVER' AND D.OPRID = C.ROLEUSER AND D.ACCTLOCK = 0 Ensure…
Posted by Nitin Pai
Comments (0)
May 29th, 2007
Long long ago, I started my software career as a web developer who wrote coding on Perl CGI and running them using Apache..... Good or bad, I forgot most of the coding part now, except If I see part of the code, I am able differentiate whether this is a shell script or a perl script. And one more skill(really?) that, I developed was to understand the script based on the extension provided to the script or program whether that is a shell script, perl script or python script (.sh,.ksh,.csh,.pl,.py sometimes .bash)... We were using a Linux distribution at that…
Posted by Vijayakumar Chinnasamy
Comments (0)
May 24th, 2007
To define the term Data Warehouse (DW) especially to software developers who are new to the industry, have tried asking them a few simple questions before getting to the classic definition in the words of Bill Inmon. Some of the questions which leads to defining a Data Warehouse are: Q: What is Data? A: ‘Data’ is a collection of facts which are captured as it happens. E.g., the content present in a Survey Sheet is ‘Data’ Q: What is information? A: The details that are derived by processing the ‘Data’ are called Information. E.g., the details that are arrived from…
Posted by Muneeswara C Pandian
Comments (0)
May 24th, 2007
When I began writing this blog, I really thought that why did I even think of broaching the topic of change in the aviation sector. I am not an expert in this area so to say. But I am not a novice either. I mean around 4 years in this area has made me realize that this is an area incorporating change on a regular basis. Change is inevitable and has a deep influx in a domain that has been technology driven for ages. But the important factor is that when change is ‘properly guided’, it can yield excellent results…
Posted by Sireesha Rao
Comments (0)
May 22nd, 2007
This blog is opened to create a common platform for those who are working in the Travel & Distribution, Hospitality, Airlines, Transportation & Logistics Sectors. I like to encourage professionals working in these industries to share their thoughts on the latest developments, industry & technology trends and challenges, standard standards and best practices, solution needs and alternatives. This industry is characterised by early adoption of technology (and hence deployment of many legacy systems that are disparate in nature), many products that are still evolving, emergence of platform based solutions etc. The constant change in business models and operations in a…
Posted by Reji George
Comments (10)
April 10th, 2007
Contact Us