informatica faq's-7

111. How can you stop the batch?

By using server manager or pmcmd.

112.How can you improve session performance in aggregator transformation?

Use sorted input.

113. Can you use the mapping parameters or variables created in one mapping into any other reusable transformation?

Yes, because reusable transformation is not contained with any mapplet or mapping.

114. Can you use the mapping parameters or variables created in one mapping into another mapping?

No.

We can use mapping parameters or variables in any transformation of the same mapping or mapplet in which you have created mapping parameters or variables.

115. Can you start a session inside a batch individually?

We can start our required session only in case of sequential batch in case of concurrent batch. We can do like this.

116. Can you start batches with in a batch?

You cannot. If you wants to start batch that resides in a batch, create a new independent batch and copy the necessary sessions into the new batch.

117. Can you generate reports in Informatica?

Yes. By using Metadata reporter we can generate reports in Informatica.

118. Can you copy the batches?

No.

119. After dragging the ports of there sources(sql server, oracle, Infomix) to a single source qualifier, can you map these three ports directly to target?

No, Unless and until you join those three ports I source qualifier you cannot map them directly.

120. What are Target Types on the Server?

Target Types are File, Relational and ERP.

121.What is the aggregate transformations?

Aggregate transformation allows you to perform aggregate calculations, such as averages and sums.

122. What are Target Options on the Servers?

Target Options for File Target type are FTP File, Loader and MQ There are no target options for ERP target type.

123. How do you identify existing rows of data in the target table using lookup transformation?

Can identify existing rows of data using Unconnected transformation.

124. What is Code Page used for?

Code page is used to identify characters that might be I different languages. If your are importing Japanese data into mapping, you must select the Japanese code page of source data.

125. What is a source qualifier?

It represents all data queried from the source.

126. Where should you place the flat file to import the flat file definition to the designer?

Place it in Local folder.

127. What are the settings that you use to configure the joiner transformation?

1.            Master and detail source

2.            Type of join

3.            Condition of the join

128. What are the session parameters?

Session parameters are like mapping parameters; represent values you might want to change between Sessions such as database connections or source files.

129. What are the methods for creating reusable transformations?

There are two methods:

1.            Design it in the transformation developer.

2.            Promote a standard transformation from mapping designer. After you ass a transformation to the mapping, you can promote it to the status of reusable transformation.

130. What are the joiner caches?

When a Joiner transformation occurs in a session, the Informatica Server reads all the records from the master source and builds index and data caches bases on the master rows. After building the caches, the Joiner transformation reads records from the detail source and performs joins.