What is the difference between informatica 8.x and 9.x
1. Informatica 9 supports data integration for the cloud as
well as on premise. You can integrate the data in cloud
applications, as well as run Informatica 9 on cloud
infrastructure.
2. Informatica analyst is a new tool available in Informatica 9.
3. There is architectural difference in Informatica 9
compared to previous version.
4. Browser based tool for business analyst is a new feature.
5. Data steward is a new feature.
6. Allows unified administration with a new admin console
that enables you to manage power centre and power exchange
from the same console.
7. Powerful new capabilities for data quality.
8. Single admin console for data quality, power centre,
power exchange and data services.
9. In Informatica 9, Informatica data quality (IDQ) has been
further integrated with the Informatica Platform and
performance, manageability and reusability have all been
significantly enhanced.
10. The mappings rules are shared between the browser based
tool for analysts and the eclipse based development
leveraging unified metadata underneath.
11. The data services capabilities in Informatica 9 , both
over sql and web services ,can be used for real time dash
boarding.
12. Informatica data quality provides world wide address
validation support with integrated geocoding.
13. The ability to define rules and view and run profiles is
available in both the Informatica developer (Thick client)
and Informatica analyst (browser based tool-Thin
client).these tools sit on a unified metadata
infrastructure. Both tools incorporate security features
like authentication and authorization ensuring..
14. The developer tool is now eclipse based and supports
both data integration and data quality for enhanced
productivity. It provides browser based tool for analysts to
support the types of tasks they engage in, such as profiling
data, specifying and validating rules & monitoring data quality.
15. There will a velocity methodology. Soon it’s going to
introduce on I9.
16. Informatica has the capability to pull data from IMS,
DB2 on series and series and from other several other legacy
systems (Mainframe) environment like VSAM, Datacom, and IDMS
etc.
17. There are separate tools available for different roles.
The Mapping architect for Vision tool is designed for
architects and developers to create templates for common
data integration patterns saving developer’s tremendous
amount of time.
18. Informatica 9 does not include ESB infrastructure.
19. Informatica supports open interfaces such as web
services and can integrate with other tools that support
these as well including BPM tool.
20. Informatica 9 complements existing BI architectures by
providing immediate access to data through data
virtualization, which can supplement the data in existing
data warehouse and operational data store.
21. Informatica 9 supports profiling of Mainframe data.
Leveraging the Informatica platform’s connectivity to
Mainframe sources.
22. Informatica 9 will continue support feature of running
the same workflow simultaneously.
23. Eclipse based environment is build for developers.
24. Browser based tool is a fully functional interface for
business analysts.
25. Dashboards are designed for business executives.
26. There are 3 interfaces through which these capabilities
can be accessed. Analyst tool is a browsed tool for analyst
and stewards. Developers can use the eclipse based developer
tool. Line of business managers can view data quality
scorecards.
| Is This Answer Correct ? | 5 Yes | 0 No |
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
how will you remove the duplicate records from flat file without using sorter?
Can any one describe what is audit table briefly?how does it look like and what are the columns in it?
source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ
Hey I am net to informatica? Can any one explain me step by step How scd will work ?
What are the different clients of powercenter?
What is source qualifier transformation?
What are the disadvantages of Sequence Generator T/R?
What are set operators in Oracle
How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.