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?
- Master and detail source
- Type of join
- 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:
- Design it in the transformation developer.
- 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.
131. What are different options uses to configure the sequential batches?
There are two options:
- Run the session only if previous session completes successfully.
- Always runs the session.
132. What are the data movement modes in Informatica?
Data movement modes determine how Informatica server handles the character data. You chooses the data movement in the Informatica server configuration settings Two types of data movement modes available in Informatica.
- ASCII mode
- Uni code mode
133. What is difference between stored procedure transformation and external procedure transformation?
Inner equi join.
134. What is difference between stored procedure will be compiled and external procedure transformation?
In case of stored procedure transformation procedure will be compiled and executed in a relational data source. You needs data base connection to import the stored procedure in to yours mapping. Where as in external procedure transformation procedure or function will be executed out side of data source. That is you need to make it as a DLL to access in your mapping. No need to have data base connection in case of external procedure transformation.
135. To achieve the session partition what are the necessary tasks you have to do?
- Configure the session to partition source data.
- Install the Informatica server on a machine with multiple CPU’S
source:www.dwhetltool.co.cc
0 comments:
Post a Comment