Informatica 220
-
How to select distinct records form Source Qualifier?
-
Choose 'non duplicate' option
-
Choose 'select distinct' option
-
Choose 'Select non duplicate'
-
About This Quiz
A quiz created by Swapnil and Ajay for practice of Informatica
Quiz Preview
- 2.
LEAST( 12, 13, 21 ) what will output?
-
40
-
25
-
12
-
21
Correct Answer
A. 12Explanation
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. ExpressionExplanation
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 ProcedureExplanation
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. JoinerExplanation
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. YesExplanation
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. YesExplanation
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. YesExplanation
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. AvgExplanation
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. TrueExplanation
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. YesExplanation
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.0Explanation
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 timesExplanation
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. FalseExplanation
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,2Explanation
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. AbortExplanation
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 workstationExplanation
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 ReportExplanation
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. TrueExplanation
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. NormalExplanation
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. TrueExplanation
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. JoinerExplanation
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 workstationExplanation
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. TrueExplanation
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. GefExplanation
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. YesExplanation
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. 0Explanation
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 failExplanation
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 requirementExplanation
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. AbortExplanation
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. YesExplanation
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 transformation enables you to connect to an HTTP server to use its services and applications?
-
Ftp
-
Http
-
Custom
-
Java
Correct Answer
A. HttpExplanation
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:
-
- 38.
Which schema is normalized?
-
Star
-
Snowflake
-
Galaxy
Correct Answer
A. SnowflakeExplanation
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:
-
- 39.
What will o/p of this expression . 8 * 10 - NULL
-
80
-
8
-
10
-
Null
Correct Answer
A. NullExplanation
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:
-
- 40.
ROUND( 112.5676, 3 ). What will output of this expression?
-
112
-
.567
-
112.568
-
112.6
Correct Answer
A. 112.568Explanation
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:
-
- 41.
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 levelExplanation
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:
-
- 42.
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 aboveExplanation
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:
-
- 43.
What are the types of SQL queries you can specify in the SQL transformation?
-
Static
-
Dynamic
-
Cached
Correct Answer(s)
A. Static
A. DynamicExplanation
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:
-
- 44.
Dimension tables are denormalized in nature ? True or False
-
True
-
False
Correct Answer
A. TrueExplanation
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:
-
- 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. DecisionsExplanation
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 conditionExplanation
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. SETCOUNTVARIABLEExplanation
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. BeaconExplanation
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-upExplanation
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, 2023Quiz Edited by
ProProfs Editorial Team -
Jan 03, 2019Quiz Created by
Swapdeo
Back to top