Note 1

Take Note:

Take a note while surfing.





Note With Ink

Give your Note a Colorful Tag.




Easy to Access

Stay on same information and in Sync wherever you are.

Note 2

Take Note:

Organize your information,It may take Shape.





Think With Ink

Differ your Content by Color.




Easy to Access

Easy to pull up your content from anywhere anytime.

Note 3

Take Note:

Don't Let information to miss,Because it take shape





Note With Ink

Simple an Easy Way to take a note.




Easy to Access

Get the same in next visit.


Please wait...

Technical Interview Questions and Answers :: Informatica

    Question :: 1
    How are dimension and fact tables created?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!

    Question :: 2
    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 :

    Tags:No Tags on this question yet!

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

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!

    Question :: 4
    Difference in connected and unconnected lookup.
    Answer:

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!

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

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!

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

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!

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

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!

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

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!

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

    No Discussion on this question yet!

    Please Login First :

    Tags:Wipro Sapient

    Question :: 10
    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 :

    Tags:No Tags on this question yet!