51. What are Dimensions and various types of Dimensions?
set of level properties that describe a specific aspect of a business, used for analyzing the factual measures of one or more cubes, which use that dimension. Egs. Geography, time, customer and produc

52. What is pre-session and post-session?

53. which activities can be performed using the repository manager?

54. what is the difference between source qualifier transformation and filter transformation?

55. What r the diffrence between joiner transformation and source qualifier transformation?
U can join hetrogenious data sources in joiner transformation which we can not achieve in source qualifier transformation. U need matching keys to join two relational sources in source qualifier trans

56. why do we use reusable sequencegenerator transformation only in mapplet?

57. what is the economic comparision of all the Informatica versions?

58. What is one disadvantage of using an unconnected (sometimes called function mode) Lookup transformation? (1) If there is no match in the Lookup condition, the Informatica server returns a transformation error(2) A reusable unconnected Lookup can not have more than one instance in a mapping(3) An unconnected Lookup transformation does not support user-defined default values(4) An unconnected Lookup transformation does not support a static lookup cache

59. when we create a target as flat file and source as oracle.. how can i specify first rows as column names in flat files..

60. Eliminate Duplicate Records

61. How to assign a work flow to multiple servers?
I have multiple servers, I want to assign a work flow to multiple servers Asked by: SRIRAM N


62. What are the locks with respect to mappings?How do you manually lock or unlock the mappings for chages?

63. What is the default join that source qualifier provides?
Inner equi join.

64. How to read rejected data or bad data from bad file and reload it to target?

65. Discuss the advantages & Disadvantages of star & snowflake schema?

66. Can U use the maping parameters or variables created in one maping into another maping?

67. If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
NO. Informatica is not at all concern with back end data base.It displays u all the information that is to be stored in repository.If want to reflect back end changes to informatica screens, again u h

68. Suppose I have one source which is linked into 3 targets.When the workflow runs for the first time only the first target should be populated and the rest two(second and last) should not be populated.When the workflow runs for the second time only the second target should be populated and the rest two(first and last) should not be populated.When the workflow runs for the third time only the third target should be populated and the rest two(first and second) should not be populated.Could any one

69. total how many joiner transformations needed to join 10 different sources.(recent tcs intervie w question)

70. How do you migrate from one environment to another like development to production in Informatica.

71. In what all transformations the mapplets cant be used in informatica??

72. What r the mapings that we use for slowly changing dimension table?
Type1: Rows containing changes to existing dimensions are updated in the target by overwriting the existing dimension. In the Type 1 Dimension mapping, all rows contain current dimension data.

74. Can we revert back reusable transformation to normal transformation?

75. inteview questionwhy do u use a reusable sequence genator tranformation in mapplets?

76. 1)how can we delete the cache files while we using aggregator transformaation?2)exlain about cache files handling in informatica3) there are two flat files and the two flat files contain two fileds as states.both the flat files contain duplicates how to eliminate this duplicates?4) can we use lookup transformation with out using source qualifier transformation?

77. When do you use Normal Loading and the Bulk Loading, Tell the difference?

78. How do you define fact less Fact Table in Informatica

79. What is Repository size, What is its min and max size?

80. would you recommend using an orderby clause as part of a lookup sql override for a cached lookup da
81. Have you implmented Lookup in your mapping, If yes give some example?

82. What is aggregate cache in aggregator transforamtion?
The aggregator stores data in the aggregate cache until it completes aggregate calculations.When u run a session that uses an aggregator transformation,the informatica server creates index and data ca

83. What does the first column of bad file (rejected rows) indicate? Explain

84. how do you measure slowly changing dimensions using lookup table

85. What is the difference between source definition database and source qualifier?

86. What is the logic will you implement to load data into a fact table from n dimension tables?

87. what is semi additve measuresand fully additive measures

88. how do you add and delete header , footer records from flat file during load to oracle?

89. What is the maplet?
Maplet is a set of transformations that you build in the maplet designer and U can use in multiple mapings.

90. What r two types of processes that informatica runs the session?

91. Hi Allwhat is the logic will you implement to laod the data in to one factv from 'n' number of dimension tables.

92. what is update strategy transformation ?
This transformation is used to maintain the history data or just most recent changes in to target table.

93. What r the connected or unconnected transforamations?
An unconnected transforamtion is not connected to other transformations in the mapping.Connected transforamation is connected to other transforamtions in the mapping.

94. What r the mapping paramaters and maping variables?

95. Does Informatica provide a SAS exit in any of its products?
What I am trying to determine is if I could invoke a SAS session from within Informatica's ETL product(s) in order to execute a complicated transformation written in SAS which would then return the re

96. Which SDLC suits best for the datawarehousing project.

97. in Dimensional modeling fact table is normalized or denormalized?in case of star schema and incase of snow flake schema?

98. What is granularity in INFORMATICA? How should be the level of granularity for a fact table as well as for a dimension table?

99. What r the active and passive transforamtions?

100. What r the designer tools for creating tranformations?

101. What is Session and Batches?
Session - A Session Is A set of instructions that tells the Informatica Server How And When To Move Data From Sources To Targets.