1.What is Informatica B2B?
Informatica B2B Data Transformation is the best technology for extracting data from any file, document, or message and transforming it into a usable form. Informatica B2B Data Exchange is the industry-leading software for multi-enterprise data integration. It adds secured communication, management, and monitoring capabilities to handle data from internal and external sources.
2. What is the meaning of Enterprise Data Warehousing?
Enterprise Data Warehousing is the data of the organization being created or developed at a single point of access. The data is globally accessed and viewed through a single source since the server is linked to this single source. It also includes the periodic analysis of the source.
3. What is Lookup transformation?
•Lookup transformation is used to look up a source, source qualifier, or target in order to get relevant data.
•It is used to look up a ‘flat file’, ‘relational table’, ‘view’ or ‘synonym’.
•Lookup can be configured as Active or Passive as well as Connected or Unconnected transformation.
•When the mapping contains the lookup transformation, the integration service queries the lookup data and compares it with lookup input port values. One can use multiple lookup transformations in a mapping.
•The lookup transformation is created with the following type of ports:
Input port (I)
Output port (O)
Look up Ports (L)
Return Port (R)
4. What are the points of differences between connected lookup and unconnected lookup?
Connected lookup is the one that takes up the input directly from the other transformations and also participates in the data flow. On the other hand, an unconnected lookup is just the opposite. Instead of taking the input from the other transformations, it simply receives the values from the result or the function of the LKP expression. Connected Lookup cache can be both dynamic and static but unconnected Lookup cache can’t be dynamic in nature. The First one can return to multiple output ports but the latter one returns to only one output port. User-defined values which generally default values are supported in the connected lookup but are not supported in the unconnected lookup.
5. How many input parameters can be present in an unconnected lookup?
The number of parameters that can include in an unconnected lookup is numerous. However, no matter how many parameters are put, the return value would be only one. For example, parameters like column 1, column 2, column 3, and column 4 can be put in an unconnected lookup but there is only one return value.
6. Name the different lookup cache(s)?
Informatica lookups can be cached or uncached (no cache). Cached lookups can be either static or dynamic. A lookup cache can also be divided as persistent or non-persistent based on whether Informatica retains the cache even after completing session run or if it deletes it.
•Static cache
•Dynamic cache
•Persistent cache
•Shared cache
•Recache
7. Is ‘sorter’ an active or passive transformation?
It is an active transformation because it removes the duplicates from the key and consequently changes the number of rows.
8. What is the difference between active and passive transformation?
Active Transformation: An active transformation can perform any of the following actions:
•Change the number of rows that pass through the transformation: For instance, the Filter transformation is active because it removes rows that do not meet the filter condition.
•Change the transaction boundary: For e.g., the Transaction Control transformation is active because it defines a commit or roll back transaction based on an expression evaluated for each row.
•Change the row type: For e.g., the Update Strategy transformation is active because it flags rows for insert, delete, update, or reject.
Passive Transformation: A passive transformation is one which will satisfy all these conditions:
•Does not change the number of rows that pass through the transformation
•Maintains the transaction boundary
•Maintains the row type.
9.What is the difference between a data warehouse, a data mart, and a database?
Data warehouse consists of different kinds of data. A database also consists of data but however, the information or data of the database is smaller in size than the data warehouse. Data Mart also includes different sorts of data that are needed for different domains. Examples – Different dates for different sections of an organization like sales, marketing, financing, etc.
10. What is a domain?
The main organizational point sometimes undertakes all the interlinked and interconnected nodes and relationships and this is known as the domain. These links are covered mainly by one single point of the organization.
11.Mention the differences between a powerhouse and repository server?
The powerhouse server is the main governing server that helps in the integration process of various different processes among the different factors of the server’s database repository. On the other hand, the repository server ensures repository integrity, uniformity, and consistency.
12. In Informatica, how many number repositories are possible to be made?
The total figure of repositories created in Informatica mainly depends on the total amounts of the ports of the Informatica.
13.What are the advantages of a partitioned session?
A session is partitioned in order to increase and improve the efficiency and the operation of the server. It includes the solo implementation sequences in the session.
14. Define parallel processing?
Parallel processing helps in further improvement of performance under hardware power. The parallel processing is actually done by using the partitioning sessions. This partitioning option of the Power Center in Informatica increases the performance of the Power Center by parallel data processing. This allows the large data set to be divided into a smaller subset and this is also processed in order to get a good and better performance of the session.
15. What are the best mapping development practices?
The Best mapping development practices are as follows:
•Source Qualifier: This includes extracting the necessary data-keeping aside the unnecessary ones. It also includes limiting columns and rows. Shortcuts are mainly used in the source qualifier. The default query options like for example User Defined Join and Filter etc, are suitable to use other than using source qualifier query override. The latter doesn’t allow the use of partitioning possible all the time.
•Expressions: It includes the use of local variables in order to limit the number of huge calculations. Avoiding data type conversions and reducing invoking external coding is also part of an expression. Using operators is way better than using functions as numeric operations are better and faster than string operation.
•Aggregator: Filtering the data is a necessity before the Aggregation process. It is also important to use sorted input.
•Filter: The data needs a filter transformation and it is a necessity to be close to the source. Sometimes, multiple filters are also needed to be used which can also be later replied by a router.
•Joiner: The data is required to be joined in the Source Qualifier as it is important to do so. It is also important to avoid the outer joins. A fewer rows is much more efficient to be used as a Master Source.
•Lookup: Here, joins replace the large lookup tables and the database is reviewed. Also, database indexes are added to columns. Lookups should only return those ports that meet a particular condition.
16. What are the different mapping design tips for Informatica?
The different mapping design tips are as follows:
•Standards: The design should be of a good standard. Following a standard consistently is proven to be beneficial in the long run projects. Standards include naming descriptions, conventions, environmental settings, documentation and parameter files, etc.
•Reusability: Using reusable transformation is the best way to react to the potential changes as quickly as possible. applets and worklets, these types of Informatica components are best suited to be used.
•Scalability: It is important to scale while designing. In the development of mappings, the volume must be correct.
•Simplicity: It is always better to create different mappings instead of creating one complex mapping. It is all about creating a simple and logical process of design
•Modularity: This includes reprocessing and using modular techniques for designing.
17.What is the meaning of the word ‘session’? Give an explanation of how to combine execution with the assistance of batches?
Converting data from a source to a target is generally implemented by a teaching service and this is known as a session. Usually, the session manager executes the session. In order to combine session’s executions, batches are used in two ways – serially or parallelly.
18. Differentiate between mapping parameter and mapping variable?
Mapping variable refers to the changing values of the sessions’ execution. On the other hand, when the value doesn’t change during the session then it is called mapping parameters. The mapping procedure explains the procedure of the mapping parameters and the usage of this parameter. Values are best allocated before the beginning of the session to these mapping parameters.
19. What are the features of complex mapping?
These are the three most important features of complex mapping.
•Difficult requirements
•Numerous transformations
•Complex logic regarding business
20. Which option helps in finding whether the mapping is correct or not?
The debugging option helps in judging whether the mapping is correct or not without really connecting to the session.
21. What do you mean by OLAP?
OLAP or also known as On-Line Analytical Processing is the method with the assistance of which multi-dimensional analysis occurs.
22. What is the meaning of the surrogate key?
The surrogate key is just the replacement in the place of the prime key. The latter is natural in nature. This is a different type of identity for each consisting of different data.
23.What is workflow? How many tools are there in a workflow manager?
The workflow includes a set of instructions that allows the server to communicate for the implementation of tasks. There are four types of tools:
•Task Designer
•Task Developer
•Workflow Designer
•Worklet Designer
24. Define target load order?
Target load order is dependent on the source qualifiers in a mapping. Generally, multiple source qualifiers are linked to a target load order.
25. Name the scenario in which the Informatica server rejects files?
When the server faces rejection of the update strategy transformation, it regrets files. The database consisting of the information and data also gets disrupted. This is a rare case scenario.
26. How to use Normalizer Transformation in Informatica?
•This is of type an Active T/R which reads the data from COBOL files and VSAM sources (virtual storage access method)
•Normalizer T/R acts like a source Qualifier T/R while reading the data from COBOL files.
•Use Normalizer T/R that converts each input record into multiple output records. This is known as Data pivoting.
27. Can you tell what types of groups does router transformation contain?
Router transformation contains the following types of transformations:
1.Input group
2.Output group: Further, the output group contains two types:
•User-defined groups
•Default group
28. Is it possible to store previous session logs in Informatica?
