Joiner Transformation
Sep 08, 2023 - By Admin-LisaJoiner Transformation The Joiner transformation is used to join source data from two related heterogeneous sources that has placed in different locations. User can join data from the same source also. The use Joiner transformation sources should have...
What are the main scenarios validated with ORS disabled in the Hub Console?
Sep 08, 2023 - By Admin-LisaWhat are the main scenarios validated with ORS disabled in the Hub Console?Can users use passwords to connect to ORS in SSMS tools? - Customers should contact their DBA teamLog in to the JBoss console and test if the data source connection was succes...
What are the differences between the informatica MDM features of Oracle, SqlServer and DB2?
Sep 04, 2023 - By Admin-LisaWhat are the differences between the informatica MDM features of Oracle, SqlServer and DB2?In master data management (MDM), there is a difference in how databases work on the database side.In Oracle, an empty string (") is treated as a NULL value, bu...
Informatica MDM Certification Dump
Aug 26, 2023 - By Admin-LisaQuestion: The Lookup for Foreign Key columns capability maintains referential integrity for records when they are loaded into a base object.A. TrueB. FalseCorrect Answer: B2. Which statement best describes the key width?A. It can be any user-defined...
What do you mean by informatica MDM Server Cache?
Aug 26, 2023 - By Admin-LisaWhat do you mean by informatica MDM Server Cache?The ServerCache contains almost everything defined in the REPOS table, plus other items to improve performance, such as SearchTokens for storing pagination state for the Search API. Commonly used metad...
What are different types of tasks available in informatica Power Centre?
Aug 26, 2023 - By Admin-LisaWhat are different types of tasks available in informatica Power Centre?Assignment Task: Value is assigned to a workflow variable by Assignment task type.Command Task: It executes a shell command during the time of workflow execution.Control Task: Co...
How to debug when Elastic Search returns no results for one business entity while it works fine for other business entities in MDM?
Aug 26, 2023 - By Admin-LisaHow to debug when Elastic Search returns no results for one business entity while it works fine for other business entities in MDM?To resolve this issue associated with MDM elastic search, check the deployment tool configuration and database data.In...
Why is the Edit Connection URL option for database connections disabled in the informatica Master Data Management (MDM) Hub Console?
Aug 26, 2023 - By Admin-LisaWhy is the Edit Connection URL option for database connections disabled in the informatica Master Data Management (MDM) Hub Console?The MDM Hub Console does not allow users to update the connection URL and edit the JDBC string.This happens when the u...
Types of ETL Testing and ETL Test Scenarios with Test Cases
Aug 26, 2023 - By Admin-LisaTypes of ETL TestingProduction Validation Testing: Table balancing or production reconciliation - This type of ETL testing is performed on the data as it moves into the production system. Data in production systems must be in the correct order to sup...
What is the process of ETL Testing?
Aug 26, 2023 - By Admin-LisaWhat is the process of ETL Testing? Business and Requirement GatheringTest Planning and EstimationDesigning Test Cases and Test Data PreparationText Execution with Bug reporting and closureSummary Report and Result AnalysisTest Closure Analyse Busine...