Hello friends if you are looking for Informatica L1 Assessment Question Answers | Informatica L1 MySkillz Wipro Questions with Answers | Informatica L1 TrendNXT MCQ With Answers | Informatica L1 Objective Type Questions with Answers then here you will get Answers for it.
| You define a set of instructions to execute tasks, using : | A)Workflow Monitor | B)Workflow Manager | C)Repository Manager | D)PowerCenter Designer | Ans) B |
| .……………….. is the primary unit for management and administration within PowerCenter | A)Repository Manager | B)Workflow Manager | C)Administration Console | D)Power Center Domain | Ans) D |
| A ……….. is the logical representation of a machine in a domain | A)Node | B)Server | C)Grid | D)Service | Ans) A |
| ………… allow users to create shortcuts to objects in the folder | A)Integration Service | B)Ans)Shared Folder | C)Repository Security | D)Administration Console | Ans) B |
| The Integration Service connects to the repository through the …………… to fetch metadata from the repository | A)Repository Service | B)Repository Manager | C)Reporting Service | D)Metadata Manager Service | Ans) A |
| Which among the following is not an Application service | A)Integration service | B)Repository service | C)Log service | D)reporting service | Ans) C |
| Which service is responsible for executing the mappings | A) Integration service | B)Repository service | C)Log service | D)reporting service | Ans) A |
| Which are the types of services which need not to be created by the Administrator? | A)SAP BW service | B)Core | C)Repository service | D)Application service | Ans) B |
| A set of source and target definitions linked by transformation objects that define the rules for data transformation is called a | A)Mapping | B)Worklet | C)Workflow | D)Schema | Ans) A |
| …………… is a repository object that generates, modifies, or passes data | A)Transformation | B)DTM | C)Mapping | D)Integration Service Process | Ans) A |
| To create or import source definitions, ………….. is used in the Designer | A)Target Designer | B)Transformation Developer | C)Mapping Designer | D)Source Analyzer | Ans) D |
| To extract data from a source, first step in the Designer is : | A)create a session | B)data profiling | C)define sources in the repository | D)create a workflow | Ans) C |
| Relational source definitions can be imported from : | A)tables | B)tables, views, synonyms | C)tables, views | D)tables, views, stored procedures | Ans) D |
| When a relational source definition is imported, which of the following source metadata is imported ? | A)triggers | B)stored procedures | C)Column Names, Datatypes | D)Column Names, Datatypes, Key constraints | Ans) D |
| What type of files can be imported for flat-file source/target definitions in the repository ? | A)Fixed-width | B)Delimited | C)Fixed-width and delimited flat files that do not contain binary data | D)Binary | Ans) C |
| Target Designer is used to : | A)Import or create target definitions | B)Create mappings | C)Import or create source definitions | D)Create target definitions | Ans) A |
| In which of the following ways can the target definitions be created ? | A)Create a target definition based on a source definition | B)Manually create a target definition | C)Import the target definition from a relational target or a flat file | D)All of the above | Ans) D |
| Which types of target definitions can be created in the Target Designer ? | A)Relational | B)Relational, Flat file, XML file | C)Binary file | D)DLL file | Ans) B |
| Mappings represent : | A)the data flow between sources and targets | B)data extraction | C)data cleansing | D)data loading | Ans) A |
| When the Integration Service runs a ……………, it uses the instructions configured in the mapping to read, transform, and write data | A)command | B)session | C)transformation | D)query | Ans) B |
| Every mapping must contain which of the following components : | A)Source definition | B)Target definition | C)Source definition, Target definition, Transformation, Links | D)Source and Target definition | Ans) C |
| Which of the following changes cause the session to be invalid ? | A)Adding a table in the source database | B)Deleting rows from a target table | C)Creating an index in the source database | D)Adding or removing a Joiner or Update Strategy transformation in the mapping | Ans) D |
| Which of the following cannot be used as Targets | A)XML Files | B)Cobol Files | C)Text Files | D)Relational Tables | Ans) B |
| A flat file cannot be used as the following | A)Source | B)Target | C)Aggregator | D)Lookup | Ans) C |
| Which of the following objects cannot be included in a mapplet? | A)Target Definition | B)Source Definitions | C)Router Transformation | D)Update Strategy Transformation | Ans) A |
| Shortcuts can be created from which of the following? | A)Source Definitions | B)Reusable transformations | C)Mapplets | D)All the above | Ans) D |
| Which of the following is not a Active Transformation ? | A)Filter | B)Sequence Generator | C)Router | D)Update Strategy | Ans) B |
| Which of the following Transformations does not use cache files ? | A)Sorter | B)Router | C)Rank | D)Aggregator | Ans) B |
| Which of the following is not a lookup cache property ? | A)Dynamic Lookup Cache | B)Static Lookup Cache | C)Persistent Lookup Cache | D)Active Lookup Cache | Ans) D |
| Which of the following transformations does not have variable port ? | A)Expression | B)Rank | C)Filter | D)Aggregator | Ans) C |
| The output from an Aggregator transformation without a Group by will return? | A)All records | B)Error | C)1 record | D)None of the above | Ans) C |
| ………….. contains a set of transformations that can be reused in multiple mappings | A)Worklet | B)Mapplet | C)Custom Transformation | D)Workflow | Ans) B |
| An Active Transformation : | A)Does not change the number of rows that pass through it | B)Represents the data flow between sources and targets | C)Can change the number of rows that pass through it | D)Creates a target definition based on a source definition | Ans) C |
| When you add a relational or a flat file source definition to a mapping, you need to connect it to a | A)Joiner Transformation | B)Aggregator Transformation | C)Source Qualifier Transformation | D)Expression Transformation | Ans) C |
| In Joiner Transformation, if Master Outer Join type is used, it will : | A)Keep all rows of data from the detail source and the matching rows from the master source, and discards the unmatched rows from the master source | B)Discard all rows of data from the master and detail source that do not match, based on the condition | C)Keep all rows of data from the master source and the matching rows from the detail source, and discards the unmatched rows from the detail source | D)Keep all rows of data from both the master and detail sources | Ans) A |
| To test data for one or more conditions and route rows of data that do not meet any of the conditions to a default output group, which transformation would you use ? | A)Sorter Transformation | B)Router Transformation | C)Joiner Transformation | D)Filter Transformation | Ans) B |
| A transformation that does not change the number of rows that pass through it, is called : | A)Passive Transformation | B)Connected Transformation | C)Mapplet | D)Source Qualifier | Ans) A |
| ……………….. is an example of Passive Transformation | A)Update Strategy Transformation | B)Router Transformation | C)Expression Transformation | D)Rank Transformation | Ans) C |
| ……………….. is used to control on a row by row basis, whether the row is to be inserted, updated, deleted or a rejected based on some logical condition | A)Sorter Transformation | B)Update Strategy Transformation | C)Joiner Transformation | D)Normalizer Transformation | Ans) B |
| To concatenate first name and last name of an employee, which transformation would be used ? | A)Aggregator Transformation | B)Joiner Transformation | C)Expression Transformation | D)Normalizer Transformation | Ans) C |
| Aggregator Transformation performs : | A)calculation of values in a single row | B)concatenation of columns/ports in a row | C)aggregate calculations, such as averages and sums | D)calculations on a row-by-row basis | Ans) C |
| Which of the following is not True with respect to Sorter transformation ? | A)Sorter uses cache memory to sort data | B)Sorter is a Passive Transformation | C)Sorter can be used to remove duplicate records | D)All the above | Ans) B |
| What types of transformation ports are valid ones? | A)Input, Output, Variable | B)ans)Input, Output, Input/Output, Variable | C)Input, Output, Variable, Aggregate | D)Input, Output, Input/Output, Variable, Parameter | Ans) B |
| What value would the function GET_DATE_PART (DATE_SHIPPED, ‘HH’) return when the value of DATE_SHIPPED is null? | A)0 | B)Null | C)12 | D)A Transformation error is generated | Ans) B |
| For triming leading & trailing spaces of a in Informatica the following function is used | A)TRIM(VALUE) | B)LTRIM(VALUE) | C)LTRIM(RTRIM(VALUE)) | D)All of the above | Ans) C |
| A set of instructions to execute tasks such as sessions, emails, shell commands etc is called : | A)Mapping | B)Load Balancer | C)Workflow | D)Transformation | Ans) C |
| A session : | A)is a set of instructions that describes how and when to execute tasks related to extraction, transformation and loading data | B)is an object that groups a set of tasks | C)is a set of instructions that describes how to move data from source to target using a mapping | D)Reads workflow information from the repository | Ans) C |
| Which among the following is not a type of workflow task | A)Event wait | B)Event raise | C)Timer | D)Filter | Ans) D |
| A session task is a type of : | A)transformation | B)worklet | C)workflow task | D)mapplet | Ans) C |
| Chrological details of workflow tasks can be viewed in | A)Gantt chart view | B)task view | C)Workflow view | D)we cant view chronological details in worklow monitor | Ans) A |
| In a Workflow , you need to run an operating system script between two sessions. How can you best accomplish this? | A)Call from Post SQL | B)Call the script from a Command task | C)Use a custom transformation | D)Use Event raise and Event wait tasks | Ans) B |
| Are user-defined events supported in PowerCenter workflows? | A)No, because only File Wait events are supported in the Event-Wait task. | B)Yes, but only in workflows containing worklets. | C)No, because Event-raise tasks do not support user-defined events. | D)Yes, using a combination of Event-Raise and Event-Wait tasks | Ans) D |
| Which of the following is a type of workflow task? | A)Database Bulk Loading | B)Event Raise | C)Ranking | D)Sorting | Ans) B |
| A workflow fails and you need to consult the logs. Which PowerCener application will allow you consult the session and workflow logs? | A)Designer | B)Administration console. | C)Workflow Monitor | D)Workflow Manager. | Ans) C |
| A Workflow log does not contain which of the following? | A)Status of tasks and worklets in the workflow | B)Errors encountered during the workflow and general information | C)Status of tasks and worklets in the workflow | D)None of the above | Ans) D |
| To determine the cause of workflow or session problems & resolve it? | A)Use log events | B)Locate the relevant log codes | C)Locate text prefixes | D)All of the above | Ans) D |
| You can also create an _________ file for workflow log events | A)XML | B)text | C)binary log | D)All of the above | Ans) D |
| What is Default Recovery Strategy for Session | A) Restart task | B) Resume from last checkpoint | C) Fail task and continue workflow | D) None | Ans) c |
| At which tracing level does the Integration Service not write error messages or row-level information for reject data. | A) Terse | B) Verbose | C) Both A and B | D) Normal | Ans) a |
| You can view properties for which of the following items in the Workflow Monitor? | A)Session, Tasks, Workflows | B)Session, Tasks, Workflows, Links, Folders | C)Session, Tasks, Workflows, Links, Folders, Integration Service | D)Session, Tasks, Workflows, Links, Folders, Integration Service, Grids | Ans) D |
| which command is used to execute workflow tasks from the command line | A)PMREP | B)PMCMD | C)REPCMD | D)CMD | Ans) B |
| A scheduling tool from BMC software | A)CONTROL M | B)Autosys | C) | D) | Ans) A |
| -sv’ option of PMCMD command is used to specify______________ name | A)repository service | B)domain name | C)integration service name | D)node name | Ans) C |