Authors: Vidya Skip navigation
1 2 3 4 5 Previous Next

Informatica Network

65 Posts authored by: Vidya

Top Contributors of Q4 2013

Posted by Vidya Jan 13, 2014

Top Contributors_471x173.png

 

user183512

 

In Ravi's words

 

I would like to say that, the process is very sumptuous to bring the community to a common platform where they learn best practices and share their experience with one-another. One would always like to be a part of it for one’s and in-turn the whole community’s growth which will make all of us successful.

 

jbarberena

 

In Javier's words:

 

Informatica support is a great network for collaboration. It is a great place where great minds get together to help each other. Whenever I am working at a client site, performing a new implementation; or an upgrade and find myself with an issue the first place I turn for a solution is Informatica MySupport.


yagrawal


In Yogesh's words:

 

Glad to get recognized four times in a row.  I am using My Support portal for last 1 and half  year. This site provides all the knowledge related to Informatica under one roof like we have KB articles, PAM, product documents, support videos and many other things which is truly beneficial for the Informatica users.I would like to thank Informatica team for providing such a fantastic platform to the Informatica community members. I encourage everyone to share their knowledge and help make My Support a vibrant collaboration platform.

Dear Informatica Customers,

 

We are delighted to announce the next of the Webinar series, "AddressDoctor - How to get the best out of it" on 30th January 2014 from 8 AM to 9AM (PST).

 

Registrations for the Webinar are now open and the URL to register is

https://informatica.webex.com/informatica/j.php?ED=202558438&UID=499885602&RT=MiM0  (Join as Participant)

 

Alternatively,


More details are available below:

**********************************************************

AddressDoctor is the AddressValidation tool from Informatica. This webinar will give a short introduction to the different interfaces that AddressDoctor provides. It discusses the different Validation options and when to use what. Also, there will be a demo of integration of AddressDoctor into Informatica Data Quality based on use cases.

 

Below is the high level agenda for this Webinar.

  • The AddressDoctor Interfaces:
    • Excel Plugin (based on WebServices)
    • WebServices V4 & V5
    • DQC (Data Quality Center)
    • API (Software Library)
    • Postal Lookup Check (PoCo Lookup)
  • The different Validation Modes and their advantages and culprits.
  • Demo
  • Use Cases
  • Q&A

****************************************************************

About the speaker:

 

Bart Honhoff is a Lead Support Engineer with over 10 year experience handling customer issues with PowerCenter, Data Quality and AddressDoctor.

***************************************************************

 

If you have any issues registering for the Webinar, please feel free to contact praman or Vidya and we will be glad to help.

 

Informatica Support Webinars are a monthly initiative from the Global Support Organization, where a Subject Matter expert will be presenting a Webinar on a particular product. Please feel free to contact us if you have a topic of interest and we shall try to get a Webinar arranged on the same.

 

Kind Regards,

MySupport Portal Team

Dear Informatica Customers,


We are delighted to announce the next of the Webinar Series, Repository – Basic Structure, Locking, Migration Methods and Best Practices on 19th December 2013 from 8 AM to 9 AM (PST).

 

Registrations for the Webinar are now open and the URL to register is:

https://informatica.webex.com/informatica/j.php?ED=257208172&UID=499885602&RT=MiM0 (Join as Participant)

 

Alternatively,

--------------------------------------------------------------------------------------------------------

More details are available below:

 

The Informatica Repository in its simplest sense is a relational database that is managed by the repository service. The metadata that the repository stores is quintessential to the functioning of PowerCenter in all, so its imperative that the integrity of metadata be maintained.

 

This webinar will provide an insight into the basic structure of the repository metadata and preserving its integrity. It will explain the locking mechanism at the level of the repository, along with migration methods and best practices for the same.

 

Below is the high level agenda for this Webinar.

 

  • Basic Repository Structure
  • Repository Client level locking
  • Repository Migration – Export/Import
  • Repository Migration – Deployment
  • Repository Migration – Best Practices

 

About the speaker

 

Vasudha Raghunathan is a Senior Product Specialist in GCS. She is a subject matter expert in the repository and has been handling customer issues in the Advance Product Support team for the past 6 years.

-----------------------------------------------------------------------------------------------------------------

 

If you have any issues registering for the Webinar, please feel free to contact praman  or Vidya and we will be glad to help.


Informatica Support Webinars are a monthly initiative from the Global Support Organization, where a Subject Matter expert will be presenting a webinar on a particular product.

 

You can also suggest the topics of interest and we shall try to get a webinar arranged on the same.

 

Regards,

MySupport Portal Team

