Tuesday 16 September 2014

Informativca 9.6 features

Compare these PowerCenter Enterprise editions to select the one that’s right for you.
StandardAdvancedPremiumReal TimeBig Data
(requires Standard, Advanced,
or Premium Edition as a base)
Hadoop-based Data Integration            
Unstructured File Parsing            
Natural Language Processing            
Real Time Connectivity            
Web Services            
Monitoring and Alerting            
  • Operational uptime
            
  • Enforce development best practices
            
Data Validation            
  • Unit and system testing
            
  • Check validity of operational data
            
Metadata Manager and Data Lineage         
Business Glossary         
Additional Performance and Scalability         
  • Workflow on Grid
         
  • Session on Grid
         
  • High Availability
         
  • Partitioning
         
  • Push Down Optimization
         
Team-based Development and Versioning         
Basic XML Processing      
Connectors to Data Sources      
Administration      
Basic Profiling      
Rapid Prototyping with Business/ IT Collaboration      
Batch Data Integration    
PowerCenter Enterprise forms the foundation for all your data and enterprise integration initiatives—including data governance, data migration, and enterprise data warehousing—setting the standard for high-performance enterprise data integration and quality software. It scales to support large volumes of disparate data sources and meets demands for security and performance.
  • Role-based tools support iterative business/IT collaboration and development as well as support business and department self-service
  • One-click prototype-to-production capability jumpstarts and accelerates data integration projects in the department, the enterprise, or even the Integration Competency Center (ICC)
  • Metadata-driven data integration with high-performance ETL engine, library of pre-built data transformations, and near universal connectivity
  • Rapid prototyping and data profiling instantly accesses and combines data from multiple sources to ensure requirements are met early and throughout the development process.
  • Graphical, intuitive metadata-driven views of data flows, impact analysis and lineage provide better change management and governance
  • Business-friendly user experience for authoring and managing business terms, with context-based business glossary of common business terms for enhanced business/IT collaboration
  • Support for grid computing environments with distributed processing, high availability, adaptive load balancing, dynamic partitioning
  • Specialized, high-performance pushdown of data transformation processing for optimal use of database resources
  • Rule-based early-warning system that monitors and alerts stakeholders about operational and development risks in their PowerCenter environments
  • Script-free automated, auditable, and repeatable data validation for rapid and complete ETL testing in production, development and test environments
  • Support for Hybrid IT with flexible deployment of reusable data integration logic in the department, the enterprise, or in the cloud

Tuesday 2 September 2014

Error message - ORA-01007: variable not in select list tips

Informatica level:

This error will occur when ever u have added/connected columns from SQ t/r to target but those columns are not available in the SQl over ride then session get failed because of this error.

solution:

from SQ t/r click on generate SQL and add the same query in the session level SQl override,then execuite the session.

in my case i have added more columns in the mapping level SQ t/r  to exp t/r but those columns are not added in the session level SQ over ride query because of that session get failed with this error and  i have added those new columns in the session level sql override query. session get success.



oracle level :

As far as I knew, this message can appear when:
  • The error causing ORA-01007 is in OCI, if the number of variables is greater in theSELECT clause than the number of passed variables number passed in the position parameter.
  • In SQL*Report or SQL*Forms, if you have lass values in the SELECT clause, than you specified in theINTO clause