102. What is Data Transformation Manager?
After the load manager performs validations for the session, it creates the DTM process. The DTM process is the second process associated with the session run. The primary purpose of the DTM process i

103. Why we use lookup transformations?
Lookup Transformations can access data from relational tables that are not sources in mapping. With Lookup transformation, we can accomplish the following tasks:Get a related value-Get the Employee N

104. Source Qualifier in Informatica
What is the Technical reason for having Source Qualifier in Informatica? Can a mapping be implemented without it? (Please don't mention the functionality of SQ) but the main reason why a mapping can't
105. where does the records goes which does not satisfy condition in filter transformation?

106. How can U create or import flat file definition in to the warehouse designer?
U can not create or import flat file defintion in to warehouse designer directly.Instead U must analyze the file in source analyzer,then drag it into the warehouse designer.When U drag the flat file s

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

108. what are the main issues while working with flat files as source and as targets ?

109. can any one tell why we are populating time dimension only with scripts not with mapping?

110. What are the challenges you have faced in your Project (DWH-ETL)? Explain with example?

111. What r the different options used to configure the sequential batches?
Two options Run the session only if previous session completes sucessfully. Always runs the session.

112. What is meant by named cache?At what situation we can use it?
Asked by: prakash B S

113. What r the types of lookup caches?
Persistent cache: U can save the lookup cache files and reuse them the next time the informatica server processes a lookup transformation configured to use the cache. Recache from database: If the per

114. How can U improve session performance in aggregator transformation?
Use sorted input.

115. what is the hierarchies in DWH

116. What will be the way to send only duplicate records to the Target?

117. What is difference between maplet and reusable transformation?
Maplet consists of set of transformations that is reusable.A reusable transformation is a single transformation that can be reusable. If u create a variables or parameters in maplet that can not be us


118. In Source Qualifier and in Target I have 1,2,3 row and I want to insert 4,5 records in source and I want them in target also? What is the procedure to load them?

119. What is Router transformation?
Router transformation allows you to use a condition to test data. It is similar to filter transformation. It allows the testing to be done on one or more conditions.

120. What are Aggregate transformation?

121. can we lookup a table from a source qualifer transformation-unconnected lookup

122. What is redo log file in Informatica ?.

123. How to run a workflow without using GUI i.e, Worlflow Manager, Workflow Monitor and pmcmd?

124. What are the Commit & Commit Intervals?

125. We are using Update Strategy Transformation in mapping how can we know whether insert or update or reject or delete option has been selected during running of sessions in Informatica.

126. what is the output for different groups in case of router transformation ifi. 1--Aii.2--Biii.3--A or Biv. 4--A and Bv.5--Default

127. why dimenstion tables are denormalized in nature ?

128. In the source, if we also have duplicate records and we have 2 targets, T1- for unique values and T
In the source, if we also have duplicate records and we have 2 targets, T1- for unique values and T2- only for duplicate values. How do we pass the unique values to T1 and duplicate values to T2 from the source to these 2 different targets in a single mapping?

129i was asked by the interviewer like,in the concept of mapping parameters and variables, the variable value will be saved to the repository after the completion of the session and the next time when u run the session, the server takes the saved variable value in the repository and starts assigning the next value of the saved value. for example i ran a session and in the end it stored a value of 50 to the repository.next time when i run the session, it should start with the value

130. Where and Why do we use Joiner Cache?

131. What is the Router transformation?
A Router transformation is similar to a Filter transformation because both transformations allow you to use a condition to test data. However, a Filter transformation tests data for one condition and

132. What is difference between IIF and DECODE function

133. how do you use Normalizer to convert columns into rows ?

134. To provide support for Mainframes source data,which files r used as a source definitions? COBOL files

135. What is the difference between Enterprise data warehouse and a data warehouse ??Which all transform

136. What are the Data Cleansing Tools used in the DWH?What are the Data Profiling Tools used for DWh?

137. What is the best way to modify a mapping if the target table name is changed?

138. What is a Materialized view? Diff. Between Materialized view and view

139. How many ways u create ports?
Two ways 1.Drag the port from another transforamtion 2.Click the add buttion on the ports tab.

140. Source table has 1000 rows. In session configuration --- target Load option-- \

141. what transformation you can use inplace of lookup?

142. what is incremental loading in informatica(that is used to load only updated information in the source)?how and where u use it in informatica?

143. how many types of dimensions are available in informatica?

144. How can we access MAINFRAME tables in INFORMATICA as a source ?
ex-: Suppose a table EMP is in MAINFRAME then how can we access this table as SOURCE TABLE in informatica? Asked by: Md Iqbal Hassan

145. How can u stop a batch?
By using server manager or pmcmd.

146. what is the main difference bw using an object from shared folder and copying an object and using that copied object ?

147. how do you fine tune the mapping and what methods we follow for different types of transformations?

148. in realtime which one is better star schema or snowflake star schemathe surrogate will be linked to which columns in the dimension table.thanks in advance

149. Can u use the maping parameters or variables created in one maping into any other reusable transformation?
Yes.Because reusable tranformation is not contained with any maplet or maping.

150. Can we update target table without using update strategy transformation? why?