KB Articles

 

  1. HOW TO: Convert a hexadecimal ASCII value into an integer in a Data Transformation project (107298)
  2. The rule "PC_OW1 Running workflow missed schedule by 3 minutes" is repeatedly firing for a particular scheduled workflow (146762)
  3. HOW TO: Configure the keystore with certificates from a CA like Verisign, Thawte (16553)
  4. FAQ: What are the recommendations for Data Discovery Performance? (135917)
  5. Could not connect to ODBC. ODBC returns ...Remote Database Not Found: <Data-baseName> when connecting to DB2 UDB source through ODBC drivers in Data Explorer (107749)
  6. HOW TO: Mask the columns in different tables based on string pattern using a single rule with Dynamic Data Masking (124436)
  7. ERROR: "[LDTMCMN_0029] message [RR_4035 SQL Error [ORA-01438: value larger than specified precision allowed for this column]" when running data viewer against a SQL data service in 9.5.1 Developer client fails (147352)
  8. Unable to create contents for the "Human Task" database in Informatica 9.5.1 HotFix1 (148995)
  9. DVO jobs or workflow sessions crash when running on PowerCenter that runs on Linux 6.x (147576)
  10. ERROR: “Select * from tablename_ext failed. Msg:ERROR: value too long for type character varying(10)” when performing a data streaming from Oracle to GreenPlum in Informatica Fast Clone (139916)
  11. HOW TO: Convert certain data for specific columns according to user requirements in IDR 9.5 (151006)
  12. Environment Variables used in IIR/MDM-RE/DCE/SSA-NAME3 (138621)
  13. FAQ: Does substitution with repeatable masking output uses the storage table? (135058)
  14. Cloning/Copying/Moving/Relocating/Migrating an ORS and CMX_SYSTEM from one database to another (119017)
  15. [DOM_10079] Cannot start service [my_metadata_manager_service] on any node specified for the service. Check the service log and resolve any error listed for the service when Metadata Manager is unable to start on Informatica 9.1.x (136201)
  16. ERROR: "Unable to load DLL: pmsapr3plg.dll for plugin PC_SAPR3" when registering SAP plug-ins to local client (118478)
  17. HOW TO: Generate a CSM file and upload it to My Support using the Informatica Administrator (Administration Console) (106522)
  18. ERROR: Failed to Load DLL: pmsapr3plg.dll for Plug-in: PC_BAPI, vendor Informatica %1 is not a valid Win32 application. After upgrading PowerCenter client from 8.6.1 to 9.0.1 (119869)
  19. Knowledge Link: Ultra Messaging Knowledge Base (147259)
  20. HOW TO: Access MetaQuery in Support Console (134888)

 

Videos

 

  1. REST API on Informatica Cloud
  2. Introduction to Informatica Global Support for AddressDoctor Customers
  3. PowerCenter - Web Service Consumer Transformation
  4. How To Read Write from to HDFS
  5. Auditing functionality in MDM
  6. How to create Multiple Mappings using a Visio template
  7. Extract Data from a Web Site using DataSift - H2L video
  8. Registering a secure agent on Informatica Cloud
  9. Operating System Profiles in PowerCenter
  10. String Concatenation in PowerCenter

 

How-to-Libraries

 

  1. PowerCenter Product Changes from 8.6.1 to 9.5.1
  2. PowerCenter Repository Maintenance
  3. How to Use PowerCenter with Teradata to Load or Unload Data
  4. Using SequeLink to Access Data
  5. Running a Workflow on a PowerCenter Grid
  6. How to Achieve Greater Availability in Enterprise Data Integration Systems
  7. Using LDAP Authentication in a PowerCenter Domain
  8. Team-Based Development  FAQs
  9. Migrating A Repository to Another Database
  10. Using Workflow Parameters and Variables to Write to a Dynamic Target File

Dear Informatica Customers,


We are delighted to announce the next of the Webinar series, Integration Service on Grid on 21st November 2013 from 8 AM to 9 AM (PST).

 

Registrations for the Webinar are now open and the URL to register is:

https://informatica.webex.com/informatica/j.php?ED=256115727&RG=1&UID=0&RT=MiM0   (Join as Participant)

 

Alternatively,

 

 

--------------------------------------------------------------------------------------------------------

More details are available below:

 

Informatica PowerCenter has a feature to run the Integration Service on a Grid. This helps to leverage multiple nodes that are part of a domain and to distribute the load to different nodes to get better performance/scalability. This webinar will be focusing on working of Integration Service on Grid, required license etc. We will also discuss about Load Balancer, which is a key component that takes care of dispatching the job to different nodes, depending on various factors like the system resources, CPU and other criteria. The session also covers few advanced aspects of troubleshooting like analyzing the Load Balancer agent logs to understand why a particular node was chosen against others for a job to be dispatched.

 

Below is the high level agenda for this Webinar.

 

  • Licensing requirements for Grid                                         
  • Load Balancer
  • Workflow on Grid           
  • Session on Grid            
  • Demo                 
  • Use Cases
  • Q&A

 

About the speaker:

 

