Informatica FAQ's part-6

56. What is Forward Engineering?

Using the Erwin tool the data modeler will convert the .SQL script (logical structure of tables) into a physical structure tables at the database level, this is called as Forward Engineering.

57. What is common use of creating a Factless Fact Table?

The most common use of creating a Factless fact table is to capture date transaction events.

58. What are the different sources of Source systems of Data Warehouse?

1. RDBMS
2. Flat Files
3. XML Files
4. SAP R/3
5. PeopleSoft
6. SAP BW
7. Web Methods
8. Web Services
9. Seibel
10. Cobol Files
11. Legacy Systems.

59. You cannot use XML source qualifier in a mapplet and Joiner and Normalizer Transformations.

60. What are the Session Partitions types?

1. Round-robin
2. Hash keys
3. Key range
4. Pass-through
5. Database partitioning

61. You cannot use Incremental Aggregation when the mapping includes an aggregator transformation.

62.While importing source definition the metadata that will be imported are:

1. Source Name
2. Database Location
3. Column Names
4. Data Types
5. Key Constraints

63. We can stop the Batch by two ways:

1. Server Manager
2. By pmcmd command

64. What is stop the Batch and types of Batches?

Grouping of sessions is known as Batch. There are two types of batches:

1. Sequential
2. Concurrent

65. What is a tracing level and types of Tracing level?

Tracing level represents the amount of information that Informatica server writes in a log file. Types of Tracing levels are:

1. Normal
2. Verbose
3. Verbose lnit
4. Verbose Data

66. What is the default join that source qualifier provides?

Inner Join

67. Types of Slowly Changing Dimensions:

1. Type – 1 (Recent updates)
2. Type – 11 (Full historical information)
3. Type – 111 (Partial historical information)

68. What are Update Strategy’s target table options?

1. Update as Update: Updates each row flagged for update if it exists in the table.
2. Update as Insert: Inserts a new row for each update.
3. Update else Insert: Updates if row exists, else inserts.

69. What is a Data in a database this include the source of tables, the meaning of the keys and the relationship between the tables.

70. In Conceptual Modeling and Logical modeling the tables are called as entities.

71. What does a Mapping document contains?

The Mapping document contains the following information :

1. Source Definition – from where the database has to be loaded
2. Target Definition – to where the database has to be loaded
3. Business Logic – what logic has to be implemented in staging area.

 source:www.dwhetltool.co.cc