Ads 468x60px




Informatica (18) Integration Service (10) Siebel Business Intelligence (6) ETL (5) Informatica PowerCenter (4) Informatica PowerCenter 8x (4) Oracle (4) Metadata (3) DTM (2) Data Transformation Manager (2) Hexaware Technologies (2) OUD (2) Oracle Unified Directory (2) PowerCenter (2) XML (2) business (2) ASCII (1) Administration Console (1) Application Services (1) Automated Migration (1) BFSI (1) Binary (1) Bulk Load (1) Business Intelligence (1) Business Intelligence Challenge (1) Business Intelligence Company (1) Business Intelligence Consulting (1) Business Objects (1) ByTree (1) CDC (1) CNBC News (1) CNBCTV18’s Shreya Roy (1) COBOL (1) Change Data Capture (1) Collaborative (1) Collaborative Data Management (1) Computing Expression Evaluator (1) Convert Rows To Columns In Inforamtica (1) Data (1) Data Governance (1) Data Management (1) Data Mart (1) Data Type (1) Data Virtualization Services (1) Database (1) Datawarehouse (1) ETL Developers (1) Expression Evaluator (1) Expression Evaluator Debugging (1) Extract (1) FTP (1) File List (1) Flash or Java Applets (1) Flat Files (1) Function (1) HP Diagnostics-Identify (1) HP Diagnostics-Identify bottlenecks (1) HTTP Headers (1) Hexaware Technologies Limited (1) IT Metrics (1) IT companies (1) IT company (1) Index (1) Indirect Source (1) Informatica 8.6 (1) Informatica 8.x (1) Informatica Data Integration Service (1) Informatica Debugger (1) Informatica Debugging Transformation (1) Informatica Development (1) Informatica File Transfer (1) Informatica Power Center (1) Informatica Powercenter 8x Key Concepts (1) Informatica Process Control Audit (1) Informatica Repository Restoration (1) Informatica Server Re-Installation (1) Informatica Server Recovery System (1) Informatica Upgrade Challenge (1) Informatica Workflow (1) Informatica Workflow Process Control (1) Integration Services (1) Integration and Repository services (1) Invalid Objects (1) JavaScript Functions (1) Joiner Transformation (1) LDAP (1) LDAP Directory (1) LDAP Replication (1) Load Balancer (1) LoadRunner 11.5 (1) Looping (1) Manual Correlation (1) Mappings (1) NTLM Resource (1) NTLM authentication (1) Native Driver (1) New Column (1) ODBC (1) ODBC Driver (1) OID (1) OUD Configuration (1) OUD Directory Server (1) OUD Replication (1) Oracle Applications (1) Oracle Client (1) Oracle Hints In SQL (1) Oracle Internet Director (1) Oracle Optimizer (1) Oracle R12 (1) Oracle Solutions (1) Oracle loadrunner (1) OracleErrorActionFile (1) PeopleSoft Jobs (1) PeopleSoft Jobs In Hexaware (1) Peoplesoft Tester In Chennai (1) Peoplesoft Tester Jobs In Chennai (1) Performance (1) Performance Testing (1) PowerCenter 8.5 (1) PowerCenter Server (1) PowerCenter Server Support (1) Powercenter 8.5.1 (1) Pushdown Optimization (1) Re-Import (1) Relational (1) Remote Filename (1) Repository Services (1) Reverse Of A Normalizer In Informatica (1) Rows Read (1) SFTP (1) SJSDS (1) SMP (1) SQL Statement (1) SSH2 (1) SUBSTR Function (1) Session Failed (1) Source Data (1) Source Definition (1) Source Row (1) Store Procedure (1) SuppressNilContentMethod (1) Symmetric Multi-Processing (1) Target Definition (1) Target Row (1) Task Developer (1) Text Flags (1) Transfer Protocol (1) Transformation (1) Transformation Logics (1) Transpose Records (1) UDF (1) User Defined Functions (1) WriteNullXMLFile (1) XML File (1) XML Optimization (1) XML Target (1) XML Tuning (1) XMLSendChildFirst (1) XMLWarnDupRows (1) Zero byte XML file (1) accelerate application (1) employee performance (1) mid-cap it (1) web_reg_save_param (1)