Sivachandran S is a Support Engineer with 2 years of experience handling customer issues in PowerCenter, Web Services and Data Quality. He has helped resolve many critical issues for our customers and has been appreciated by a lot of customers for his exceptional trouble-shooting skills.

-----------------------------------------------------------------------------------------------------

If you have any issues registering for the Webinar, please feel free to contact praman or Vidya and we will be glad to help.


Informatica Support Webinars are a monthly initiative from the Global Support Organization, where a Subject Matter expert will be presenting a webinar on a particular product.

 

You can also suggest the topics of interest and we shall try to get a webinar arranged on the same.

 

Regards,

MySupport Portal Team

Hall of Fame

Posted by Vidya Oct 30, 2013

TOP CONTRIBUTORS FOR Q3

 

yagrawal

 

In Yogesh's Words:

 

I am very happy to be amongst the top contributor for the third time! I have been actively using My Support portal to gain a lot of knowledge and expertise in Informatica platform products.  At InfoCepts I have been working on Informatica platform products like PowerCenter, DataServices, Informatica cloud and many others.This site provides all the knowledge related to Informatica under one roof- we have KB articles, PAM, product documents, support videos and many other things which solves our problems instantly.

 

Informatica Marketplace is one of the best thing provided by Informatica to get ready made solution for most of the data integration scenarios.

I would like to thank Informatica team for providing such a fantastic platform to the Informatica community members I encourage everyone to share their knowledge and help make My Support a vibrant collaboration platform.

 

I would like to recognize nheinze from support moderators. He is one of the active moderators and always provides to the point and very useful information.

 

smamidala

 

In Sridhar's Words:

 

It feels great to be recognized as one of the top contributors. Informatica deserves appreciation for identifying and acknowledging such individuals. This really boosts the enthusiasm/confidence. To me, Informatica My Support forum is a tremendous platform for KNOWLEDGE SHARING. Posts, Knowledge base articles, Product documents, Velocity and upgrade planner, etc. all find due diligence here. This provides enormous learning to contributors and readers alike when they share their experiences on issues faced while working on Informatica. At times I replicate user issues to address them which helps not only in shedding light on areas that I haven't worked on but also enhances existing Informatica skills.

 

deepak07

 

In Deepak's words

 

I am using My Support portal for last 2 years. To me it is one of the best versatile integrated platform where anyone can get ample solutions provided by Informatica experts. There are ample number of KBs, multimedi and e-learning available in the site which is truly beneficial for the Informatica users.

 

I would like to recognize nheinze, as his view and answer are being perfectly matching the people’s solution. I would like to appreciate Informatica Support team for all hard work done and congratulate on its successful journey so far. Keep doing good work and spreading knowledge around the world!!!

