Informatica interview questions and answers part 5

Part1[1-7]  Part2[8-14]  Part3[15-23]  Part4[24-30]  Part5[31-37]  Part6[38-44]
Part7[45-51]

31. What is a target load order?
Ans: Target load order is specified on the basis of source qualifiers in a mapping. In case if there are multi-fold source qualifiers linked to different targets then one can entitle order in which informatica server loads data into targets.

32.What is power center repository?
Ans -The PowerCenter repository is used to share metadata across repositories to create a data mart domain.

33.What is fact table?

Ans -Fact table is the centralised table in a star schema.

34. What are the different types of fact tables?

Ans - Fact tables are of three types
    1. Additive
    2. Non-additive

    3. Semi additive

35. How can you define user defied event?

Ans - User defined event is a flow of tasks in the workflow. Events can be created and then raised as needed.

36.What is reusable transformation?
A. Reusable transformations can be used multiple times in a mapping. The reusable transformation is stored as a metadata separate from any other mapping that uses the transformation.

37.What is Dual table?

Ans - It is a table that is created by oracle along with data dictionary. 

Part1[1-7]  Part2[8-14]  Part3[15-23]  Part4[24-30]  Part5[31-37]  Part6[38-44]
Part7[45-51]