informatica faq -4

51 What is Data Scrubbing?

The Data Scrubbing is the process of cleaning up the junk in the legacy data and make it accurate and useful. Simply, making good data out of bad data.

52. What are Bad Rows (Rejected Rows)?

The Informatica Server will dumped the bad or rejected rows which are sent out by the transformation into a text file with tablename.bad extension.

53. The Normalizer Transformation is mainly used to extract and format the Cobol files.

54. We can apply “Distinct” clause only in Source Qualifier and Sorter Transformations.

55. What are types of Dimensional Modeling?

1.            Conceptual Modeling

2.            Physical Modeling

3.            Logical Modeling

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.