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
    What is a persistent cache?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!

    Question :: 2
    What is a shared cache?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!

    Question :: 3
    What is unnamed cache and named cache?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!

    Question :: 4
    How do you improve the performance of lookup transformation?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!

    Question :: 5
    How do you remove Duplicate records in Informatica? And how many ways are there to do it?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!

    Question :: 6
    Differentiate between Source Qualifier and Filter Transformation?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!

    Question :: 7
    What are the differences between Source Qualifier and Joiner Transformation?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!

    Question :: 8
    Differentiate between joiner and LookupTransformation.
    Answer:


    Join Transformation

    Lookup Transformation

    • It uses only = operator to match column data.
    • It has four type of joiner :
    • Normal join
    • master outer join
    • detail outer join
    • Full outer join
    • It uses =,>=,<=, != operator.
    • It work like Left outer join only.

    Joiner is active and connected transformation

    Lookup is active/passive and connected or unconnected transformation.

    Joiner transformation is used to usually to join data coming from two separate tables or source qualifiers.

    Look up transformation can be used on a single table or a query to search for records that match incoming Records


    Please Login First :

    Tags:No Tags on this question yet!

    Question :: 9
    What is meant by Lookup Transformation? Explain the types of Lookup transformation.
    Answer:

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!

    Question :: 10
    How can you increase the performance in joiner transformation?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!