Click To Get Off-Campus Placement Jobs Info !!!
FREE!!! Latest Nagarro FULL Aptitude Mock Test for Practice
Practice 5+ Mettl Aptitude Mock Test

Technical Interview Questions and Answers :: Informatica

    31 / 94

    How are dimension and fact tables created?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    32 / 94

    Different types of facts.
    Answer:

    Type of facts are:

    Additive: Additive facts are facts that can be summed up through all of the
    dimensions in the fact table. A sales fact is a good example for
    additive fact.

    Semi-Additive:Semi-additive facts are facts that can be summed up for some of the dimensions in the fact table, but not the others.

    Eg: Daily balances fact can be summed up through the customers dimension but not through the time dimension.

    Non-Additive:



    Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table.

    Eg: Facts which have percentages, ratios calculated.

    Please Login First :

    33 / 94

    Perform operations in flat file(Ex: how to pull n records from flat file)
    Answer:

    No Discussion on this question yet!

    Please Login First :

    34 / 94

    Difference in connected and unconnected lookup.
    Answer:

    No Discussion on this question yet!

    Please Login First :

    35 / 94

    What happens if group by is not selected in aggregator.
    Answer:

    The Aggregator gives only one record as output. That only record will be last record.

    Please Login First :

    36 / 94

    Can UnConnected Lookup return more than one port? if so then how?
    Answer:

    Yes it can but not directly. Use look up override to concatenate required columns and take this concatenated to expression and separate all fields from concatenated one.

    Please Login First :

    37 / 94

    All type of cachce. What is, and how to use with example
    Answer:

    No Discussion on this question yet!

    Please Login First :

    38 / 94

    What are the types of Caches in lookup? Explain them.
    Answer:

    No Discussion on this question yet!

    Please Login First :

    39 / 94

    All types of join. What is, and how to use with example
    Answer:

    No Discussion on this question yet!

    Please Login First :

    40 / 94

    How to found 7th max salary without using top function.
    Answer:

    How to find 7th highest salary in Oracle SQL.

    TABLE NAME: EMP

    SELECT * FROM EMP E1 WHERE 7=(SELECT COUNT(DISTINCT(SALARY)) FROM EMP E2 WHERE E2.SALARY>=E1.SALARY);

    Please Login First :