Autoplay
Autocomplete
Previous Lesson
Complete and Continue
DVO Interview Questions and Answers
Data Validation Option Interview Questions
What is Data Validation?
Explain about Data Validation Option?
Explain about the objects which can be refreshed in DVO from PowerCenter?
What is the difference between Refresh Repository vs refreshing Individual folders?
Can you automate the Refresh Repository to import the PowerCenter object in DVO?
What are the new features in Informatica DVO 10.x?
What types of data validation can be performed by using DVO?
Explain about DVO Architecture?
Explain the benefits of using DVO w.r.t to manual testing?
Is DVO completely client based?
What is Primary Key File in DVO?
Explain about Export/Import?
How do you import tables in DVO?
List the objects which can be imported in DVO from PowerCenter?
What is the difference between Import and Import Overwrite?
Explain about source repository and target repository in DVO?
Can you add multiple Source Repositories in DVO?
Can you add multiple Target Repositories in DVO?
How to generate DVO mappings in DVO PowerCenter folder?
Why is the DVO target folder not visible in DVO Client even after refreshing everything in repository?
How can you improve the performance of Aggregate views?
Why to use Aggregate Views when you can write the aggregate sql query and use the SQL views?
Explain about Aggregate Views in DVO?
Which test do you perform to check if all source records are loaded in target?
What are the different View types available in DVO?
Can you use parameters in Aggregate views, SQL views or Join Views?
In DVO where can you filter the source records, and which layer filter will be effective in terms of Performance?
In DVO, on which objects can you filter data?
What is a lookup table?
Can you use filters in Lookup views?
What join DVO performs when using Lookup views?
Explain the difference between filtering the data in table pair vs filtering the data in test (i.e. in the test conditions option)?
Can you generate Jasper Reports in DVO 10.x (which is using the PowerCenter 10.x?
DVO is installed but I am not able to see any option to configure Jasper Reports, is it due to the access Issue, how can DVO users enable and configure Jasper Reports?
Explain the difference between BIRT Reports and Jasper Reports?
Explain about Dashboards in DVO?
Can you generate custom reports in DVO?
Can we validate the data in Data Validation Option from tables which are present in applications other than PowerCenter?
Can we create user defined functions (UDF) in DVO?
Can we validate the data in Data Validation Option from tables which are present in applications other than PowerCenter?
How to limit the number of simultaneous execution of DVO test cases?
How to generate a flat file output with all the Bad Records generated by the DVO test cases instead of displaying the Bad Records on DVO GUI?
Where are the bad records flat file is stored in DVO?
Why the bad files are created on Informatica server directory, when DVO is completely client based?
What is the format of the data in the bad records?
As DVO is tightly Integrated with PowerCenter, can we provide Integration Service variables such as $$PMROOTDIR in the path of DVO parameter file?
When we do ETL/Database upgrades, can we use DVO to compare the metadata?
Can you create DVO test’s when Informatica PowerCenter Services are down?
What are the pmrep commands executed during DVO refresh repository operation?
How to avoid metadata duplication when we import metadata from multiple repositories in DVO?
How to check the associated Informatica workflow for the DVO table pair?
Does DVO generate single workflow per test case?
Which are the pre-requisite configuration required for configuring DVO?
How to Configure the DVO client to get more than the default value of 100 bad records?
Do we need to create users separately for accessing DVO?
Is it possible to exclude selected connections while refreshing the connections in DVO?
Do all the connections in the source repository should also exist in target repository?
Can we use Parameter File in DVO?
Explain in which scenarios can we use Parameter files in DVO and what should be the format of the Parameter file?
Explain about SQL Views in DVO?
How can we include tables from different databases while creating a SQL view?
Can we include flat file objects when we create SQL views?
Can you compare data from two different SQL views?
DVO is displaying incorrect data when using SQL views, the data is the database for Table A and Table B are matching correctly but DVO shows all the records as Bad Records.
Explain about Lookup Views in DVO?
Can we include flat file objects when we create Lookup views?
Explain the difference between SQL Views and Lookup Views?
Explain about Join Views in DVO?
Explain the type of joins available in Join Views?
How to improve the performance of Join Views in DVO?
Can you compare data from two different Join views?
How can we invoke DVO jobs as DVO doesn’t have any server component?
How often the PowerCenter mappings are generated by DVO?
Can we copy the transformation logic from PowerCenter to DVO test cases?
When the Informatica Repository is configured in DVO initially, how to skip refreshing of all the objects automatically? (i.e. let says the Informatica Repository which is added to DVO has 150 folders and you want to refresh the objects in 30 folders only)
Can DVO users delete or modify any objects (source, target and connections) directly from DVO client?
Is it possible to mention a list of folders for DVO to refresh instead of refreshing all the folders?
What is the difference between Metadata Reload and Refresh Objects?
What causes objects not to be refreshed in DVO?
Explain about Table Pairs in DVO?
How to Improve Table pair performance?
Which table is defined as master table, when you create a table pair?
Can we change the default master table and assign Table B as the master table?
Should we always choose the source table as TableA and Target table as TableB? What are the guidelines which we should follow on which table should be master or detail?
Explain about Single Table constraints in DVO?
Which functions can we use in Single Table constraints?
What are the different Aggregate test types in DVO?
What are the different Set test types in DVO?
What is the difference between COUNT, COUNT_DISTINCT and COUNT_ROWS tests?
Explain about Set Test in DVO?
Explain about the SET_AinB test type?
Explain about the SET_AeqB test type?
Explain about the SET_ANotInB test type?
Explain about Value Test in DVO?
Explain about Outer Value Test in DVO?
Can we create Value Test with Single Table Pair?
What join DVO performs when using SET tests?
When a Value test is created, what kind of Join is applied by DVO?
When a Outer Value test is created, what kind of Join is applied by DVO?
What is the difference between Value Test and Outer Value Test?
What is the difference between NOT_NULL and NOT_BLANK tests in DVO?
Explain about Aggregate Test in DVO?
Explain about Automatic Test Generation in DVO?
What are the different types of Automatic Test Generation available in DVO?
When should we use Automatic Test Generation in DVO?
How to Increase DTM buffer size for all DVO generated sessions from DVO?
What are the limitations of Automatic Test Generation?
Can we generate Bad Records Detail report for all the report types?
Which test do you perform to identify records in a fact table that are not in the dimension table?
How DVO jobs are executed in production, if the table pairs created by one user cannot be executed by a different user?
Is it possible to run a table pair by another user from DVOCmd command?
What is the difference between tests created on a table pair and single table?
Do External ID’s should be unique for all users in DVO?
Is it possible to use indirect file option, when we use flat files in table pairs?
Can DvoCmd run all the table pairs at once?
How to perform Joins on columns on which DVO doesn’t support Join, for example Join between binary data types?
Explain about sampling in DVO?
Why can’t we perform the COUNT and OUTER VALUE tests when using the Sampling option?
Can we Perform sampling for Source and Target in DVOClient?
Few mappings generated by DVO are failing because of some reason, can we import the mapping created in PowerCenter into DVOClient?
Few mappings generated by DVO are having some performance issues due to which the workflow is getting failed, can we import the mapping created in PowerCenter into DVOClient? (example :- there are two tables with around 500 Millions rows in each , but DVO jobs are failing due to the sort file size and performance of these jobs are very slow)
Which Operator should be used when testing the Unique Constraint test in Single table test?
Can we use metadata import/export feature to move code from one DVO repository (Dev) to another DVO repository (QA or Prod)?
How can we invoke DVO jobs from Informatica?
You have imported few objects in PowerCenter and refreshed the DVO repository and created few tests on the objects and executed them, all the tests were successful, now what will happen if the objects are deleted from PowerCenter Repository?
While creating test cases in DVO, Informatica services were shutdown, how will this Impact the test cases creation in DVO?
What are the Initial tests performed using DVO on the tables and why?
Two users are using a generic userid (same userid) User1 has reused the SQL views, Join Views and Lookup views created by User2 in his table pair, due to some issue User1 has deleted the table pairs he has created which has deleted all the tests under that table pair, how the User2 test will be Impacted when User1 has deleted the table pairs?
When using a custom Aggregate-View/SQL-view does the order of the attributes defined in the (DVO) column definition impacts the test cases?
Explain about the Performance tuning options in DVO?
What are the recommended naming standards for DVO Objects?
Can we use the existing integration service which is used by PowerCenter Jobs or is it recommended to create new Integration service for running DVO Jobs?
Can we deploy the mappings generated by DVO from Dev to Test or from Test to Prod and schedule them to validate the test cases?
what are different ways to create automatic test cases in DVO?
What is the recommended approach to execute DVO test cases?
What are the status’s DVO client displays during the test case creation and execution?
After configuring the required environment variables, when executing the DVOCmd commands in UNIX displays an error message stating the dvocmd: Command not found, the same commands works fine in windows. Do we need to do any additional setup in UNIX to execute the DVOCmdcommands?
Can we use parameterize connection(s) in DVO in Table-pair?
Is it possibe to run individual test cases of a table pair in DVO?
Why is it not possible to run individual test cases of a table pair in DVO?
Where can we define the privileges in DVO to restrict the users, to update or execute table pair on particular folders?
Where should we place the parameter file while executing the Table Pair in Data Validation Object?
How can we set up DVO and PowerCenter configuration?
Will DVO import source and target objects every time it generates PowerCenter Mappings or will the source and target objects are imported only when the user selects Refresh Objects in DVO?
Can we exclude a list of PowerCenter folders in DVO while refreshing?
How to avoid write Intent locks on the DVO target folder, when multiple users are simultaneously working on the same repository?
How often do we need to refresh the folders in the Data Validation Option?
Explain in which scenarios can we use Format test in DVO?
When attempting to create a Join view, Aggregate views are not visible. How to add Aggregate views inside Join view?
Should we always choose the source table as TableA and Target table as TableB? What are the guidelines which we should follow on which table should be master or detail?
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock