informatica faq -6

91.  What is Constraint Based Load ordering?

The Constraint Based Load ordering specified the loading of the dimensions tables based on the constraints designed in the dimension table. The Constraint Based Load order is used for implementing snow-flake schema data loading.

92. How may Loading criteria?

There are three types of Loading criteria.

1.            Paralle loading

2.            Sequential

3.            Control flow loading

93. What is File Watch Event?

The Event Wait activity of a session has event called as File Watch which will watch wether the file is copied or not.

94. What is worklet?

The worklet is a group of sessions. To execute the worklet we have to create the workflow.

95. Why we use stored procedure transformation?

For populating and maintaining databases.

96. Why we use partitioning the session in Informatica?

Partitioning achieves the session performance by reducing the time period of reading the source and loading the data into target.

97. Why we use lookup transformation?

Look up Transformations can access data from relational tables that are not sources in mapping. With Lookup transformation, we can accomplish the following tasks.

98. Which transformation should we use to normalize the COBOL and relational sources?

When you drag the COBOL source into the Designer workspace, the normalized transformation automatically appears, creating input and output ports for every column in the source.

99. Which tool you use to create and manage sessions and batches and to monitor and stop the Informatica server?

Informatica server manager.

100. What are the types of data that passes between Informatica server and stored procedure?

There are three types of data

1.            Input/output parameter

2.            Return Values

3.            Status code

101. What are the groups available in Router Transformation?

1.            User defined group

2.            Default group

102. What are join types in Joiner Transformation?

The joins supplied by the Joiner Transformation are:

1.            Normal Join

2.            Master Outer Join

3.            Detail Outer Join

4.            Full Outer Join

103. What are the designer tools available for creation of Transformations?

1.            Mapping Designer

2.            Transformation Developer

3.            Mapplet Designer

104. What are the basic needs to join two sources in Source Qualifier?

The two source tables should have a primary key – foreign key relationship and the two source tables should have matching data types.

105. What is a Status code?

Status code provides error handling facility during the session execution.

106. What is Data Driven?

The Data Driven is the instruction which is fed to Informatica Server whether to insert/delete/update when using Update Strategy Transformation.

107. What are the tasks to be done to partition a session?

·                     Configure the session to partition the source data

·                     Install the Informatica on a machine with multiple CPU

108. In which circumstances the Informatica creates a reject file (bad file)?

When it encounters the DD_REJECT in Update strategy Transformation

Voilets database constraints file in the rows was truncated or overflowed.

109.In a sequential batch can you run the session if previous session fails?

Yes, by setting the option always runs the session.

110. How many ways your create ports?

Two ways:

1.            Drag the prot from another transformation

2.            Click the add button on the ports tab.