Informatica 220

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Swapdeo
S
Swapdeo
Community Contributor
Quizzes Created: 1 | Total Attempts: 2,863
Questions: 219 | Attempts: 2,875

SettingsSettingsSettings
Company Quizzes & Trivia

A quiz created by Swapnil and Ajay for practice of Informatica


Questions and Answers
  • 1. 

    Which one is not correct about filter transformation?

    • A.

      Act as a 'where' condition

    • B.

      Can't passes multiple conditions

    • C.

      Act like 'Case' in pl/sql

    • D.

      If one record does not match condition, the record is blocked

    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.

    Rate this question:

  • 2. 

    Can we calculate in aggregator ?

    • A.

      No

    • B.

      Yes

    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.

    Rate this question:

  • 3. 

    Which one is not a type of fact?

    • A.

      Semi-additive

    • B.

      Additive

    • C.

      Confirm fact

    • D.

      Not additive

    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.

    Rate this question:

  • 4. 

    Which one is not a type of dimension ?

    • A.

      Confirmed dimension

    • B.

      Rapidly changing dimension

    • C.

      Junk dimension

    • D.

      Degenerated 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.

    Rate this question:

  • 5. 

    Which of these not correct about Code Page?

    • A.

      A code page contains encoding to specify characters in a set of one or more languages

    • B.

      A code page contains decoding to specify characters in a set of one or more languages

    • C.

      In this way application stores, receives, and sends character data.

    • D.

      None of these

    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.

    Rate this question:

  • 6. 

    What is a mapplet?

    • A.

      Combination of reusable transformation.

    • B.

      Combination of reusable mapping

    • C.

      Set of transformations and it allows us to reuse

    • D.

      None of these

    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.

    Rate this question:

  • 7. 

    What does reusable transformation mean?

    • A.

      It can be re-used across repositories

    • B.

      I can only be used in mapplet.

    • C.

      It can use in multiple mapping only once

    • D.

      It can use in multiple mapping multiple times

    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.

    Rate this question:

  • 8. 

    Which one is not an option in update strategy?

    • A.

      Dd_reject

    • B.

      4

    • C.

      2

    • D.

      Dd_delete

    Correct Answer
    B. 4
  • 9. 

    Can we update records without using update strategy?

    • A.

      Yes

    • B.

      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:

  • 10. 

    How to select distinct records form Source Qualifier?

    • A.

      Choose 'non duplicate' option

    • B.

      Choose 'select distinct' option

    • C.

      Choose 'Select non duplicate'

    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.

    Rate this question:

  • 11. 

    What type of repository is no available in Informatica Repository Manager?

    • A.

      Standalone Repository

    • B.

      Local Repository

    • C.

      User Defined

    • D.

      Versioned Repository

    • E.

      Manual Repository

    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.

    Rate this question:

  • 12. 

    Joiner does not support flat file.

    • A.

      False

    • B.

      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:

  • 13. 

    How to execute PL/SQL script from Informatica mapping?

    • A.

      Lookup

    • B.

      Store Procedure

    • C.

      Expression

    • D.

      None of these

    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.

    Rate this question:

  • 14. 

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

    • A.

      Aggregator

    • B.

      Lookup

    • C.

      Filter

    • D.

      Expression

    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.

    Rate this question:

  • 15. 

    Which one is not an active transformation?

    • A.

      Sequence generator

    • B.

      Normalizer

    • C.

      Sql

    • D.

      Store Procedure

    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.

    Rate this question:

  • 16. 

    A lookup transformation is used to look up data in

    • A.

      Flat file

    • B.

      Relational table

    • C.

      View

    • D.

      Synonyms

    • E.

      All of the above

    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.

    Rate this question:

  • 17. 

    Which value returned by NewLookupRow port says that Integration Service does not update or insert the row in the cache?

    • A.

      3

    • B.

      2

    • C.

      1

    • D.

      0

    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.

    Rate this question:

  • 18. 

    Which one needs a common key to join?

    • A.

      Source qualifier

    • B.

      Joiner

    • C.

      Look up

    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.

    Rate this question:

  • 19. 

    Which one support heterogeneous join?

    • A.

      Source qualifier

    • B.

      Joiner

    • C.

      Look up

    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.

    Rate this question:

  • 20. 

    What is the use of target loader?

    • A.

      Target load order is first the data is load in dimension table and then fact table.

    • B.

      Target load order is first the data is load in fact table and then dimensional table.

    • C.

      Load the data from different target at same time.

    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.

    Rate this question:

  • 21. 

    Which one is not tracing level?

    • A.

      Terse

    • B.

      Verbose

    • C.

      Initialization

    • D.

      Verbose initialization

    • E.

      Terse initialization

    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.

    Rate this question:

  • 22. 

    Which output file is not created during session running?

    • A.

      Session log

    • B.

      Workflow log

    • C.

      Error log

    • D.

      Bad files

    • E.

      Cache files

    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.

    Rate this question:

  • 23. 

    Is Fact table is normalized?

    • A.

      Yes

    • B.

      No

    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.

    Rate this question:

  • 24. 

    Which value returned by NewLookupRow port says that Integration Service inserts the row into the cache?

    • A.

      0

    • B.

      1

    • C.

      2

    • D.

      3

    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.

    Rate this question:

  • 25. 

    Which transformation only works on relational source?

    • A.

      Lookup

    • B.

      Union

    • C.

      Joiner

    • D.

      Sql

    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.

    Rate this question:

  • 26. 

    Which are both connected and unconnected?

    • A.

      External Store Procedure

    • B.

      Stored Procedure

    • C.

      Lookup

    • D.

      Advanced External Procedure Transformation

    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.

    Rate this question:

  • 27. 

    Can we generate alpha-numeric value in sequence generator?

    • A.

      Yes

    • B.

      No

    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.

    Rate this question:

  • 28. 

    Which transformation is used by COBOL source?

    • A.

      Advanced External Procedure Transformation

    • B.

      Cobol Transformation

    • C.

      Unstructured Data Transformation

    • D.

      Normalizer

    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.

    Rate this question:

  • 29. 

    What is VSAM normalizer transformation?

    • A.

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

    • B.

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

    • C.

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

    • D.

      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:

  • 30. 

    What is the default source option for update strategy?

    • A.

      Update or Delete

    • B.

      Update or Insert

    • C.

      Insert or Update

    • D.

      Date Driven

    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.

    Rate this question:

  • 31. 

    What are the different values returned by NewLookupRow port?

    • A.

      0,1,3

    • B.

      0,1,2

    • C.

      1,2,3

    • D.

      2,3,4

    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.

    Rate this question:

  • 32. 

    Which are lookup caches?

    • A.

      Persistent cache

    • B.

      Dynamic cache

    • C.

      Pre-build lookup cache

    • D.

      Shared Cache

    • E.

      None of these

    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.

    Rate this question:

  • 33. 

    Which value returned by NewLookupRow port says that Integration Service updates the row in the cache?

    • A.

      0

    • B.

      1

    • C.

      2

    • D.

      4

    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.

    Rate this question:

  • 34. 

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

    • A.

      Static

    • B.

      Dynamic

    • C.

      Cached

    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.

    Rate this question:

  • 35. 

    What is meaning of tracing level?

    • A.

      Data store in cache

    • B.

      Data store in database

    • C.

      Data store in log file

    • D.

      Data store in buffer

    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.

    Rate this question:

  • 36. 

    Which command has 60seconds time out period?

    • A.

      Stop

    • B.

      Abort

    • C.

      Kill session

    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.

    Rate this question:

  • 37. 

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

    • A.

      Stop

    • B.

      Abort

    • C.

      Kill session

    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.

    Rate this question:

  • 38. 

    Which one contains input and output transformations?

    • A.

      Mapplet

    • B.

      Reusable transformation

    • C.

      Reusable mapping

    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.

    Rate this question:

  • 39. 

    Which one can test multiple conditions?

    • A.

      Decode

    • B.

      Else if

    • C.

      If

    • D.

      None of these

    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.

    Rate this question:

  • 40. 

    Which dimension is collection of random transactional codes, flags and/or text attributes ?

    • A.

      Degenerated

    • B.

      Scd

    • C.

      Junk

    • D.

      Confirmed

    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.

    Rate this question:

  • 41. 

    Which one is not a target Option for file on the Servers?

    • A.

      FTP

    • B.

      Loader

    • C.

      MQ

    • D.

      ERP

    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.

    Rate this question:

  • 42. 

    Which one is not a designer tool creating transformations?

    • A.

      Transformation developer

    • B.

      Mapping designer

    • C.

      Mapplet designer.

    • D.

      Target designer

    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.

    Rate this question:

  • 43. 

    Which one is not a scheduling options to run a session?

    • A.

      Run only on demand

    • B.

      Run once

    • C.

      Run in six-month

    • D.

      Run every

    • E.

      Customized repeat

    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.

    Rate this question:

  • 44. 

    Which one manages connections to the repository from client application?

    • A.

      Informatica Repository

    • B.

      Informatica Server

    • C.

      Repository manager

    • D.

      All of these

    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.

    Rate this question:

  • 45. 

    How to Generate the Metadata Reports in Informatica?

    • A.

      From a browser on any workstation

    • B.

      Form repository

    • C.

      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:

  • 46. 

    Which one is not Target Types on the Server?

    • A.

      File

    • B.

      Relational

    • C.

      ERP

    • D.

      Vsam

    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.

    Rate this question:

  • 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?

    • A.

      Add one dummy port in two sources.

    • B.

      Use Joiner transformation to join the sources using dummy port

    • C.

      Use Union

    • D.

      In expression trans assign '1' to each port

    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.

    Rate this question:

  • 48. 

    Can start and stop single session in concurrent batch?

    • A.

      Yes

    • B.

      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:

  • 49. 

    Can you copy the batches?

    • A.

      Yes

    • B.

      No

    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.

    Rate this question:

  • 50. 

    What are the processes that informatica runs the session?

    • A.

      DTM

    • B.

      Server Manager Process

    • C.

      Load Manager Process

    • D.

      Server Configuration Process

    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.

    Rate this question:

Quiz Review Timeline +

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.