Ads 468x60px

Pages

Subscribe:

Labels

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)

Labels

Blogroll

About

Blogger templates

Blogger news

Monday 19 November 2012

XML Optimization through custom Properties


1. Problem Statement:
I am creating a XML file as an output . If my source is empty, is there a way to  avoid the creation of an empty XML file?
Sample output Data with source data :

Case 1 : Empty Source – Creation of Minimal XML file
We have to set the following properties of an XML Target at session level under the Mapping tab.
Null Content Representation – “No Tag”
Empty String Content Representation – “No Tag”
Null Attribute Representation – “No Attribute”
Empty String Attribute Representation – “No attribute”

Advanced Replication Setup for High availability and Performance

In my personal opinion, Oracle leads the market in Directory Product offerings (LDAP Directories). Starting from Oracle Internet Directory (OID), to the latest Oracle Unified Directory (OUD), Oracle definitely provides variety of LDAP Directory related products for integration.
With increasing demand for mobile computing and cloud computing offering, there is a need to standardize LDAP Deployments for Identification, Authentication and (sometimes) Authorization (IAA) services. With a highly scalable, highly performing, highly available, highly stable and highly secure LDAP Directory, these IAA services will be easier to integrate with applications in the cloud or for the mobile applications.

Transitioning to a New World – An Analytical Perspective


Recently, I had the opportunity to speak at the Silicon India Business Intelligence Conference. The topic I chose for the discussion was focused on providing the BI & Analytics perspective for companies transitioning to a new world. You can view my presentation at this link –http://bit.ly/VLDDfF
The gist of my presentation is given below:
1)      First, established the fact that the world indeed is changing by showing some statistics:
  • Data Deluge: Amount of digital data created in the world right now stands at 7 Zettabytes per annum (1 Zettabyte = 1 Trillion Terabytes)
  • Social Media: Facebook has touched 1 Billion users which makes it the 3rd largest country in the world
  • Cloud: Tremendous amount of cloud infrastructure is being created
  • Mobility: There are 4.7 billion mobile subscribers which covers 65% of world population

Tuesday 16 October 2012

Collaborative Data Management – Need of the hour!

Well the topic may seem like a pretty old concept, yet a vital one in the age of Big Data, Mobile BI and the Hadoops! As per FIMA 2012 benchmark report Data Quality (DQ) still remains as the topmost priority in data management strategy:
What gets measured improves!’ But often Data Quality (DQ) initiative is a reactive strategy as opposed to being a pro-active one; consider the impact bad data could have in a financial reporting scenario – brand tarnish, loss of investor confidence.
But are the business users aware of DQ issue? A research report by ‘The Data Warehousing Institute’, suggested that more that 80% of the business managers surveyed believed that the business data was fine, but just half of their technical counterparts agreed on the same!!! Having recognized this disparity, it would be a good idea to match the dimensions of data and the business problem created due to lack of data quality.

Wednesday 12 September 2012

Hexaware sees strong order pipeline; 20% growth: Nishar

Atul Nishar, chairman, Hexaware, says that we remain quite positive on growing at 20% or more. We feel that if the situation improves with US elections and no debacle in Europe then the environment could only improve.


Atul Nishar, Chairman, Hexaware
Atul Nishar, chairman, Hexaware , says that we remain quite positive on growing at 20% or more. We feel that if the situation improves with US elections and no debacle in Europe then the environment could only improve.

He also says that currently there are five deals in the pipeline and one is in the advance stage. The deals are spread across from the United States and Europe, and across major verticals like capital markets, travel and emerging verticals. And in the last nine quarters the company has signed seven large deals.


Below is the edited transcript of his interview to CNBC-TV18.


Q: Hexaware recently had a deal and there have been reports or analyst notes which suggest that the company is in conversation with potential clients for four deals and one is in advance stages. Do you think something could fructify in the near-term?


A: Currently, there are five deals in the pipeline and one is in the advance stage. The deals are spread across from the United States and Europe, and across major verticals like capital markets, travel and emerging verticals. And in the last nine quarters we have signed seven large deals.


Q: Are billings under pressure even if the deals are coming? Are they coming from tight fisted managements?


A: In over last two years, we have marginally improved our average billing on both on onsite and offshore. We don’t see any pressure on pricing on the IT industry. Repeatedly, we have guided that our pricing should be assumed to be stable.


The important point is that the client want value, greater performance, result oriented projects and fixed priced or greater commitment by off shoring companies.  Clients do want to cut their costs and get more value, but they also know if it is all done at the cost of the service provider, it will not sustain that particular situation.


Q: How much do you think is Nasscom’s 13-14% growth target under threat? What might it fall to half or high single digits?


A: Nasscom has guided for 11-14% and it is a wide enough range. In the industry we saw that some companies like mid-sized companies and companies who are scale players have also done very well. It is a mixed reason. We have seen more client specific issues coincidence for downsizing for whatever reason that may dent revenue that doesn’t mean they will not be able to grow in future.  


Q: Do you think Nasscom will hold the lower end of their 11% range?


A: That is the current optimism. So, there is no reason to believe that there is material change from the guided number.


Q: The one concern around Hexaware has been for some time that you have seen an improvement in margins, but going forward it would come under pressure because in Q3 wage hikes are expected to shave off margins to a certain extent. How do you respond to that?


A: In Q2, ours being calendar year, Hexaware reported 22.9% EBITDA which was higher than Q1. We gave normal 10% increment to all our off shore employees. The impact was absorbed in our margin and in spite of that the margin improved.


We also absorbed the significant visa costs that traditionally come in that quarter. In the coming quarter there will be onsite increase in wages. For off shore workers the date of increment is April 1 and for onsite employees the date is July 1, which remains unchanged. And we feel with this we can guide stable margins.


We are proud that at Hexaware, we have grown at higher than the industry average at good margins. We don’t believe in taking new deals by compromising on margins in any manner.


Q: So at this juncture you don't want to change your guidance of 20% dollar revenue growth any which way, up or down?


A: We remain quite positive on growing at 20% or more. We feel that if the situation improves with US elections and no debacle in Europe then the environment could only improve.