Blogger templates

Blogger news

Featured Posts

Sunday, 26 January 2014

Informatica Way - Restoring lost Informatica file system

Informatica Server Recovery System
One of our servers crashed and we had lost the complete file system and the Informatica folder. However,the repository database was on another server and it was intact. It was a challenge for the Informatica Administration Team to restore & recover several components including:-
  • Powercenter Services
  • Data Quality / Analyst Services
  • Data Transformation Projects
  • Data Validation Option for the Server
  • Data Virtualization Services
Server Characteristics:-
  • Powercenter & DQ Metadata was available in the databases which were configured for the corresponding Repositories
  • Number of Users in the server = 10
  • Number of Folders in Powercenter = 25
  • Number of Projects in DQ = 10
  • Data Transformation Projects = 5
We leveraged the “Content Already Exists in the Specified Database” feature available in the Informatica Administrator Tool during the re-installation process to re-install the server (Domain) & to re-establish connection with the existing repository.

Using the steps mentioned below, we could restore all the data successfully except the previously created users (we re-created the users)

Tuesday, 8 October 2013

Informatica Debugger – Expression Evaluator

Expression Evaluator is mainly useful during debugging, when one wants to know the value of a particular expression at that point of debugging:

Before implementing this we generally face difficulty in computing the result of any expression at a given point of debugging. Earlier when required to find the value of a given expression during debugging, we required to try out manually using the current record values from the instance windows. In cases of complex expressions, manual calculations resulted in incorrect values in addition to time loss.

After implementing the best practice i.e. using expression evaluator, computing the values of any expression will be simpler no matter how complex the expression is and the time spent on debugging gets reduced. Below are the steps to follow.

1. While running the debugger, go to the desired transformation (Say expression)
2. Copy the desired complex expression available in the transformation (any of the ports).
3. Right click the transformation and choose expression evaluator.
4. In the editor, paste the copied expression and validate it and then click the “Evaluate” button.
5. It gives the computed value of the expression by using the current record values.

  •  Evaluates the given expression against the current processing record in the transformation.
  • The same rules as in expression editor will apply over here.
  •  Will be able to compute complex expressions at any point during debugging.
  • Expression Evaluator always uses the current record values from the ports of the transformation while computing the expression.
  • Manual computation is completely removed during debugging.
  • Less effort is applied for understanding what values are getting passed over a given transformation.
Click to visit more related stories:

Tuesday, 20 November 2012

Oracle R12 Applications Using LoadRunner

The Challenge
We recently load tested our first Oracle R12 release (All modules for nationwide and international wide of Oracle ERP R12). The company was upgrading to R12 from 11.5.8 largely for performance reasons.
We knew we’d be “cutting new ground” with LoadRunner on R12. This became evident with our first testrecord-and-playback, which failed even after finding and fixing all the missing correlations. We raised a ticket with HP (SR# #4622615067), and with their initial help, step by step we overcame all the nuances of coaxing vugen to record successfully, and then creatively working around its inability to recognize the full set of identifiers for a new java ITEMTREE object.

Configuring Oracle Unified Directory (OUD) 11g as a Directory Server

I used Oracle Unified Directory (OUD) Version during my test deployment locally here. I tried to collect as much information possible in this post for configuration.
Ideally, there are three possible configuration options for OUD:
  • as a Directory Server
  • as a Replication Server
  • as a Proxy Server
Directory Server provides the main LDAP functionality in OUD. Proxy server can be used for proxying LDAP requests. And Replication Server is used for replication from one OUD to another OUD or even to another ODSEE (earlier Sun Java Directory) server. You can my previous posts on OUD here and here.

Monday, 19 November 2012


Identifying and correcting availability and performance problems can be costly, time consuming and risky. IT organizations spend more time identifying an owner than resolving the problem.
HP Diagnostics helps to improve application availability and performance in pre-production and production environments. HP’s diagnostics software is used to drill down from the end user into application components and cross platform service calls to resolve the toughest problems. This includes slow services, methods, SQL, out of memory errors, threading problems and more.