Informatica PowerCenter Interview Question and Answer Part 2.
Dec 31, 2023 - By Admin-LisaQuestion: What are the different ways to remove duplicates in informatica power center?If source is database (DBMS), then select distinct in source Qualifier or same can be achieved by using SQL Override.Use Aggregator transformation and select all t...
Informatica MDM Interview Question and Answer Part 2
Dec 31, 2023 - By Admin-LisaQuestion: What is the tool in Informatica Master Data Management which does not require Lock?Merge manager (Write lock Not required)Data Manager (Write lock Not required)Hierarchy Manager (Write lock Not required)Audit Manager (Compose Lock Not Requi...
Informatica Powercenter Interview Question
Dec 29, 2023 - By Admin-LisaQuestion: What are the types of transformation in Informatica PowerCenter?There are two types of transformation in informatica. Active Transformation.Passive Transformation.Question: What are the properties of Active Transformation?1 In Active Transf...
Informatica MDM Interview Question
Dec 29, 2023 - By Admin-LisaQuestion: What is Immutable rowid_object?rowid_object from this source will remain same after match and merging with other data. Record can merge for this record with others but rowid_object will never change after merge; Other records can merge with...
Segment matching in Informatica MDM Online Training
Nov 04, 2023 - By Admin-LisaSegment matching in Informatica MDM online Training (Master Data Management) refers to the process of identifying and grouping similar or related data records together to form a segment or cluster. This is a crucial step in Informatica MDM to consoli...
Update Strategy Transformation in Informatica Powercenter in ETL Training
Nov 04, 2023 - By Admin-LisaInformatica PowerCenter is a popular ETL Training tool used for data integration and transformation. Transformations in PowerCenter are used to modify, cleanse, and enrich data as it moves from source to target systems. An update strategy transforma...
Best Practices for Master Data Governance Success in Informatica MDM
Oct 19, 2023 - By Admin-LisaBest Practices for Master Data Governance Success in Informatica MDMWhat is Master Data Governance?Master data governance is the application of data governance elements to a subset of data called master data. Data governance elements are documenting...
Sorter Transformation Informatica PowerCenter
Oct 19, 2023 - By Admin-LisaSorter Transformation Use the Sorter transformation to sort data in ascending or descending order according to specified sort criteria. You can configure a Sorter transformation to achieve case-sensitive sorting and unique output. Sorter transformati...
Best Practices for Mapping Design in Informatica PowerCenter
Sep 28, 2023 - By Admin-LisaSimplify Mappings.Keep your assignments as simple as possible.Smaller is better in terms of performance and tuning.Divide and conquer is the best strategy for achieving the fastest mapping performance.In some cases, multiple phases of work, or splitt...
Parallel degree of data loading properties in informatica MDM
Sep 28, 2023 - By Admin-LisaQuestion: What are the various loading phases in MDM?Following are the various stages in which data is stored into hub stores in a sequential process in informatica Master Data Management.1. Landing process 2. Stage process 3. Loa...