Autoplay
Autocomplete
Previous Lesson
Complete and Continue
IDQ Interview Questions
Questions on Data Profiling
What were the Issues in traditional data profiling?
Explain Profiling in Informatica Data Quality, who and when the data should be profiled?
Explain about Live data and Staged Data?
What is a Profile?
What is Profile Definition?
What are Profile Rules in IDQ?
Explain about Column Profiling?
Explain about compare profiles?
What types of profile statistics are performed in IDQ?
What is Enterprise Discovery Profile?
What is Join Analysis Profiling?
What is Mid-Stream Profiling?
What is Multiple Profile?
What are score cards?
Can you create score cards on physical database objects (PDO)?
What are Scorecard Thresholds?
How did you configure notifications in Scorecards?
Should the profile be present and also be run every time you run the scorecard?
Can you generate Trend Charts in Informatica?
what type of stats can be exported from profile results?
Which factors Improve Profile performance?
Reference Tables
What are Reference Tables?
How Reference Tables can be created?
Explain about different kinds of Reference Tables?
Can you change the Metadata of the Reference table created using UnManaged Editable option?
Explain about Valid column in Reference tables which are used for Data Standardization?
Can you use Reference tables created in Informatica Developer as source or target in transformations?
Can reference tables created in Analyst be used in Informatica Developer as a source?
Can Informatica Data Quality transformation support parameterized reference tables, if yes how can you configure the parameterized reference tables in the Transformations?
What are the different ways for updating Reference tables?
Can you parameterized reference tables?
Which all Data Quality transformations supports parameterized reference tables?
IDQ Developer and Informatica Analyst General Questions
What is IDQ Developer client tool?
Explain about IDQ Architecture?
What are the new features of IDQ 10.x?
Difference between PowerCenter and IDQ?
What are Projects in Developer?
Explain about Data objects in IDQ?
How to Import the metadata changes for Physical data objects happened after the Initial import of object in IDQ.
Explain about Logical Data Object (LDO)?
Explain the difference between Physical objects and Logical Data Object (LDO)?
What is a mapping?
What are Rules or Mapplets in IDQ?
How IDQ takes care of the Data Quality?
How IDQ Transformations are categorized?
Difference between Data Integration and Data Quality transformation?
What is Data Viewer?
How to limit the number of rows when you execute Data Viewer?
Can you execute Data viewer or compare profile on Write objects?
Can you join multiple tables (from the same database) in IDQ or write custom queries on multiple tables in IDQ?
Can multiple pipeline mappings be created using IDQ?
Can you specify the load order in a mapping which contains multiple targets with dependencies between each table (parent and child tables)?
Is it possible to create a mapping so that, if in future any new columns are added to any of the source tables, it should be able to detect the structure changes dynamically and able to map it to the target?
What are the different workflow objects available in IDQ?
What are the different ways of getting the status of IDQ workflows?
What is Standardization?
What is CMS (Content Management Service)?
What are the different types of reference data managed by Content Management Service?
What are the difference between Rules created in Informatica Analyst tool and Informatica Developer tool?
Can Data Quality jobs be scheduled?
Can you Parameters in SQL Override and Lookups in Informatica Data Quality?
What are tags in Informatica Developer?
What are cheat sheets in Informatica Developer?
How to see all the available connections in Informatica Data Quality Developer?
What are Execution Modes in IDQ transformations?
Explain about strategies in Data Quality Transformations?
Can I create two strategies in IDQ transformation and configure each strategy to execute with a different execution mode?
In which IDQ transformations strategies are not created?
How can you logically group the IDQ Transformations?
Explain about Character Sets in IDQ?
Which all the data quality transformations can use Character Sets?
Explain about Probabilistic models in IDQ?
Explain about Classifier models in IDQ?
Are Probabilistic models part of Informatica Base Content set?
Are Classifier models part of Informatica Base Content set?
How do you create Probabilistic models in IDQ?
Explain about Regular Expressions used in IDQ?
What is the difference between Classifier model and probabilistic model?
Explain about Named Entity Recognition(NER) model?
Explain the difference between Regular Parsing and Probabilistic Parsing?
Can you create multiple Analyst service in Informatica Administrator?
Explain about System Services?
Do you need to create strategies in all the Data Quality Transformations?
Name some IDQ transformations which support parameterizing the Cache directory?
Which IDQ transformations can generate Score?
Is versioning enable in MRS when Administrator enable versioning in Domain?
Can you export all objects created in IDQ to PowerCenter?
What is Data Quality for Excel?
What are the prerequisites to use DQ for Excel?
Name some data integration service plugins can be defined in DIS?
Can you use Delete HTTP Method in IDQ?
What Task Recovery Strategies did you use?
What types of Parameters can be created in IDQ?
Can you export Analyst objects using Analyst tool from one environment and import to another environment ?
Which all transformations uses Execution Instances?
In which all tools did you Integrate IDQ?
Can you perform Matching as part of a data profiling process?
Can you use Rules in Informatica Developer only?
What are the available Assets In Informatica Analyst?
Explain about Mapping Specifications?
Can you export Mapping Specifications to PowerCenter?
What are Parameter Sets?
Name some transformations which can support Parameters?
Address Validator
What is Informatica Address Verification?
What is Geocoding?
Explain about Address Validator Transformation?
What are the Validation Modes available in Address Validator Transformation?
Explain about Address Validation Template Models?
When to use Basic and Advanced Address Validation Template Model?
What are the different types of Address Validation Input Templates?
Explain about Discrete Address Validation Input Template?
Explain about Multi line Address Validation Input Templates?
Explain about Hybrid Address Validation Input Templates?
Explain about Batch Validation Mode?
Explain about Certified Validation Mode?
Explain about Country Recognition Validation Mode?
Explain about Interactive Validation Mode?
Explain about Parse Validation Mode?
Explain about Suggestion List Validation Mode?
Explain about output groups in Address Validator?
Which Address Modes use Reference Data?
Can you use address Validator transformation without a valid Address Doctor key?
Explain about Address Doctor Subscription Files?
How to configure Address Validator to run against a Particular country?
Explain the difference between Force and Default options in Address Validator?
How to check the accuracy of address data transformed by Address validator?
What is Match Score in Address Validator?
What is Mailability Score in Address Validator?
What is the difference between dictionary files, reference table data, and the Address Doctor files?
Explain about Matching alternatives in Address Validator?
Explain about Matching Scope in Address Validator?
Explain about AMAS in Address Validator?
Explain about SERP in Address Validator?
Explain about CASS in Address Validator?
Can you use Address Validator in Certification Mode for all the Countries?
How to Increase address validation search depth and will the validation be impacted if we leave the search depth to the default option?
How to update Address Doctor files?
How to check if Address Validator Reference file are provided for a particular country?
How to limit the number of address suggestions when using Suggestion list in Address Validator Transformation?
Explain about FULL Pre-Load Countries, Partial Pre-Load Countries, No Pre-Load Countries options available in Address Validation?
Explain how performance is Impacted by FULL Pre-Load Countries, Partial Pre-Load Countries, No Pre-Load Countries available in Address Validation?
How to Improve performance of Address Validator?
Explain about the preloading Methods available for Address Validation?
Which of the preloading Methods is optimal for Address Validation performance?
How many maximum execution instance can you use in Address Validator?
What is the Maximum Address Object can you configure?
Where you do the address validator configuration in PowerCenter?
Can you add more than one license key information in AD50.cfg configuration file?
Can you use any other delimiter (other than comma) for adding license information in AD50.cfg configuration file?
Can you validate Address data using web services ?
In which Validation Mode, the Address Validator transformation can be executed with default Address Doctor license key?
Merge Transformation
Explain about Merge Transformation?
Can you use Concatenate function instead of using Merge?
Explain about Merge Character in Merge Transformation?
Explain about different datatypes available in Merge Transformation?
Decision Transformation
Explain about Decision Transformation?
Explain the difference the between Decision and Expression Transformation?
What Expression functions are not supported by the Decision Transformation?
How do you assign value to a port in the Decision Transformation?
Can you use an output port of a strategy in another strategy in Decision transformation?
Can you validate a mapping with no errors if there are one or more inputs ports not connected to Decision transformation?
Case ConverterTransformation
Explain about Case Converter Transformation?
What are the Case Conversion methods available in Case Converter Transformation?
Can you use reference tables in Case Converter Transformation?
Standardizer Transformation
Explain about Standardizer Transformation?
Can you create multiple strategies in standardizer transformation, if yes can user define to execute the strategies in a particular sequence?
Can you use the output ports of one strategy as Input port to another strategy in the same transformation?
How to remove/replace a string from a particular position using standardizer transformation?
What is the default delimiter in Standardizer and how to prevent substrings from being replaced with reference table values?
How to remove all the extra spaces inside a string leaving one single space using a DQ transformation?
How to remove the trailing and leading spaces of a string using a DQ transformation?
How did you standardize source data with data quality transformations?
What are noise words give us few examples on noise words are removed using data quality transformations?
Did you use standardizer with more than one strategy applied to an input port, if yes, explain?
Labeler Transformation
Explain about Labeler Transformation?
What are the Execution Modes available in Labeler Transformation?
When to use Character execution mode in Labeler Transformation?
When to use Token execution mode in Labeler Transformation?
Explain about Inclusive and Exclusive modes in Labeler Transformation?
What are the types of Reference data used by Labeler Transformation?
Explain about Character Sets used in Labeler Transformation?
Explain about the use of Regular Expressions in Labeler Transformation?
Explain about Token Sets used in Labeler Transformation?
Explain about some of the important ports in Labeler Transformation?
How Score Output port in labeler generates the score values?
Can you generate Score for the input data in Labeler transformation, similar to the Match transformation based on the similarity between the input data pairs?
Explain about Character Labeling operation in Labeler Transformation?
Explain about Token Labeling operation in Labeler Transformation?
When configuring Labeler, Explain the Importance of delimiter configuration?
In which Execution Mode in Labeler can you use probabilistic matching techniques?
In Labeler can you read data right to left (in reverse order)?
What is Label residue and in which mode can be configure this?
Can you enable Reverse Enabled option when we use probabilistic matching techniques in Labeler Transformation?
Parser Transformation
Explain about Parser Transformation?
What are the Execution Modes available in Parser Transformation?
Explain about Token Parsing mode in Parser Transformation?
Explain about Token Parsing Operations?
Explain aboutPattern Based Parser data mode in Parser Transformation?
Explain about Pattern sets used in Parser Transformation?
Explain about some of the Important ports in Parser Transformation?
How the Parsing Output Impacts if there are multiple parse strategies?
What is Detailed Overflow option?
What is Overflow Reverse option?
Explain the pre-requisite for using Pattern Based Parser?
What are the default ports created with Pattern Based Parser?
In Parser can you read data right to left (in reverse order)?
In which Execution Mode in Parser can you use probabilistic matching techniques?
Can you enable Reverse Enabled option when we use probabilistic matching techniques in Parser Transformation?
In which mode in Parser Transformation can you use pattern sets?
Key Generator Transformation
Explain about Key Generator Transformation?
Explain about Key Creation Strategy in Key Generator Transformation?
Explain about Soundex Key Creation Strategy in Key Generator Transformation?
Explain about NYSIIS Key Creation Strategy in Key Generator Transformation?
Explain about String Key Creation Strategy in Key Generator Transformation?
How to choose the right Group key?
What are composite Keys in Key Generator?
How to determine if Group key has to be created on single source field or multiple source fields?
Is it possible to change to change the order of keys merged when using a composite key in Key Generator?
Explain about Match Performance Analysis in Key Generator Transformation?
Do you need to sort on the GroupKey when passing input data from Key Generator to Match Transformation?
How to generate a distinct group key if the incoming data doesn’t already have a key value?
Match Transformation
Explain about Match Transformation?
What is the difference between Key Generator Transformation and other Data Quality transformation w.r.t to strategy configuration?
Explain about Match Types in Match Transformation?
Explain how Match Transformation perform data analysis for the match fields?
What are the Field Matching strategies available in Classic Matching?
What are the different classes available in Identity Matching?
Explain how Informatica performs the Match Process?
What are the Match Output types in Match Transformation?
Explain about the different Match result output formats in Classic Match?
Explain about each matching strategy available in Classic Matching?
Explain about Jaro Distance algorithm?
Explain about Edit Distance algorithm?
Explain about Bigram Distance algorithm?
Explain about Hamming Distance algorithm?
Explain about Reverse Hamming Distance algorithm?
Explain about Pair Generation in Match Transformation?
Explain about dual source matching?
Explain the difference between single source and dual source match process?
Can you use more than one input field in the field match strategy with in match transformation?
Is GroupKey mandatory for the match process?
Is SequenceId mandatory for the match process?
What are the stats shown by Match Cluster Analysis?
Explain about Scoring methods in Match Transformation?
Why it’s not recommend to use driver score in the scoring method?
Can you set a Null Match score of 0.5 when we use Identity Match algorithm?
Explain how Match Transformation scores for Null data when we use classic matching?
Explain about Weighted Scores in Match Transformations?
How to Improve the performance of a mapping with Match Transformation?
Explain about the Match Output type - Cluster in classic Match?
Explain about the Match Output type – Matched Pairs in classic Match?
Explain about the Match Output type – Best Match in classic Match?
Explain about the Filter Exact Match option in Match Transformation?
Explain about the Match output type Clusters – Best Match in Identity Match?
Explain about the Match output type Matched Pairs in classic Identity Match?
Explain about the Match output type Clusters – Match All in Identity Match?
Which source fields will be considered by the Filter Exact Match Option for eliminating the identical records from the matching process?
How the Filter Exact Match Impacts the records in the Clusters?
As Filter Exact Match Option Improves the performance of the mapping, do you recommend to always enable this option in the Match mapping?
Explain about the output ports created by Match Transformation during the matching process?
How do you decide on which columns you should match the data, on what columns should the data be grouped etc.?
Identity Matching
Explain about Identity Match Option in Informatica?
Explain how the input data effects the Classic Match operation and Identity Match Option in Informatica?
What are the different Population files available?
Explain about Populations in Informatica Identity Resolution?
Explain how Populations differ for each country/language?
What are the match algorithms used by Populations in Informatica Identity Resolution?
Explain about Key Level property in Identity matching?
What is the default key level in identity matching if no search level is specified?
Explain about Key Type Property in Identity matching?
Explain about Search Level property in Identity matching?
What is the default search level in identity matching if no search level is specified?
Explain about Key Field Property in Identity matching?
Explain about Match Level property in Identity matching?
What is the default Match level in identity matching if no Match level is specified?
Explain about the match strategy in Identity matching?
What are the Algorithms available in Identity Match?
Explain about PersistenceStatusDesc ?
Can you disable Match process in Match Transformation?
Weighted Average Transformation
Explain about Weighted Average Transformation?
From which transformation does weighted Average transformation receives scores?
Classifier Transformation
Explain about Classifier Transformation?
What are the algorithms used by Classifier Transformation?
Comparison Transformation
Explain about Comparison Transformation?
Explain about Field Matching Strategies available in Comparison Transformation?
Explain about Identity Matching Strategies available in Comparison Transformation?
Can you use Comparison Transformation for generating the Clusters and MatchedPairs as all the Field Matching and Identity Matching Strategies are available in Comparison Transformation?
What are the output ports generated by Comparison Transformation?
Data Consolidation
What is Data Consolidation?
What if data is not consolidated as part of the data quality/data warehouse/mdm projects?
What are the Data Consolidation transformations available in IDQ?
Association Transformation
Explain about Association Transformation?
Explain about AssociationID in Association Transformation and how AssociationID is used by the Consolidation Transformation?
Explain how Association Transformation generates AssociationID with an example?
How to Improve performance for Association Transformation?
What datatypes are allowed in Association Transformation?
Consolidation Transformation
Explain about Consolidation Transformation?
Explain about the Consolidation Types, and where do we perform consolidation for each type?
How can you identify all the records which have contributed to the survivor/golden/master record?
What strategies can you define in Consolidation Transformation?
Explain about Simple Strategy in Consolidation Transformation Strategies View?
Explain about the Consolidation Functions available in Simple Strategy in Consolidation Transformation?
Explain about Row-Based Strategy in Consolidation Transformation Strategies View?
Explain about the Consolidation Functions available in Row-Based Strategy in Consolidation Transformation?
Explain about Advanced Strategy in Consolidation Transformation Strategies View?
Which is the default output port in the Consolidation Transformation?
Explain how performance can be tuned for Consolidation Transformation?
Do you only get Survivor records as output from Consolidation transformation?
Exception Management
Explain about Exception Management Process Flow?
What are Exception Records?
Explain about Exception Transformation?
How Run Data viewer option is different when executed on Exception Transformation and other Data Quality Transformations?
Can you create multiple Exception Transformations in a single mapping?
Can there be only one target for the Exception Transformation in downstream?
Bad Record Exception Transformation
Explain about Bad Record Exception Mode in Exception Transformation?
What are the data Routing options in Bad Record Exception Transformation?
Explain about the Thresholds in Bad Record Exception Transformation?
What are the tables created by Bad Record Exception Mode in Exception Transformation?
Explain about the Input data groups available in the Bad Record Exception Mode in Exception Transformation?
Explain about the Output ports available in the Bad Record Exception Mode in Exception Transformation?
Explain about Issue Priorities?
How to assign issues to the source data fields in the Exception Transformation?
Explain how exceptions are identified in Bad Record Exception Transformation?
Can you output more than one quality issue to a column in Exception transformation?
Duplicate Record Exception Transformation
Explain about Duplicate Record Exception mode in transformation?
Which is the pre-requisite transformation to use if data has to be sent to Duplicate Record Exception Transformation?
Explain how Duplicate Record are identified in Duplicate Record Exception transformation?
Explain about the Thresholds in Duplicate Record Exception Transformation?
What are the data Routing options in Duplicate Record Exception Transformation?
Explain about the Input data groups available in the Duplicate Record Exception Mode in Exception Transformation?
Explain about the ports available in the control data group in Duplicate Record Exception Mode in Exception Transformation?
Explain about the Output data groups available in the Duplicate Record Exception Mode in Exception Transformation?
What are the tables created by Duplicate Record Exception Mode in Exception Transformation?
Human Task
Explain about Human Task?
How to assign users in Human Task to review the exception records?
What are the required attributes in Exception task processing?
How tasks can be distributed in Human Task?
Which are the available status in Informatica Analyst to correct exception records?
What are the different steps which can be created in Human Task?
What are the different permissions which can be configured in Cluster Step up?
Explain about the Roles in Human Task?
What are the required attributes for Duplicate Task processing?
Can you use workflow variables in Human Task notification?
Do you required any separate process after the exception records are updated by Analyst in Informatica Analyst to correct Source Records?
Do Informatica maintain any Audit stats for the changes which users update to the exception records in Informatica Analyst?
Data Quality General Questions
What is Data Quality?
What is Data Governance?
Is Data Quality required for all organizations?
How does the quality of data is Important at the Enterprise Level?
What causes Data Quality Problems and list the stakeholders who can ensure proper data and address all the data quality Issues?
Who is responsible for Data Quality?
How to monitor Data Quality on an ongoing basis?
Can data quality solve the root cause of the data problems?
How to ensure data present in the organization is trustworthy?
What is the Impact of Poor Data Quality?
What is Data Quality Management?
Tell us about the Four Pillars of Data Quality Management? Or what are the important aspects in Data Quality Management?
What is Data Profiling
Why Data should be profiled?
What are different Data Quality tools available in the market?
What is Data Domain?
What is Data Discovery?
What is Data Domain Discovery?
What is Data Stewardship?
How Modern Data Quality Software tools handle the limitations of traditional profiling?
Questions Requested by Enrolled Students
In which scenarios should you use UnManaged Editable,UnManaged and Managed Reference tables?
What is the difference between Informatica Data Quality and Informatica Master Data Management?
Explain about Scheduler Service?
How to schedule IDQ Jobs?
How to automatically notify users after the Profile is executed?
Can you migrate the code of IDQ 9.1 or IDQ 10. Is it simple or do you need to follow any important step before migration?
If you have IDQ version 10 and powercenter with lower version like 9.6. Can you migrate the xml? If yes then how and if no then why?
What will happen to the transformations when we import them into PowerCenter..For example some IDQ transformation don't exist in PowerCenter, how will they change.
Should always code be migrated only through PowerCenter to production.Is there a way we can push the code in IDQ itself?
How can you execute workflows multiple times in developer tool?
How is Mid-Stream profile different from Compare profile previously mentioned?
Do the Mid-Stream & Compare profile need to be re-run / refreshed every time the mapping is executed?
Is data doctor an Unmanaged reference table?
Can you use reference tables in the Analyst tool?
What is Enterprise Discovery Profile, explain with an appropriate real-life example ?
Why merge transformation is required if we can combine using simple concatenation?
Explain about Logical Data Object (LDO) with a Business Scenario?
We are using Informatica content set (Reference data) as standalone, as we don't have license to Content Management Service, how can we update the Reference data in this scenario?
How to store two consecutive historical scorecards data on every run?
can you compare two profiles in IDQ?
Is it recommended to sort the data before the match process?
How do you sort the data if you need to match around 5 million records using a Dual Source field match in the Match Transformation?
During the upgrade process, can you exclude the data quality mappings and upgrade only the PowerCenter mappings?
From Informatica Developer 10.x, can you export objects to PowerCenter 9.6?
Are there any objects which have to be manually configured after exporting objects from IDQ to PowerCenter and vice versa?
You have an address having building number, area code, postal, country all in a single field, have to enter it in separate fields like building number, country, postal code, how you will do it using address transformation?
How Run Data viewer option is different when executed on Exception Transformation and other Data Quality Transformations?
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock