What is the difference between informatica 8.x and 9.x
- 1 Answers
- 12120 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
What is the difference between a router and a filter transformation?
How can repository reports be accessed without sql or other transformations?
if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
What are the basic needs to join two sources in a source qualifier?
How can you run a session without using server manager?
There are 2 files, Master and User. We need to compare 2 files and prepare a output log file which lists out missing Rolename for each UserName between Master and User file. Please find the sample data- MASTER.csv ---------- Org|Tmp_UsrID|ShortMark|Rolename ---|---------|----------|------------ AUS|0_ABC_PW |ABC PW |ABC Admin PW AUS|0_ABC_PW |ABC PW |MT Deny all GBR|0_EDT_SEC|CR Edit |Editor GBR|0_EDT_SEC|CR Edit |SEC MT103 GBR|0_EDT_SEC|CR Edit |AB User USER.csv -------- Org|UserName|ShortMark|Rolename ---|--------|---------|------------ AUS|charls |ABC PW |ABC Admin PW AUS|amudha |ABC PW |MT Deny all GBR|sandya |CR Edit |Editor GBR|sandya |CR Edit |SEC MT103 GBR|sandya |CR Edit |AB User GBR|sarkar |CR Edit |Editor GBR|sarkar |CR Edit |SEC MT103 Required Output file: --------------------- Org|Tmp_UsrID|UserName|Rolename |Code ---|---------|--------|------------|-------- AUS|0_ABC_PW |charls |ABC Admin PW|MATCH AUS|0_ABC_PW |charls |MT Deny all |MISSING AUS|0_ABC_PW |amudha |ABC Admin PW|MISSING AUS|0_ABC_PW |amudha |MT Deny all |MATCH GBR|0_EDT_SEC|sandya |Editor |MATCH GBR|0_EDT_SEC|sandya |SEC MT103 |MATCH GBR|0_EDT_SEC|sandya |AB User |MATCH GBR|0_EDT_SEC|sarkar |Editor |MATCH GBR|0_EDT_SEC|sarkar |SEC MT103 |MATCH GBR|0_EDT_SEC|sarkar |AB User |MISSING Both the files are mapped through Organization, Shor_mark. So, based on each Organization, Short_Mark, for each UserName from User.csv, we need to find the Matching and Missing Rolename. I am able to bring Matching records in the output. But really I don't find any concept or logic to achieve "MISSING" records which are present in Master and not in User.csv for each UserName. Please help out guys. Let me know if you need any more information. Note:- In User.csv file, there are n number of Organization, under which n number Shortmark comes which has n number of UserName.
How many ways a relational source definition can be updated and what are they?
what is data driven in update strategy transformation?
when will we go for unconnected lookup transformation in Informatica?
If I am having 6 flat files in data. How can you load the data at a time
if i am having 10 records in source, i want 20 records in target...how will you do it
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
Teradata 