KB Articles

 

  1. ERROR: "pmudt_50033: [FATAL] Service Info not found for the service" when session with UDT fails (149023)
  2. HOW TO: Disable event logging in B2B Data Transformation Accelerator (DTA)(118253)
  3. HOW TO: Reconnect RulePoint and RTAM automatically to their database server after a connectivity loss  (145512)
  4. "Select a valid application server. The installation directory does not contain a JBoss Application Server instance when upgrading from DataAnalyzer 8.1.1 or Metadata Manager 8.1.1 to a DataAnalyzer 8.1.1 SP3 or Metadata Manager 8.1.1 SP3 (22269)
  5. Analyst Service fails to start after applying Informatica 9.5.1 HotFix 2 to Informatica 9.5.1 or 9.5.1 HotFix 1 (151448)
  6. FAQ: Can we establish multiple connections at the same time to the same user id in IDR 9.5? (146193)
  7. FAQ: Data Services (110165)
  8. HOW TO: Enable auditing for data discovery access  (141515)
  9. "Could not connect to ODBC. ODBC returns ...Remote Database Not Found: <Data-baseName>" when connecting to DB2 UDB source through ODBC drivers in Data Explorer (107749)
  10. ERROR: "com.informatica.powercenter.sdk.mapfwk.exception.RepoOperationException: The following errors occurred while executing the list objects command:" while importing the source and target metadata in DVO (119082)
  11. IIR Synchronizer does not synchronize records when started separately for multiple IDTs in IIR 9.5 HotFix 1 (148797)
  12. Startup issue when starting TDM server in TDM 9.5.1 or 9.5.2 (149465)
  13. Cloning/Copying/Moving/Relocating/Migrating an ORS and CMX_SYSTEM from one database to another (119017)
  14. ERROR: "DOM_10079 : Cannot start service [mm_svc] on any node specified for the service. Check the service log and resolve any error listed for the service. Then restart the service." while starting the Metadata Manager service in 9.1.x (148263)
  15. ERROR: "WRT_8165 TIMEOUT BASED COMMIT POINT" in session log in PowerCenter (138428)
  16. REP_12400 : Repository Error (Can't find attribute with id: 6.) when running a BW extraction session (146878)
  17. PWX-00752 DTLREXE Startup Error <Failed Client Connect RCs=1217/5/-1>." when running PowerExchange dtlrexe ping command (150275)
  18. HOW TO: Configure Reporting and Dashboard Service on an Existing Database User (146036)
  19. HOW TO: Use MetaQuery in Support Console to extract information related to Object level property from PowerCenter Repository (134902)
  20. Knowledge Link: UM Objects (150675)

 

Videos

 

  1. Finding performance bottlenecks from PowerCenter session log
  2. Mtools - Tools for Testing Multicast Connectivity
  3. How to automate the repository and domain back up process for disaster recovery in PowerCenter
  4. Push Down Optimization in PowerCenter
  5. Using LDAP Authentication in an Informatica Domain
  6. Post Session Emails On Linux/ Unix
  7. Pass Through Ports - XML and Web Services
  8. Data Quality Content Installation
  9. How to mask data for specific users using Dynamic Data Masking tool
  10. How to configure node heartbeat intervals for internal health check of Informatica nodes and domain

 

How-to-Libraries

 

  1. PowerCenter Product Changes from 8.6.1 to 9.5.1
  2. Running a Workflow on a PowerCenter Grid
  3. How to Use PowerCenter with Teradata to Load or Unload Data
  4. PowerCenter Repository Maintenance
  5. How to Use PowerCenter Web Services to Extend the Power of Data Integration
  6. Calling a Web Service from a Web Service Consumer Transformation in Informatica Developer
  7. Code Page Settings and Performance Settings for the Data Validation Option
  8. Using SequeLink to Access Data
  9. Upgrading PowerCenter 8.1.1 to Informatica 9.1.0 HotFix 3 Using the Command Line
  10. Informatica Data Explorer Sizing Guidelines

Dear Informatica Customers,

 

We are delighted to announce the next of the Webinar series, Harnessing Social Media Data with Informatica on 26th September 2013 from 8 AM to 9AM (PST).


 

Registrations for the Webinar are now open and the URL to register is

 

https://informatica.webex.com/informatica/j.php?ED=195639568&RG=1&UID=1432984228&RT=MiM0MQ%3D%3D   (Join as Participant)

 

Alternatively,

 

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

More details are available below:

 

The topic focuses on how to harness the social media data with the help of Informatica

 

Agenda includes:

 

  • Informatica Connectivity to Social media connectors (Facebook, Twitter, LinkedIn)
  • Informatica Connectivity for Datasift
  • Connector benefits
  • Why Informatica connector for social media and datasift

 

About the Speaker

 

Vishnupriya Krishnamurthy is a Lead Support Engineer with over 6 years of experience in helping Informatica customers to integrate and unleash the potential of data.

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

 

If you have any issues registering for the Webinar, please feel free to contact Pattabhi at praman@informatica.com and he should be able to help.

 

InfaSupport Webinars are a monthly initiative from the Global Support Organization, where a Subject Matter expert will be presenting a webinar on a particular product.

 

Please do let us know if you have any topics of interest and we shall try to get a webinar arranged on the same.

 

Regards,

MySupport Portal Team

KB Articles


  1. “[R303672] JAVA error in preProcessor: Failed to call a method. Java exception message” while running a parser that uses ExcelToXml pre-processor (106294)
  2. Last Error Code and Error Message are empty in the body of the Completed Sessions Alerts (149634)
  3. HOW TO: Configure the keystore with certificates from a CA like Verisign, Thawte (16553)
  4. HOW TO: Change the File Archive Root/data directory location in RainStor FAS (147495)
  5. Knowledge Link: Informatica Data Explorer Installation and Configuration (109266)
  6. Unable to create contents for the "Human Task" database in Informatica 9.5.1 HotFix1 (148995)
  7. A mapping using a Sorter transformation fails with I/O error (147441)
  8. HOW TO: Use the command line tools of Data Validation Option like DVOCmd (119055)
  9. ERROR: “Cannot connect to DDM server,port” while connecting to SQLserver management studio (142798)
  10. FAQ: Is there a way to enable direct-path insert for Audit apply for Oracle database (compressed tables)? (140187)
  11. HOW TO: Run the CSM Client for IIR (123709)
  12. Executing workflow from TDM UI does not initiate the workflow execution in TDM 9.5.1 (146826)
  13. Informatica MDM Performance Foundation Guide (146176)
  14. ERROR: "DOM_10079 : Cannot start service [mm_svc] on any node specified for the service. Check the service log and resolve any error listed for the service. Then restart the service." while starting the Metadata Manager service in 9.1.x (148263)
  15. Implementating PowerExchange CDC for Oracle (115774)
  16. ERROR: "WRT_8165 TIMEOUT BASED COMMIT POINT" in session log in PowerCenter (138428)
  17. HOW TO: Configure PowerExchange for JMS with IBM WebSphere MQ (113581)
  18. Reporting Service fails to start and shows DOM_10079 error message in the console (141392)
  19. HOW TO: Use MetaQuery in Support Console to extract information related to Object level property from PowerCenter Repository (134902)
  20. Knowledge Link: Ultra Messaging Knowledge Base (147259)

 

 

How-to-Libraries

 

  1. Running a Workflow on a PowerCenter Grid
  2. PowerCenter Repository Maintenance
  3. Informatica Port Administration
  4. Configuring PowerCenter Resilience
  5. How to Use PowerCenter Web Services to Extend the Power of Data Integration
  6. How to Use PowerCenter with Teradata to Load or Unload Data
  7. Team-Based Development FAQs
  8. Upgrading PowerCenter 8.1.1 to Informatica 9.1.0 HotFix 3 Using the Command Line
  9. Comparison of the High Availability and Grid Options
  10. Using Workflow Parameters and Variables to Write to a Dynamic Target File

 

Videos

 

  1. Upgrading PowerCenter 8 Repository while keeping the Original
  2. How to configure Email Alerts in Informatica Domain
  3. How to Register Salesforce plug-in in PowerCenter
  4. How to override the default Login Timeout for PWX for Netezza
  5. Getting started on Data profiling
  6. INFASupport Webinar recording *Introduction to Informatica MDM Hub and basic troubleshooting*
  7. How to install MMagent for Metadata Manager
  8. Informatica - Generate User Groups Report
  9. Push Down Optimization in PowerCenter
  10. How to Integrate PowerCenter with B2B Data Transformation

 

Thank you all for attending the third INFASupport Webinar that was hosted on 07/25/2013 .The webinar on "PowerCenter Connectivity to Data Warehouse Appliances" was brought to you by Informatica Global Customer Support.

 

The recording of the Webinar can be viewed at : http://www.youtube.com/watch?v=JXPdkCQh-ew&list=PLmi6HWWEAjKqrbjpMUbln3qS5IYZcCWbS&index=1

or through Support TV on Informatica MySupport portal.

 

---------------------------------------------------------------------------------------------------------

 

Topic: PowerCenter Connectivity to Data Warehouse Appliance

 

Over the years, enterprise data has been stored in disparate silos and for several of the data sources. These data sources contain legacy information that may be valuable and which will need to be included as part of the overall business intelligence and analytics process. For PowerCenter to integrate with such data warehouse appliances there is a need for adapters. Some key features provided by our adapters are:

 

  • Lower development costs by supporting rapid impact assessment and deployment as changes arise, through automated metadata capture
  • Prevent unauthorized access to sensitive data by accessing data directly, rather than extracting files and transferring them to less-secure environments
  • Maximize return on investments by supporting rapid access to standards-based sources and targets, enhancing business agility

 

Agenda for this session includes:


  • Need for Data ware house appliances and Rainbow of options in PowerCenter
  • Achieve high performance with PowerExchange GreenPlum
  • Bulk loading capabilities with PowerExchange Netezza
  • Simply data loading process with PowerExchange for TPT
  • Troubleshooting Guidelines
  • Q & A

 

 

About the Speaker

 

Prashanth Keshva is a Lead SME with over Seven years of experience in helping Informatica customers as support Engineering.  He is currently the team lead of APAC Support team.

-----------------------------------------------------------------------------------------------------------------------------------------------

 

This Webinar series is a monthly initiative from the Informatica Support, where Subject matter experts will be presenting on different products from a support perspective.

 

You can log on to our Support portal https://mysupport.informatica.com or follow us on twitter at https://twitter.com/INFAsupport for more details about the next topics lined up for the coming months.

 

All those who attended the Webinar, we request you to give your feedback through our Poll at: https://communities.informatica.com/polls/1038

 

 

Regards,

MySupport Portal Team

KBs

  1. B2B Data Transformation standalone installation does not open after installing 9.5.1 HotFix 1 (148481)
  2. "Unable to create repository service with error PowerCenter Repository User is not valid” when adding repository service in PMPC 2.5 console in CEP (147077)
  3. HOW TO: Configure the keystore with certificates from a CA like Verisign, Thawte (16553)
  4. HOW TO: Look for the archived data in FAS through Data Discovery menu in ILM (147136)
  5. Knowledge Link: Informatica Data Explorer Installation and Configuration (109266)
  6. Unable to create contents for the "Human Task" database in Informatica 9.5.1 HotFix1 (148995)
  7. HOW TO: Configure a custom connection string when connecting to Greenplum, Vertica and PostgreSQL? (138189)
  8. FAQ: Data Services (110165)
  9. PowerCenter repository folder does not refresh sources and targets in DVO (138747)
  10. Error "ssacs_Spawn: spawned program 'D:\\InformaticaIR\\bin\\idsinit' failed" when trying to connect to IIR Console Client in the Admin mode (108471)
  11. ERROR: "cannot create the connection to the PowerCenter repository. Verify that the user account has permission to access the repository and restart the PowerCenter Repository Service" when importing connection in TDM 9.5.1 (148103)
  12. Informatica MDM Performance Foundation Guide (146176)
  13. HOW TO: Load Custom Metadata using Custom Metadata Configurator in Metadata Manager 9.0.1 (115527)
  14. ERROR: "WRT_8165 TIMEOUT BASED COMMIT POINT" in session log in PowerCenter (138428)
  15. Data connectivity using PowerExchange for SAP NetWeaver (15633)
  16. ERROR: "Model Repository Service used to store historical data is unavailable. Please contact the Administrator" in Informatica 9.x Administrator (120739)
  17. Implementating PowerExchange CDC for Oracle (115774)
  18. HOW TO: Configure Reporting and Dashboard Service on an Existing Database User (146036)
  19. HOW TO: Generate Informatica Support Console license (119559)
  20. HOW TO: Setup Wireshark to display LBM packets (138613)

 

 

How-to-Libraries

  1. Using PowerCenter to Process Flat Files in Real Time
  2. PowerCenter Repository Maintenance
  3. Informatica 9.5.1 Supported Upgrade Paths
  4. How to Use PowerCenter Web Services to Extend the Power of Data Integration
  5. Running a Workflow on a PowerCenter Grid
  6. How to Audit User Activity in Informatica Administrator
  7. How to Use PowerCenter with Teradata to Load or Unload Data
  8. Using PowerCenter as a RESTful Web Service Client
  9. How to Achieve Greater Availability in Enterprise Data Integration Systems
  10. Upgrading PowerCenter 8.1.1 to Informatica 9.1.0 HotFix 3 Using the Command Line

 

Videos

 

  1. Aggregate Data - H2L video
  2. How to automate the repository and domain back up process for disaster recovery in PowerCenter
  3. Steps to cleanup Tomcat cache to launch Administrator Console
  4. Parameterize Connections - H2L video
  5. How to enable PowerCenter session to collect performance data
  6. GRID implementation in PowerCenter
  7. Creating Web Service in Data Services 9.5
  8. Data Integration using ABAP in PowerExchange for SAP Netweaver
  9. Using LDAP Authentication in an Informatica Domain
  10. SAP configuration and connection type

Top Contributors of Q2 2013

Posted by Vidya Jul 17, 2013

myinfa_banner_Top Contributors.jpg

 

Srikanth Vishnuvajhala

 

In Srikanth's Words

 

My association with Informatica started back in 2003 when I first started using the Informatica tool as a replacement for a lengthy PL/SQL procedures designed to perform the ETL tasks and the conversion was an instant success. Over the years, Informatica has been shaped up pretty well aligning with the current market trends and has now been emerged as a market leader in Data Integration software.

 

Personally I feel Informatica’s MySupport portal is truly the best support portal offered by a Data Integration Software Company. Support portal homepage was very well organized and is divided into different sections to facilitate the users to navigate quickly without much of an effort. Some of the sections where I visit the most are:

 

    • Discussions
    • Velocity
    • KB Section
    • Product Documents
    • Best Practices/Implementation

 

I am happy to be part of the Informatica MySupport online community and it has been a pleasure to interact with fellow community members in terms of sharing the knowledge and participating in technical discussions.

 

I take this opportunity to congratulate Informatica for providing an informative and feature rich support portal where it benefits both novice and experts in gaining the knowledge and sharpen their skills. The support website is truly a worldwide effort and yet without Informatica’s desire and hard work to make it a reality, it would have never happened.

 


Yogesh Agrawal

 

In Yogesh's Words

 

I have been actively using the My Support portal since last year and to say my experience has been good.

At InfoCepts I have been working on Informatica platform products like PowerCenter, DataServices, Informatica cloud and many others.

 

During this period, not only, I have shared my knowledge, but also gained knowledge interacting with the experts in the line.

 

I still feel and I know that I have a long way to go to become an "Overall Expert" in Informatica.

I like the "One Stop Solution Shop" (My Support) provided by Informatica mainly because I get to know what's happening in different projects in different parts of the world and try to apply my knowledge wherever I can. Informatica Marketplace is one of the best thing provided by Informatica to get ready made solution for most of the data integration scenarios.

 

I would like to thank Informatica team for providing such a fantastic platform to the Informatica community members !!.

 

Venkat Nallamothu

 

In Venkat's Words

 

Informatica Support portal  helps  bring everything together to help them get their work done.

You can better connect employees across different geographies, and enable them to find subject matter experts quickly and share best practices. And, you can empower employees to drive decision making by helping teams project, build accord, and make decisions.

 

 

To Learn more details about the Top Contributor program, refer to the blog post here .

 

We strongly encourage users who ask questions to return to the  forums and hand out reward points to the most helpful users.

 

Regards,

MySupport Portal Team

Dear Informatica Customers,

 

We are delighted to announce the next of the Webinar series,  PowerCenter Connectivity to Data Warehouse Appliances on 25th July 2013 from 8 AM to 9AM (PST) .

 

Registrations for the Webinar are now open and the URL to register is

 

https://informatica.webex.com/informatica/j.php?ED=242957637&RG=1&UID=0&RT=MiM0  (Join as Participant)

 

Alternatively,

 

 

-----------------------------------------------------------------------------------------------------------------------------------------------

More details are available below:

 

Over the years, enterprise data has been stored in disparate silos and for several of the data sources. These data sources contain legacy information that may be valuable and which will need to be included as part of the overall business intelligence and analytics process. For PowerCenter to integrate with such data warehouse appliances there is a need for adapters. Some key features provided by our adapters are:

 

  • Lower development costs by supporting rapid impact assessment and deployment as changes arise, through automated metadata capture
  • Prevent unauthorized access to sensitive data by accessing data directly, rather than extracting files and transferring them to less-secure environments
  • Maximize return on investments by supporting rapid access to standards-based sources and targets, enhancing business agility

 

Agenda for this session includes:

 

  • Need for Data ware house appliances and Rainbow of options in PowerCenter
  • Achieve high performance with PowerExchange GreenPlum
  • Bulk loading capabilities with PowerExchange Netezza
  • Simply data loading process with PowerExchange for TPT
  • Troubleshooting Guidelines
  • Q & A

 

 

About the Speaker

 

Prashanth Keshva is a Lead SME with over Seven years of experience in helping Informatica customers as support Engineering.  He is currently the team lead of APAC Support team.

-----------------------------------------------------------------------------------------------------------------------------------------------

 

 

If you have any issues registering for the Webinar, please feel free to contact Pattabhi at praman@informatica.com and he will be glad to help.

 

InfaSupport Webinars are a monthly initiative from the Global Support Organization, where a Subject Matter expert will be presenting a webinar on a particular product.

 

Please do let us know if you have any topics of interest and we shall try to get a webinar arranged on the same.

 

Regards,

MySupport Portal Team

KB Articles

 

  1. HOW TO: Convert XML / Text files to PDF using B2B Data Transformation (128387)
  2. ERROR: "java.lang.NoClassDefFoundError: Could not initialize class" when PowerCenter workflow control response is invoked (139904)
  3. HOW TO: Configure the keystore with certificates from a CA like Verisign, Thawte (16553)
  4. HOW TO: Add user-specified hints to the SELECT clause of 'copy to staging' and 'copy to destination' insert statements in Data Archive for Oracle (140889)
  5. Knowledge Link: Informatica Data Explorer Installation and Configuration (109266)
  6. ERROR: "MyOtlStream::checkRowCountAsExpected() expected rows: 1 actual rows: 0" while running Applier process in IDR 9.5 (146136)
  7. "[ICMD_10033] Command [RestoreDomain] failed with error [RSVCSHARED_00021] Internal error. Failed to get a repository connection unique ID for the following reason: ['host:host']" while running RestoreDomain  (123464) 
  8. "JSDK_42001: [ERROR] Cannot get object class for : dvo/infact/PivotPluginImpl" when running a Data Validation Option test in PowerCenter (118967)
  9. Unable to create contents for the "Human Task" database in Informatica 9.5.1 HotFix1 (148995)
  10. FAQ: What is the Informatica FastClone Server? (145946)
  11. HOW TO: Run the CSM Client for IIR (123709)
  12. ERROR: "Cannot create the connection to the PowerCenter repository. Verify that the user account has permission to access the repository and restart the PowerCenter Repository Service" when importing connection in TDM 9.5.1 (148103)
  13. Informatica MDM Performance Foundation Guide (146176)
  14. Knowledge Link: Troubleshooting Guides for Metadata Manager (108405)
  15. HOW TO: Configure PowerExchange for JMS with IBM WebSphere MQ (113581)
  16. ERROR: "WRT_8165 TIMEOUT BASED COMMIT POINT" in session log in PowerCenter (138428)
  17. DB2 z/OS Change Data Capture data integrity and  stabilty issue introduced by DB2 V10 support (148595)
  18. HOW TO: Configure Reporting and Dashboard Service on an Existing Database User (146036)
  19. HOW TO: Generate Informatica Support Console license (119559)
  20. HOW TO: Interpret statistics in the UM Web Monitor (142353)

 

 

H2L

 

  1. Informatica 9.5.1 Supported Upgrade Paths
  2. Using PowerCenter to Process Flat Files in Real Time
  3. How to Achieve Greater Availability in Enterprise Data Integration Systems
  4. How to Use PowerCenter with Teradata to Load or Unload Data
  5. Running a Workflow on a PowerCenter Grid
  6. Techniques for Deployment from a Versioned Repository
  7. How to Use PowerCenter Web Services to Extend the Power of Data Integration
  8. Team-Based Development FAQs
  9. PowerCenter Repository Maintenance
  10. Calling a Web Service from a Web Service Consumer Transformation in Informatica Developer

 

Videos

 

  1. PowerCenter Express Overview - H2L video
  2. How to Use Business Glossary in Metadata Manager
  3. Parameterize Connections - H2L video
  4. Send an Email from a Workflow - H2L video
  5. MDM MultiDomain Best Practice: Effectively Managing HFs and EBF
  6. INFASupport Webinar recording *Introduction to Informatica 9.x Architecture*
  7. Steps to cleanup Tomcat cache to launch Administrator Console
  8. How to automate the repository and domain back up process for disaster recovery in PowerCenter
  9. Aggregate Data - H2L video
  10. How to import an XML source definition

    Dear Informatica Customers,

     

    We are delighted to announce the next of the Webinar series - Data Domain Discovery and Enterprise Discovery on 27th June 2013 from 8 AM to 9AM (PST) .

     

    Registrations for the Webinar are now open and the URL to register is:

     

    https://informatica.webex.com/informatica/j.php?ED=240470207&RG=1&UID=0&RT=MiM0 (Join as Participant)

     

    Alternatively,

     

     

    More details are available below:

     

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------

    Topic - Data Domain Discovery and Enterprise Discovery

     

    About Data Domain Discovery

     

    You need to identify and understand the meaning of critical source data so that you can take measures to work effectively on it. Data domain discovery is the process of discovering the functional meaning of data in the data sources based on the semantics of data.

     

    Create a profile to perform data domain discovery and you can identify critical data characteristics within an enterprise. You can then apply further data management policies, such as data quality or data masking, to the data.

     

    For example, discover product codes or descriptions to analyze which data quality standardization or parsing rules you need to apply to make the data useful and trustworthy. Another example is to find sensitive customer data, such as credit card numbers, email IDs, and phone numbers. You may then want to mask this information to protect it.

     

    You can create and run a profile to perform data domain discovery in both Analyst and Developer tools. You can define a profile to perform data domain discovery based on the following rules:

    • Data rule- Finds columns with data that matches specific logic defined in the rule.
    • Column name rule- Finds columns that match column name logic defined in the rule.

     

    About Enterprise Discovery

     

    Enterprise discovery is the process of discovering column profile statistics, data domains, primary keys, and foreign keys in a large number of data sources. You can perform enterprise discovery across multiple connections or schemas.

     

    As an enterprise data analyst, you may want to discover important data characteristics across a large number of data sources. The requirements can include identification of relational data assets, column profile runs on the discovered data assets, discovery of critical data characteristics within the enterprise, primary keys, and candidate keys. You would also want to view the foreign key relationships that exist across the data sources so that you can derive a data model based on the discovered relationships.

     

    Enterprise discovery finds issues, patterns, trends, and critical data characteristics within information assets in your enterprise. You can choose both data sources that you imported into the Model repository and data sources from external relational connections. The data discovery process includes discovering column profile statistics, data domain analysis, data object structures including candidate keys, and data object relationships that include foreign keys.

     

    You run enterprise discovery in the Developer tool and it performs the following tasks on each data source:

     

    • Run a column profile.
    • Discover data domains.
    • Infer primary keys.

     

    After running column profiles, data domain discovery, and primary key profiles, the Developer tool runs a foreign key profile across all the data sources. After the Developer tool completes profiling and discovery tasks, it generates a consolidated results summary in both graphical and tabular formats.

     

    Below are the key areas that will be covered under this topic.

     

    • Introduction to Data Domain Discovery
    • Terms and Definitions
    • Data Domain Glossary
    • Data Domains and Data Domain      Groups
    • Data Domain Rules
    • Using Data Domain Discovery
    • Introduction to Enterprise      Discovery
    • Enterprise Discovery results      visualization
    • Export of Enterprise      Discovery results to Excel
    • DDL Generation
    • Q&A

     

    About the Speaker:

     

    Sunil Adinarayana is a Lead Subject Matter Expert in Data Quality with over 5 years of experience in helping customers on PowerCenter and Data Quality product lines. He has conducted various enablement sessions for different teams across the globe in Data Quality 9x and mentored many Support engineers on the Data Quality product line.

    -------------------------------------------------------------------------------------------------------------------------------------------------------------------

     

    If you have any issues registering for the Webinar, please feel free to contact Pattabhi at praman@informatica.com and he will be glad to help.

     

    InfaSupport Webinars are a monthly initiative from the Global Support Organization, where a Subject Matter expert will be presenting a webinar on a particular product.

     

    Please do let us know if you have any topics of interest and we shall try to get a webinar arranged on the same.

     

    Regards,

    MySupport Portal Team

    Filter Blog

    By date: By tag: