What are the different types of repositories created using Informatica?
Informatica uses Repository manager to manage the upgrades and updates of the complete software system.
The repositories contained by the Informatica are as follows:
Standalone Repository: this is a repository that includes all the individual functions and that is not related to the repository.
Global Repository: it provides the repository in a centralized domain and allows it to be shared across many other repositories and platforms.
The objects are shared using the global shortcuts and the domains are fixed such that easy transaction can be done.
Local Repository: this allows the repository to be given within the domain using the global repository.
Versioned Repository: this is the repository used for the local as well as global object as it allows the version control of it as well.
What do you mean by Enterprise Data Warehousing?
When the organization data is created at a single point of access it is called as enterprise data warehousing. Data can be provided with a global view to the server via a single source store. One can do periodic analysis on that same source. It gives better results but however the time required is high.
What is the difference between Router and Filter?
Router transformation provides the division of the incoming records into multiple groups using the condition mentioned, whereas Filter transformation doesn’t take care of division.
Router transformation provides mutually inclusive groups to have the same records, whereas Filter transformation used to restrict the incoming record.
Router transformation doesn’t block the incoming record, whereas Filter transformation blocks or restricts the incoming record on the condition given.
Router transformation doesn’t block the record that is being used, whereas Filter transformation doesn’t provide the default groups.
Router transformation allows the record that doesn’t match the routing conditions, whereas Filter transformations are used not to match the condition.
Explain the code page compatibility?
When data moves from one code page to another provided that both code pages have the same character sets then data loss cannot occur. All the characteristics of source page must be available in the target page. Moreover if all the characters of source page are not present in the target page then it would be a subset and data loss will definitely occur during transformation due the fact the two code pages are not compatible.
What is the use of code page?
Code page is used to encode the specify characters having the set of one or more languages at one place.
The code page is selected using the source of the data and it is used to provide reliable data sources.
Code page allow the automatic selection of the languages as soon as the page loads and the page is selected.
Code page is chosen such that the program or the application that used to specify the specific set of data.
It also describes the characters using the application that recognizes the software and allow the receiving and sending of the character data.