Informatica PowerCenter Interview Question and Answer Part 5
Mar 13, 2024 - By Admin-LisaQuestion: What 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.Contro...
Informatica PowerCenter Interview Question and Answer Part 4
Mar 13, 2024 - By Admin-LisaQuestion: Design a mapping with expression to load the first 5 rows from a flat file into a target in Informatica Powercenter?Step1. Assign row number to each record.Step2. Generate row number using expression or by using sequence generator.Step3. N...
Informatica PowerCenter Interview Question and Answer Part 3
Mar 13, 2024 - By Admin-LisaQuestion: What is UNION Transformation in Informatica Powercenter?Union Transformation is an active transformation. It merges data which is coming from multiple sources either from homogenous or from heterogeneous. It merges data in vertical roe by r...
Informatica MDM Interview Question and Answer Part 4
Mar 13, 2024 - By Admin-LisaQuestion: What do you mean by delta detection in Informatica MDM? What is the process of enabling delta detection?Delta detection is used to detect new inserts and update existing source datasets in a complete data load process. Delta detection is do...
Informatica MDM Interview Question and Answer Part 3
Mar 13, 2024 - By Admin-LisaQuestion: What do you mean by the parallel degree of data loading properties in informatica MDM?In Informatica MDM, Parallel degree of data loading properties specifies that the degree of parallelism set on the base object table and its related table...
Informatica MDM Cloud SaaS Top15 Interview questions and answers
Feb 29, 2024 - By Support@InventModel.comQuestion1:Which tools provided by Informatica Intelligent Cloud that can satisfy your master datmanagement business needs? Answer:•Projects•Assets•Explore page Question2:What is Business360 ? Answer:This tool is used to do all development and config...
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...