Skip to main content

Informatica Quiz: Set 2



                                                                                                                                                                      
Quiz: Informatica Set 2
A lookup transformation is used to look up data in

Explanation:
  • flat file
  • Relational table
  • view
  • synonyms
  • All of the above (correct)

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

Explanation:
  • 3 (wrong)
  • 2
  • 1
  • 0

Which one need a common key to join?

Explanation:
  • source qualifier
  • joiner (correct)
  • look up

Which one support hetrogeneous join?

Explanation:
  • source qualifier
  • joiner (correct)
  • look up

What is the use of target loader?

Explanation:
  • Target load order is first the data is load in dimension table and then fact table.
  • Target load order is first the data is load in fact table and then dimensional table.
  • Load the data from different target at same time. (wrong)

Which one is not tracing level?

Explanation:
  • terse
  • verbose
  • initialization
  • verbose initialization
  • terse initialization (correct)

Which output file is not created during  session running?

Explanation:
  • Session log
  • workflow log
  • Error log
  • Bad files
  • cache files (correct)

Is Fact table is normalised ?

Explanation:
  • yes
  • no (correct)

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

Explanation:
  • 0 (wrong)
  • 1
  • 2
  • 3

Which transformation only works on relational source?


Explanation:
  • lookup
  • Union
  • joiner
  • Sql (correct)

Which are  both connected and unconnected?

Explanation:
  • External Store Procedure (omitted)
  • Stote Procedure (correct)
  • Lookup (correct)
  • Advanced External Procedure Transformation

Can we generate alpha-numeric value in sequence generator?

Explanation:
  • yes
  • no (correct)

Which transformation is used by cobol source?

Explanation:
  • Advanced External Procedure Transformation
  • Cobol Transformation
  • Unstructured Data Transformation
  • Normalizer (correct)

What is VSAM normalizer transformation?

Explanation:
  • 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. (wrong)
  • Non of these

What is VSAM normalizer transformation?

Explanation:
  • 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. (wrong)
  • Non of these

                                                                                                                                                                      

Comments

  1. Kritapa karmakarJune 4, 2020 at 9:50 PM


    Your Session results

    Quiz: Informatica Set 2

    Score: 91.13% (input issues not assessed are not counted in the score!)

    Unanswered: 0


    A lookup transformation is used to look up data in


    Explanation:
    flat file
    Relational table
    view
    synonyms
    All of the above (correct)


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


    Explanation:
    3
    2
    1
    0 (correct)


    Which one need a common key to join?


    Explanation:
    source qualifier
    joiner (correct)
    look up


    Which one support hetrogeneous join?


    Explanation:
    source qualifier
    joiner (correct)
    look up


    What is the use of target loader?


    Explanation:
    Target load order is first the data is load in dimension table and then fact table. (correct)
    Target load order is first the data is load in fact table and then dimensional table.
    Load the data from different target at same time.


    Which one is not tracing level?


    Explanation:
    terse
    verbose
    initialization
    verbose initialization
    terse initialization (correct)


    Which output file is not created during session running?


    Explanation:
    Session log
    workflow log
    Error log
    Bad files
    cache files (correct)


    Is Fact table is normalised ?


    Explanation:
    yes (wrong)
    no


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


    Explanation:
    0
    1 (correct)
    2
    3


    Which transformation only works on relational source?



    Explanation:
    lookup
    Union
    joiner
    Sql (correct)


    Which are both connected and unconnected?


    Explanation:
    External Store Procedure (omitted)
    Stote Procedure (correct)
    Lookup (correct)
    Advanced External Procedure Transformation


    Can we generate alpha-numeric value in sequence generator?


    Explanation:
    yes
    no (correct)


    Which transformation is used by cobol source?


    Explanation:
    Advanced External Procedure Transformation
    Cobol Transformation
    Unstructured Data Transformation
    Normalizer (correct)


    What is VSAM normalizer transformation?


    Explanation:
    The VSAM normalizer transformation is the source qualifier transformation for a COBOL source definition. (correct)
    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.
    Non of these


    What is VSAM normalizer transformation?


    Explanation:
    The VSAM normalizer transformation is the source qualifier transformation for a COBOL source definition. (correct)
    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.
    Non of these

    ReplyDelete

Post a Comment

Popular posts from this blog

SQL Transformation with examples

============================================================================================= SQL Transformation with examples   Use : SQL Transformation is a connected transformation used to process SQL queries in the midstream of a pipeline . We can insert, update, delete and retrieve rows from the database at run time using the SQL transformation. Use SQL transformation in script mode to run DDL (data definition language) statements like creating or dropping the tables. The following SQL statements can be used in the SQL transformation. Data Definition Statements (CREATE, ALTER, DROP, TRUNCATE, RENAME) DATA MANIPULATION statements (INSERT, UPDATE, DELETE, MERGE) DATA Retrieval Statement (SELECT) DATA Control Language Statements (GRANT, REVOKE) Transaction Control Statements (COMMIT, ROLLBACK) Scenario: Let’s say we want to create a temporary table in mapping while workflow is running for some intermediate calculation. We can use SQL transformat...
1 comment
Read more

Load the session statistics such as Session Start & End Time, Success Rows, Failed Rows and Rejected Rows etc. into a database table for audit/log purpose.

                                                                                                                                                                     ...
Post a Comment
Read more

CMN_1650 A duplicate row was attempted to be inserted into a dynamic lookup cache Dynamic lookup error.

Scenario: I have 2 ports going through a dynamic lookup, and then to a router. In the router it is a simple case of inserting new target rows (NewRowLookup=1) or rejecting existing rows (NewRowLookup=0). However, when I run the session I'm getting the error: "CMN_1650 A duplicate row was attempted to be inserted into a dynamic lookup cache Dynamic lookup error. The dynamic lookup cache only supports unique condition keys." I thought that I was bringing through duplicate values so I put a distinct on the SQ. There is also a not null filter on both ports. However, whilst investigating the initial error that is logged for a specific pair of values from the source, there is only 1 set of them (no duplicates). The pair exists on the target so surely should just return from the dynamic lookup newrowlookup=0. Is this some kind of persistent data in the cache that is causing this to think that it is duplicate data? I haven't got the persistent cache or...
Post a Comment
Read more