1.
Which one is not correct about filter transformation?
Correct Answer
B. Can't passes multiple conditions
Explanation
Filter transformation acts as a 'where' condition in data integration tools, allowing only the rows that meet the specified condition to pass through. It can be used to filter out unwanted data based on a single condition. However, it is not capable of passing multiple conditions simultaneously. Therefore, the statement "Can't passes multiple conditions" is correct about filter transformation.
2.
Can we calculate in aggregator ?
Correct Answer
B. 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.
3.
Which one is not a type of fact?
Correct Answer
C. Confirm fact
Explanation
A "confirm fact" is not a type of fact. In data warehousing, facts are the measurable and quantifiable data that represent business transactions or events. Semi-additive and additive facts are types of facts that can be aggregated, whereas "confirm fact" is not recognized as a valid type of fact in this context. "Not additive" is not a type of fact either, but it is not the correct answer in this case.
4.
Which one is not a type of dimension ?
Correct Answer
B. Rapidly changing dimension
Explanation
A rapidly changing dimension refers to a dimension in a data warehouse that frequently undergoes updates or changes. This type of dimension is used to track historical changes in data over time. However, all the other options mentioned in the question are valid types of dimensions. A confirmed dimension represents a dimension that has been verified and validated. A junk dimension combines multiple low-cardinality attributes into a single dimension to reduce the number of dimensions in a data model. A degenerated dimension is a dimension that is derived from a fact table and does not have its own separate dimension table.
5.
Which of these not correct about Code Page?
Correct Answer
B. A code page contains decoding to specify characters in a set of one or more languages
Explanation
A code page contains encoding, not decoding, to specify characters in a set of one or more languages. Encoding is the process of converting characters into a specific representation, such as numeric values or binary codes, while decoding is the process of converting these representations back into characters. Therefore, the given answer correctly states that decoding is not a function of a code page.
6.
What is a mapplet?
Correct Answer
C. Set of transformations and it allows us to reuse
Explanation
A mapplet is a set of transformations that can be reused in multiple mappings. It allows us to create a group of transformations and save them as a single object, which can be easily added to different mappings. This helps in reducing redundancy and improving efficiency in the ETL (Extract, Transform, Load) process.
7.
What does reusable transformation mean?
Correct Answer
D. 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.
8.
Which one is not an option in update strategy?
Correct Answer
B. 4
9.
Can we update records without using update strategy?
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.
10.
How to select distinct records form Source Qualifier?
Correct Answer
B. Choose 'select distinct' option
Explanation
To select distinct records from the Source Qualifier, the correct option is to choose the 'select distinct' option. This option ensures that only unique records are retrieved from the source, eliminating any duplicates. By selecting this option, the Source Qualifier will filter out any duplicate records, providing a result set with only distinct records.
11.
What type of repository is no available in Informatica Repository Manager?
Correct Answer
C. User Defined
Explanation
Informatica Repository Manager does not have a specific repository type called "User Defined". This means that there is no option to create a custom or user-defined repository in Informatica Repository Manager.
12.
Joiner does not support flat file.
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.
13.
How to execute PL/SQL script from Informatica mapping?
Correct Answer
B. 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.
14.
NetSal= bassic+hra. In which transformation we can achive this?
Correct Answer
D. 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.
15.
Which one is not an active transformation?
Correct Answer
A. Sequence generator
Explanation
A sequence generator is not an active transformation because it does not change or modify the data in any way. Instead, it generates a sequential number for each row of data. Active transformations, on the other hand, perform operations that alter the data, such as filtering, aggregating, or joining. Normalizer, SQL, and stored procedure are all examples of active transformations as they manipulate the data in some way.
16.
A lookup transformation is used to look up data in
Correct Answer
E. 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.
17.
Which value returned by NewLookupRow port says that Integration Service does not update or insert the
row in the cache?
Correct Answer
D. 0
Explanation
The value returned by the NewLookupRow port as 0 indicates that the Integration Service will not update or insert the row in the cache.
18.
Which one needs a common key to join?
Correct Answer
B. 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.
19.
Which one support heterogeneous join?
Correct Answer
B. 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.
20.
What is the use of target loader?
Correct Answer
A. Target load order is first the data is load in dimension table and then fact table.
Explanation
The use of target loader is to determine the order in which data is loaded into the dimension and fact tables. In this case, the correct answer states that the data is first loaded into the dimension table and then into the fact table. This order is important because the dimension table contains the reference data that is needed for the fact table, which contains the actual data. By loading the dimension table first, the necessary reference data is available when loading the fact table.
21.
Which one is not tracing level?
Correct Answer
E. Terse initialization
Explanation
The term "tracing level" refers to the level of detail or verbosity in a system's output or logs. "terse" and "verbose" are both tracing levels, as they represent different levels of detail in the output. "initialization" is not a tracing level, but rather a process or event that occurs during the system's startup. "verbose initialization" and "terse initialization" are not tracing levels either, but rather combinations of a tracing level and the initialization process. Therefore, the correct answer is "terse initialization" because it is not a tracing level on its own.
22.
Which output file is not created during session running?
Correct Answer
E. Cache files
Explanation
During a session running, various files are generated to track the progress and identify any errors or issues. The session log keeps a record of the session's activities and can be used for debugging purposes. The workflow log records the details of the workflow execution. The error log captures any errors encountered during the session. The bad files store data that fails to meet certain criteria. However, cache files are not created during session running. They are used to store temporary data for faster access and are typically created during the workflow design process.
23.
Is Fact table is normalized?
Correct Answer
B. No
Explanation
Fact tables in a data warehouse are typically not normalized. Normalization involves breaking down data into multiple tables to eliminate redundancy and improve efficiency. However, fact tables in a data warehouse are designed to store large amounts of data related to specific events or transactions. These tables often contain denormalized data to optimize query performance and simplify complex joins. By denormalizing the data, it becomes easier and faster to retrieve information from the fact table for analytical purposes.
24.
Which value returned by NewLookupRow port says that Integration Service inserts the row into the
cache?
Correct Answer
B. 1
Explanation
The value returned by the NewLookupRow port that says the Integration Service inserts the row into the cache is 1.
25.
Which transformation only works on relational source?
Correct Answer
D. Sql
Explanation
Sql is the only transformation that works on relational sources. SQL (Structured Query Language) is a programming language designed for managing data held in relational database management systems (RDBMS). It allows users to query, manipulate, and manage relational databases effectively. The other options, lookup, union, and joiner, are generic transformations that can work with various types of data sources, not just relational sources.
26.
Which are both connected and unconnected?
Correct Answer(s)
A. External Store Procedure
B. Stored Procedure
C. Lookup
Explanation
Both External Store Procedure and Stored Procedure can be connected and unconnected. They can be used as a part of a data integration or transformation process, where they are connected to other components in a workflow. Additionally, they can also be used independently, without being connected to other components, to perform specific tasks or operations. On the other hand, Lookup is typically a connected component that is used to retrieve data from a reference table or source based on matching criteria. Advanced External Procedure Transformation is not a valid term or component in this context.
27.
Can we generate alpha-numeric value in sequence generator?
Correct Answer
B. No
Explanation
The answer is "No" because a sequence generator can only generate numeric values in a sequence. It cannot generate alpha-numeric values, which include both letters and numbers.
28.
Which transformation is used by COBOL source?
Correct Answer
D. Normalizer
Explanation
The correct answer is "Normalizer". A normalizer is a transformation used in COBOL source to convert data from one format to another, typically by removing inconsistencies, redundancies, or anomalies in the data. It helps to standardize and organize the data in a consistent manner, making it easier to process and analyze.
29.
What is VSAM normalizer transformation?
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.
30.
What is the default source option for update strategy?
Correct Answer
D. Date Driven
Explanation
The default source option for update strategy is "Date Driven". This means that the update strategy will determine whether a record should be updated or inserted based on the date information in the source data. If the date in the source data is more recent than the date in the target system, the record will be updated. If the date in the source data is older or equal to the date in the target system, the record will be inserted.
31.
What are the different values returned by NewLookupRow port?
Correct Answer
B. 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.
32.
Which are lookup caches?
Correct Answer(s)
A. Persistent cache
B. Dynamic cache
C. Pre-build lookup cache
D. Shared Cache
Explanation
The given answer options are all types of lookup caches. A lookup cache is a mechanism used to store and retrieve data that is frequently accessed in order to improve performance. Persistent cache refers to a cache that retains its data even after a system restart. Dynamic cache is a cache that can be updated or modified dynamically. Pre-build lookup cache is a cache that is built in advance based on predefined criteria. Shared cache is a cache that can be accessed and used by multiple users or processes. Therefore, all the options listed in the answer are types of lookup caches.
33.
Which value returned by NewLookupRow port says that Integration Service updates the row in the
cache?
Correct Answer
C. 2
Explanation
The value returned by the NewLookupRow port that says the Integration Service updates the row in the cache is 2.
34.
What are the types of SQL queries you can specify in the SQL transformation?
Correct Answer(s)
A. Static
B. 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.
35.
What is meaning of tracing level?
Correct Answer
C. Data store in log file
Explanation
Tracing level refers to the level of detail or verbosity in the information stored in a log file. When the tracing level is set to store data in a log file, it means that detailed information about the execution of a program or system is being recorded in a log file. This can include information such as debug messages, error messages, and other relevant data that can be used for troubleshooting and analysis purposes. Storing data in a log file allows developers and administrators to review and analyze the log file later to understand the behavior of the system and identify any issues or errors that occurred during its execution.
36.
Which command has 60seconds time out period?
Correct Answer
B. 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.
37.
Which command is similar to 'kill' command in Unix?
Correct Answer
B. 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.
38.
Which one contains input and output transformations?
Correct Answer
A. Mapplet
Explanation
A mapplet in Informatica is a reusable object that contains a set of transformations. It can be used in multiple mappings to perform input and output transformations on data. This means that a mapplet contains both input and output transformations, making it the correct answer to the question. Reusable transformations and reusable mappings may contain transformations, but they do not specifically mention input and output transformations, so they are not the correct answer.
39.
Which one can test multiple conditions?
Correct Answer
C. If
Explanation
The "if" statement can test multiple conditions. It allows for the execution of a block of code if a certain condition is true. It can also be followed by an "else if" statement to test additional conditions, or an "else" statement to provide a default action if none of the conditions are met. Therefore, the "if" statement is the correct answer for this question.
40.
Which dimension is collection of random transactional codes, flags and/or text attributes ?
Correct Answer
C. Junk
Explanation
The dimension that is a collection of random transactional codes, flags, and/or text attributes is the "junk" dimension. This dimension is used to store miscellaneous or unrelated attributes that do not fit into any other dimension. It helps in reducing the complexity of the main dimensions by separating out unrelated attributes into a separate dimension.
41.
Which one is not a target Option for file on the Servers?
Correct Answer
D. ERP
Explanation
ERP (Enterprise Resource Planning) is not a target option for file on the servers. ERP is a software system used by organizations to manage and integrate various aspects of their business, such as finance, human resources, and supply chain. It is not specifically designed for file storage or transfer like the other options mentioned (FTP, Loader, MQ). ERP systems are typically used for data management and processing within an organization, rather than for file-related operations.
42.
Which one is not a designer tool creating transformations?
Correct Answer
D. Target designer
Explanation
The question asks for a designer tool that is not used for creating transformations. The options given are Transformation developer, Mapping designer, Mapplet designer, and Target designer. The correct answer is "Target designer" because it is not a tool specifically used for creating transformations. The Transformation developer is responsible for creating transformations, the Mapping designer is used to design mappings, and the Mapplet designer is used for creating mapplets. However, the Target designer is primarily used for designing target tables and not for creating transformations.
43.
Which one is not a scheduling options to run a session?
Correct Answer
C. Run in six-month
Explanation
"Run in six-month" is not a scheduling option to run a session because it does not specify a specific frequency or interval for the session to be run. The other options, such as "Run only on demand," "Run once," "Run every," and "Customized repeat," provide specific scheduling options for running a session either on-demand, once, at regular intervals, or with a customized repeat pattern.
44.
Which one manages connections to the repository from client application?
Correct Answer
A. Informatica Repository
Explanation
The Informatica Repository manages connections to the repository from client applications. This means that it is responsible for handling the communication and interaction between the client application and the repository. The repository is where all the metadata, such as mappings, transformations, and workflows, are stored. Therefore, the Informatica Repository plays a crucial role in ensuring that the client application can access and retrieve the necessary information from the repository efficiently and securely.
45.
How to Generate the Metadata Reports in Informatica?
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.
46.
Which one is not Target Types on the Server?
Correct Answer
D. Vsam
Explanation
The options given are different types of target types on the server. File, Relational, and ERP are all valid target types on the server. However, VSAM is not a valid target type on the server.
47.
What are the processes to do join the tables if the tables have no primary and foreign key relation and
no matching port to join?
Correct Answer(s)
A. Add one dummy port in two sources.
B. Use Joiner transformation to join the sources using dummy port
D. In expression trans assign '1' to each port
Explanation
The correct answer suggests adding a dummy port in both sources, using a Joiner transformation to join the sources using the dummy port, and using an expression transformation to assign '1' to each port. This approach allows for joining the tables even if they have no primary and foreign key relation and no matching port to join. By adding a dummy port, the Joiner transformation can be used to perform the join operation, and the expression transformation can be used to assign a common value to each port for the join.
48.
Can start and stop single session in concurrent batch?
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.
49.
Can you copy the batches?
Correct Answer
B. No
Explanation
The correct answer is "No" because the question asks if it is possible to copy the batches. Since the answer options are "Yes" and "No", selecting "No" implies that it is not possible to copy the batches.
50.
What are the processes that informatica runs the session?
Correct Answer(s)
A. DTM
C. Load Manager Process
Explanation
The processes that Informatica runs during a session are the DTM (Data Transformation Manager) process and the Load Manager process. The DTM process is responsible for executing the data transformation logic and managing the flow of data between sources, transformations, and targets. The Load Manager process handles the loading of data into the target systems and manages the session resources. These processes work together to ensure the successful execution of the session and the proper handling of data transformations and loading.