Informatica FAQ's part-10

136. Performance tuning in Informatica?The goal of performance tuning is optimize session performance so sessions run during the available load window for the Informatica server. 137.When can session fail?The session fails when,Server cannot allocate enough system resources Session exceeds the maximum no. of sessions Server cannot obtain an execute lock for the session Server encounters database errors Network related errors 138. How many ways you can update a relational source definition?There are ways you can update a relational source definition:Edit the definition reimport the definition 139. How many ways you can create...

Informatica FAQ's part-9

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...

Informatica FAQ's part-6

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?RDBMS Flat Files XML Files SAP R/3 PeopleSoft SAP BW Web Methods Web Services Seibel Cobol Files Legacy Systems. 59. You cannot use XML source qualifier in a mapplet and Joiner and Normalizer...

Informatica FAQ's part-8

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...

Informatica FAQ's part-7

72. What does the Top Down Approach says?The Top Down Approach is coined by Bill Immon. According to his approach he says “First we need to implement the Enterprise data warehouse by extracting the data from individual departments and from the Enterprise data warehouse develop subject oriented databases called as “Data Marts”. 73. What does the Bottom Up Approach or Ralph Kimball Approach says?The Bottom Down Approach is coined by Ralph Kimball. According to his approach he says “First we need to develop subject oriented database called as “Data Marts” then integrate all the Data Marts to develop the Enterprise data warehouse. 74....