Informatica 220

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Swapdeo
S
Swapdeo
Community Contributor
Quizzes Created: 1 | Total Attempts: 2,966
| Attempts: 2,975
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/219 Questions

    How to select distinct records form Source Qualifier?

    • Choose 'non duplicate' option
    • Choose 'select distinct' option
    • Choose 'Select non duplicate'
Please wait...
About This Quiz

A quiz created by Swapnil and Ajay for practice of Informatica

Data Management Quizzes & Trivia

Quiz Preview

  • 2. 

    LEAST( 12, 13, 21 ) what will output?

    • 40

    • 25

    • 12

    • 21 

    Correct Answer
    A. 12
    Explanation
    The LEAST function is used to find the smallest value among the given numbers. In this case, the numbers given are 12, 13, and 21. The smallest value among these numbers is 12. Therefore, the output of the LEAST function will be 12.

    Rate this question:

  • 3. 

    NetSal= bassic+hra. In which transformation we can achive this?

    • Aggregator

    • Lookup

    • Filter

    • Expression

    Correct Answer
    A. Expression
    Explanation
    The correct answer is Expression. In this transformation, we can achieve the calculation of NetSal by adding the values of basic and hra together. The Expression transformation allows us to perform calculations and transformations on data within the data flow.

    Rate this question:

  • 4. 

    What is Truncate Table option in update-strategy?

    • Truncate the target table before loading data.

    • Load the table value to another table

    • Delete the data of target which can roll back

    • None of these

    Correct Answer
    A. Truncate the target table before loading data.
    Explanation
    The Truncate Table option in update-strategy allows for the target table to be truncated, or emptied, before loading new data. This ensures that the target table is cleared of any existing data before the new data is loaded, preventing any conflicts or duplicate entries. This option is useful when performing data updates or replacements, as it provides a clean slate for the new data to be loaded into the target table.

    Rate this question:

  • 5. 

    How to execute PL/SQL script from Informatica mapping?

    • Lookup

    • Store Procedure

    • Expression

    • None of these

    Correct Answer
    A. Store Procedure
    Explanation
    To execute a PL/SQL script from an Informatica mapping, the correct option is "Store Procedure". A stored procedure is a named PL/SQL block stored in the database that can be called and executed from Informatica. By using a stored procedure, the PL/SQL script can be invoked and executed within the mapping, allowing for seamless integration between Informatica and the database.

    Rate this question:

  • 6. 

    Which one needs a common key to join?

    • Source qualifier

    • Joiner

    • Look up

    Correct Answer
    A. Joiner
    Explanation
    A joiner is a transformation in data integration tools that combines data from multiple sources based on a common key. In order to perform the join operation, the joiner transformation requires a common key that exists in both sources. This key is used to match and merge the corresponding records from the different sources, resulting in a combined output. Therefore, a joiner transformation needs a common key to join the data from multiple sources.

    Rate this question:

  • 7. 

    Can you rename the repository object?

    • Yes

    • No

    Correct Answer
    A. Yes
    Explanation
    The answer is "Yes" because in most version control systems, including Git, you have the ability to rename a repository object. This can be done by accessing the repository settings or using command-line tools to change the name of the repository. Renaming a repository object can be useful when you want to update the name to better reflect its purpose or to follow a naming convention.

    Rate this question:

  • 8. 

    What is Truncate Table option in update-strategy?

    • Truncate the target table before loading data.

    • Load the table value to another table

    • Delete the data of target which can roll back

    • None of these

    Correct Answer
    A. Truncate the target table before loading data.
    Explanation
    The Truncate Table option in update-strategy is used to truncate the target table before loading data. This means that all existing data in the target table will be deleted before new data is loaded. This is useful when you want to start with a clean slate and ensure that the target table only contains the most up-to-date data.

    Rate this question:

  • 9. 

    Can we calculate in aggregator ?

    • No

    • Yes

    Correct Answer
    A. Yes
    Explanation
    The given answer is "Yes". This suggests that it is possible to calculate in an aggregator. However, without any context or further information, it is unclear what is meant by "aggregator" and what type of calculations can be performed in it.

    Rate this question:

  • 10. 

    Can we update records without using update strategy?

    • Yes

    • No

    Correct Answer
    A. Yes
    Explanation
    Yes, we can update records without using an update strategy. There are alternative methods to update records such as using SQL statements, using stored procedures, or using third-party ETL tools that provide update functionality. These methods allow us to modify data in the target table without explicitly using an update strategy transformation in the ETL process.

    Rate this question:

  • 11. 

    Which of these are measure objects?

    • Min

    • Max

    • Ltrim

    • Avg

    Correct Answer(s)
    A. Min
    A. Max
    A. Avg
    Explanation
    The measure objects in this list are "Min," "Max," and "avg." These are commonly used functions in data analysis and statistics to calculate the minimum value, maximum value, and average value of a set of numbers, respectively. "Ltrim" does not belong to the category of measure objects as it is a function used to remove leading spaces from a string.

    Rate this question:

  • 12. 

    Can you reverting to original reusable transformation? Explanation: If you change the properties of a reusable transformation in a mapping, you can revert to the original reusable transformation properties by clicking the Revert button. 

    • True

    • False

    Correct Answer
    A. True
    Explanation
    If you make changes to the properties of a reusable transformation in a mapping, you have the option to revert back to the original properties by clicking the Revert button. This means that if you have modified a reusable transformation and want to undo those changes, you can do so by selecting the Revert button. Therefore, the statement "Can you reverting to original reusable transformation?" is true.

    Rate this question:

  • 13. 

    Can you run part of work flow?

    • Yes

    • No

    Correct Answer
    A. Yes
    Explanation
    The given question asks if it is possible to run part of a workflow. The correct answer is "Yes" because workflows can be designed to allow for the execution of specific sections or steps, rather than running the entire workflow from start to finish. This flexibility allows users to focus on specific tasks or troubleshoot specific parts of the workflow without having to run the entire process.

    Rate this question:

  • 14. 

    Which version of informatica supports data integration for the cloud?

    • 8.1

    • 8.2

    • 9.0

    • 7.0

    Correct Answer
    A. 9.0
    Explanation
    Informatica version 9.0 supports data integration for the cloud. This version introduced several new features and enhancements specifically designed to enable cloud data integration. These include cloud connectors, which allow seamless integration with various cloud platforms such as Amazon Web Services (AWS) and Microsoft Azure. Additionally, version 9.0 also provides improved scalability, performance, and security for cloud-based data integration processes. Therefore, Informatica 9.0 is the correct version for supporting data integration in the cloud.

    Rate this question:

  • 15. 

    What does reusable transformation mean?

    • It can be re-used across repositories

    • I can only be used in mapplet.

    • It can use in multiple mapping only once

    • It can use in multiple mapping multiple times

    Correct Answer
    A. It can use in multiple mapping multiple times
    Explanation
    A reusable transformation refers to a transformation that can be utilized multiple times in various mappings. Unlike other options mentioned, it is not limited to a single use or restricted to a specific mapplet or repository. This means that the transformation can be applied multiple times across different mappings, providing flexibility and efficiency in data integration processes.

    Rate this question:

  • 16. 

    Joiner does not support flat file.

    • False

    • True

    Correct Answer
    A. False
    Explanation
    The given statement is false. Joiner does support flat files. Joiner is a transformation in data integration tools that allows combining data from multiple sources based on a common key. It can be used to join data from flat files as well as other types of data sources like databases or spreadsheets. Therefore, the statement that Joiner does not support flat files is incorrect.

    Rate this question:

  • 17. 

    What are the different values returned by NewLookupRow port?

    • 0,1,3

    • 0,1,2

    • 1,2,3

    • 2,3,4

    Correct Answer
    A. 0,1,2
    Explanation
    The NewLookupRow port returns a sequence of values that are incremented by 1 starting from 0. Therefore, the correct answer is 0,1,2.

    Rate this question:

  • 18. 

    Which command is similar to 'kill' command in Unix?

    • Stop

    • Abort

    • Kill session

    Correct Answer
    A. Abort
    Explanation
    The command "Abort" is similar to the "kill" command in Unix. Both commands are used to terminate or stop a process or session. They are typically used when a process is unresponsive or needs to be forcefully terminated. The "Abort" command, like the "kill" command, allows the user to terminate a process or session, ensuring that it stops running and releases any allocated resources.

    Rate this question:

  • 19. 

    How to Generate the Metadata Reports in Informatica?

    • From a browser on any workstation

    • Form repository

    • From Work flow manager

    Correct Answer
    A. From a browser on any workstation
    Explanation
    You can generate the metadata reports in Informatica by accessing them from a browser on any workstation. This means that you can view and generate the reports from any computer that has a web browser installed, without the need for any specific software or location. This allows for flexibility and convenience in accessing and generating the metadata reports.

    Rate this question:

  • 20. 

    Can we import source table without using source qualifier? Explanation: For COBOL file sources we can directly use normalizer transformation without using source qualifier

    • True

    • False

    Correct Answer
    A. True
  • 21. 

    Session has to run Monday to Saturday not run Sunday how to schedule in informatica ?

    • Customized Report

    • Weekly option

    • Daily option

    • None of these

    Correct Answer
    A. Customized Report
    Explanation
    The correct answer is "Customized Report" because this option allows the user to schedule the session according to their specific requirements. It provides the flexibility to choose the desired days for the session to run, which in this case would be Monday to Saturday. This option enables the user to customize the schedule and exclude Sunday from the session's runtime.

    Rate this question:

  • 22. 

    Is [your statement here] true or false?

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The given answer indicates that the statement mentioned in the question is true.

    Rate this question:

  • 23. 

    What is VSAM normalizer transformation?

    • The VSAM normalizer transformation is the source qualifier transformation for a COBOL source definition.

    • The VSAM normalizer transformation is the source qualifier transformation for a flat file source definition.

    • The VSAM normalizer transformation is the source qualifier transformation for a xml source definition.

    • None of these

    Correct Answer
    A. The VSAM normalizer transformation is the source qualifier transformation for a COBOL source definition.
    Explanation
    The VSAM normalizer transformation is a type of source qualifier transformation that is specifically used for a COBOL source definition. This transformation helps in extracting data from a VSAM file and normalizing it into a format that can be easily processed by downstream transformations and mappings in the data integration process. It is not used for flat file or XML source definitions.

    Rate this question:

  • 24. 

    What is default join of joiner?

    • Full Outer

    • Detail Outer

    • Normal

    • Master Outer

    Correct Answer
    A. Normal
    Explanation
    The default join of a joiner is "Normal". This means that the joiner performs an inner join, which returns only the matching records from both input data sets.

    Rate this question:

  • 25. 

    Can you start a batch within a batch?

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Yes, it is possible to start a batch within a batch. This is known as nested batching, where one batch is initiated within another batch. It allows for the execution of multiple batches simultaneously, improving efficiency and enabling complex operations to be performed.

    Rate this question:

  • 26. 

    Which are true sentences?

    • Active transformation is the one which do changes in no of rows.

    • Active transformation is the one which doesn't change in no of rows.

    • Passive transformation is the one which do changes in no of rows.

    • Passive transformation is the one which doesn't change in no of rows.

    Correct Answer(s)
    A. Active transformation is the one which do changes in no of rows.
    A. Passive transformation is the one which doesn't change in no of rows.
    Explanation
    Active transformations are the ones that make changes to the number of rows in the data, while passive transformations are the ones that do not change the number of rows.

    Rate this question:

  • 27. 

    Which one support heterogeneous join?

    • Source qualifier

    • Joiner

    • Look up

    Correct Answer
    A. Joiner
    Explanation
    A joiner transformation in data integration tools supports heterogeneous join, which means it can join data from different sources or tables with different data types. It allows for combining data from multiple sources based on a common key or condition, regardless of the data types or structures of the sources. This makes it a suitable option for joining data that originates from diverse systems or tables with varying formats, allowing for more flexible and comprehensive data integration processes.

    Rate this question:

  • 28. 

    How to Generate the Metadata Reports in Informatica?

    • From a browser on any workstation

    • Form repository

    • From Work flow manager

    Correct Answer
    A. From a browser on any workstation
    Explanation
    To generate the metadata reports in Informatica, you can use any workstation's browser. This means that you can access and generate these reports from any computer that has a browser installed. This flexibility allows users to generate the reports from various workstations, making it convenient and accessible for all users.

    Rate this question:

  • 29. 

    Can you generate sequence number without using sequence generator?

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Yes, it is possible to generate sequence numbers without using a sequence generator. One way to achieve this is by using a loop or a counter variable to increment the number each time it is needed. Another approach could be using a database feature like auto-increment or identity columns to automatically generate sequence numbers for each new record inserted. Additionally, some programming languages or frameworks may provide built-in functions or libraries to generate sequence numbers.

    Rate this question:

  • 30. 

    CHOOSE (2, 'Abcd', 'gef', 'ijk' ), What will this function return?

    • True

    • False

    • Gef

    • Ijk

    Correct Answer
    A. Gef
    Explanation
    The function will return "gef" because in the given list of options, "gef" is the second element.

    Rate this question:

  • 31. 

    Is Filter is case-sensitive?

    • Yes

    • No

    Correct Answer
    A. Yes
    Explanation
    Filters in general are case-sensitive, meaning that they distinguish between uppercase and lowercase letters. This means that if a filter is set to match a specific word or phrase, it will only match occurrences of that word or phrase with the exact same capitalization. For example, if a filter is set to match the word "apple", it will not match occurrences of "Apple" or "APPLE". Therefore, the answer to the question is "Yes".

    Rate this question:

  • 32. 

    If you are comparing two date using date_compare function, if two dates are equal then what will be returned?

    • 1

    • -1

    • 0

    • None

    Correct Answer
    A. 0
    Explanation
    If the two dates being compared using the date_compare function are equal, then the function will return 0.

    Rate this question:

  • 33. 

    What will happen if informatica server doesn't find session parameter and variable?

    • Work flow will fail

    • Automatically it will created

    • Give a message to user to put it

    • None of these

    Correct Answer
    A. Work flow will fail
    Explanation
    If the Informatica server does not find the session parameter and variable, the workflow will fail. This is because session parameters and variables are essential for the proper functioning of the workflow. Without them, the workflow will not have the necessary information and resources to execute successfully.

    Rate this question:

  • 34. 

    How many transformation you can use in your mapping?

    • 16

    • 16

    • Any number according to requirement

    • In Informatica 7 limited in 8 unlimited

    Correct Answer
    A. Any number according to requirement
    Explanation
    The correct answer is "Any number according to requirement." This means that there is no specific limit on the number of transformations that can be used in a mapping. The number of transformations that can be used will depend on the specific requirements of the mapping and the complexity of the data transformation process.

    Rate this question:

  • 35. 

    Which command has 60seconds time out period?

    • Stop

    • Abort

    • Kill session

    Correct Answer
    A. Abort
    Explanation
    The command "Abort" has a 60-second timeout period. This means that if the command is executed, it will be given a maximum of 60 seconds to complete its task before it is terminated or canceled. This timeout period ensures that the command does not run indefinitely and helps to prevent any potential issues or delays in the system.

    Rate this question:

  • 36. 

    Can start and stop single session in concurrent batch?

    • Yes

    • No

    Correct Answer
    A. Yes
    Explanation
    Yes, it is possible to start and stop a single session in a concurrent batch. In a concurrent batch, multiple sessions can run simultaneously, but each session can be controlled individually. Therefore, it is possible to start and stop a single session within the batch without affecting the other sessions running concurrently.

    Rate this question:

  • 37. 

    Which schema is normalized?

    • Star

    • Snowflake

    • Galaxy

    Correct Answer
    A. Snowflake
    Explanation
    The snowflake schema is normalized because it eliminates redundancy by breaking down dimensions into multiple tables. In this schema, the dimensions are normalized by creating separate tables for each level of the hierarchy. This helps in reducing data duplication and improves data integrity. The snowflake schema is commonly used in data warehousing to optimize query performance and storage efficiency.

    Rate this question:

  • 38. 

    What will o/p of this expression . 8 * 10 - NULL

    • 80

    • 8

    • 10

    • Null

    Correct Answer
    A. Null
    Explanation
    The output of the expression "8 * 10 - NULL" will be null. This is because when performing arithmetic operations, if any operand is null, the result will also be null. In this case, the subtraction operation is being performed after the multiplication operation, so the result of the multiplication is null. Therefore, subtracting null from any value will always result in null.

    Rate this question:

  • 39. 

    ROUND( 112.5676, 3 ). What will output of this expression?

    • 112

    • .567

    • 112.568

    • 112.6

    Correct Answer
    A. 112.568
    Explanation
    The expression ROUND(112.5676, 3) rounds the number 112.5676 to 3 decimal places. Since the digit in the fourth decimal place (7) is greater than or equal to 5, the rounding rule states that the digit in the third decimal place (6) should be increased by 1. Therefore, the output of this expression is 112.568.

    Rate this question:

  • 40. 

    Which of these are true?

    • Drill-down allows the users view higher level

    • Drill-down allows the users view lower level

    • Drill-up allows the users to view higher level

    • Drill-up allows the users to view lower level

    Correct Answer(s)
    A. Drill-down allows the users view lower level
    A. Drill-up allows the users to view higher level
    Explanation
    Drill-down refers to the action of navigating from a higher level of detail to a lower level of detail. It allows users to view more specific or granular information. On the other hand, drill-up refers to the action of navigating from a lower level of detail to a higher level of detail. It allows users to view a more summarized or aggregated view of the data. Therefore, the statement "Drill-down allows the users view lower level" is true, and the statement "drill-up allows the users to view higher level" is also true.

    Rate this question:

  • 41. 

    A lookup transformation is used to look up data in

    • Flat file

    • Relational table

    • View

    • Synonyms

    • All of the above

    Correct Answer
    A. All of the above
    Explanation
    A lookup transformation is a data integration technique used to retrieve data from different sources. It can be used to look up data in a flat file, relational table, view, or synonyms. By selecting "All of the above," it indicates that a lookup transformation can be used to retrieve data from any of these sources, providing a comprehensive and versatile solution for data retrieval.

    Rate this question:

  • 42. 

    What are the types of SQL queries you can specify in the SQL transformation?

    • Static

    • Dynamic

    • Cached

    Correct Answer(s)
    A. Static
    A. Dynamic
    Explanation
    In the SQL transformation, you can specify two types of SQL queries: static and dynamic. Static queries are predefined and do not change during runtime. They are usually used for simple and straightforward operations. On the other hand, dynamic queries are generated during runtime and can vary based on certain conditions or user input. They provide more flexibility and are suitable for complex operations that require dynamic changes. Cached queries are not a type of SQL query, so they are not applicable in this context.

    Rate this question:

  • 43. 

    Dimension tables are denormalized in nature ? True or False

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Dimension tables are denormalized in nature because they contain redundant data and are structured to optimize query performance. Denormalization involves combining multiple tables into a single table to eliminate the need for joins and improve data retrieval speed. In dimension tables, attributes are stored in a flat structure, making it easier to access and analyze data. This approach is commonly used in data warehousing and business intelligence systems, where query performance is crucial. By denormalizing dimension tables, it becomes easier to perform complex analyses and generate reports efficiently.

    Rate this question:

  • 44. 

    Which transformation enables you to connect to an HTTP server to use its services and applications?

    • Ftp

    • Http

    • Custom

    • Java

    Correct Answer
    A. Http
    Explanation
    HTTP (Hypertext Transfer Protocol) is the correct answer because it is the protocol used for connecting to an HTTP server to access its services and applications. FTP (File Transfer Protocol) is used for transferring files, not for connecting to an HTTP server. Custom and Java are not specific transformations or protocols used for connecting to an HTTP server.

    Rate this question:

  • 45. 

    If you want to run a second session only if the first session completes successfully, then which task you should use?

    • Timer

    • Assign

    • Decisions

    • Link

    Correct Answer
    A. Decisions
    Explanation
    To run a second session only if the first session completes successfully, the appropriate task to use is "decisions". The decisions task allows for conditional branching based on the outcome of a previous task. In this case, the first session would be the previous task, and the decision task would evaluate whether it was successful or not. If it was successful, the decision task would proceed to the second session. If it was not successful, the decision task could be configured to take a different path or terminate the workflow.

    Rate this question:

  • 46. 

    What is lookup table?

    • Stores the update record based on lookup condition

    • Stores the new record based on lookup condition

    • Stores the new record or update record based on lookup condition

    • None of these

    Correct Answer
    A. Stores the new record or update record based on lookup condition
    Explanation
    A lookup table is a data structure that stores a set of values and their corresponding key or index. In this case, the correct answer states that a lookup table stores both new records and update records based on a lookup condition. This means that the table can be used to insert new records into the table or update existing records based on a specific condition.

    Rate this question:

  • 47. 

    Which variable counts the rows evaluated by the function and increments the current value of a mapping based on the count?

    • SETMINVARIABLE

    • SETVARIABLE

    • SETCOUNTVARIABLE

    • NONE OF THESE

    Correct Answer
    A. SETCOUNTVARIABLE
    Explanation
    The variable that counts the rows evaluated by the function and increments the current value of a mapping based on the count is SETCOUNTVARIABLE. This variable is responsible for keeping track of the number of rows processed and updating the value of a mapping accordingly.

    Rate this question:

  • 48. 

    Which of these is not a ETL tools in the Market?

    • Decision

    • DataStage

    • Stream

    • Beacon

    Correct Answer
    A. Beacon
    Explanation
    The question asks for a tool that is not an ETL tool in the market. DataStage and Stream are both well-known ETL tools used for data integration and transformation. Decision is not a commonly known ETL tool, but Beacon is not a recognized ETL tool in the market, making it the correct answer.

    Rate this question:

  • 49. 

    Which transformation receives input values from the result of a :LKP expression in another transformation?

    • Custom

    • Connected SP

    • Unconnected Look-up

    • None of these

    Correct Answer
    A. Unconnected Look-up
    Explanation
    Unconnected Look-up transformation receives input values from the result of a :LKP expression in another transformation. Unlike the Connected Look-up transformation, the Unconnected Look-up transformation is not connected directly to the pipeline. Instead, it is used within an expression or a transformation and is called using a LKP function. This allows the Unconnected Look-up to retrieve and use data from another transformation, making it the correct answer for this question.

    Rate this question:

Quiz Review Timeline (Updated): Mar 22, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jan 03, 2019
    Quiz Created by
    Swapdeo
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.