✍ Kashif M

Sunday, 2 November 2014

Top 135 Informatica Interview Questions

By on November 02, 2014

This is overall informatica interview questions, this informatica interview question has been been prepared from experience informatica resource, If you can able to answers those questions you can win any interview in informatica.

1 How do you change parameter when u move it from development to production.

2 How does the session recovery work.

3 Why use shortcuts(Instead of making copies).

4 where is the reject loader .

5 How do you use reject loader.

6 Do u have to change the reject file b4 using reject loader utility.

7 Differences between version 7.x and 8.x.

8 Debugger – what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running. 
Top 135 Informatica Interview Questions
Top 135 Informatica Interview Questions

9 Mapplets – can you use an active transformation in a mapplet,

10 What are active transformations? Name them.

11 Can u use flat files in Mapplets.

12 How many transformations can be used in mapplets.

13 Can a joiner be used in a mapplet.

14 What are active transformations.

15 How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

16 Global and Local shortcuts. Advantages.

17 Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can u use them in the mapping?

18 Have you worked with/created Parameter file

19 What’s the layout of parameter file (what does a parameter file contain?)?

20 Why do u use Mapping Parameter and mapping variable?

21 Where do u create/define mapping parameter and mapping variable?

22 Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how

23 Slowly changing dimensions, types and where will you use them

24 What are the modules in Power Center

25 Filter transformation in the condition one of the data is NULL would the record be dropped.

26 Parameter&variable differences

27 Reusable transformation & shortcut differences

28 Mapplets ( can u use source qyalifier, can u use sequence generator, can u use target)

29 Implementation methodology

30 Do u have knowledge in ralph kimball methodology

31 According to his methodology what all u need before u build a datawarehouse

32 How do u recover rows from a failed session

33 Sequence generator, when u move from develoment to production how will u reset

34 Whats there in global repository

35 Repository user profiles

36 How do u set a varible in incremental aggregation

37 Can u create a flatfile target

38 What did u do in source pre load stored procedure

39 Scheduling properties,whats the default (sequential)

40 In a concurrent batch if a session fails, can u start again from that session

41 When u move from devel to prod how will u retain a variable

42 Partition, what happens if the specified key range is shorter n longer

43 Performance tuning( what u did in performance tuning)

44 What are conformed dimensions?

45 what are factless facts? And in which scenario will you use such kinds of fact tables.

46 can you avoid static cache in the lookup transformation? I mean can you

47 disable caching in a lookup transformation?

48 what is the meaning of complex transformation?

49 in any project how many mappings they will use(minimum)?

50 How do u implement unconn. Stored proc. In a mapping?

51 Can u access a repository created in previous version of Informatica?

52 What happens if the info. Server doesn’t find the session parameter in the parameter file?

53 How big was your fact table

54 How did you handle performance issues If you have data coming in from multiple 
sources, just walk thru the process of loading it into the target

55 How will u convert rows into columns or columns into rows

56 What are the steps involved in the migration from older version to newer version of Informatica Server?

57 What are the main features of Oracle 8i with context to datawarehouse?

58 What are the new features of Power Center 5.0?

59 How to run a session, which contains mapplet?

60 Differentiate between Load Manager and DTM?

61 What are session parameters ? How do u set them?

62 When do u use mapping parameters? (In which transformations)

63 What is a parameter When and where do u them when does the value will be created

64 Desing time, run time. If u don’t create parameter what will happen

65 What are variable ports and list two situations when they can be used?

66 What are the parts of Informatica Server?

67 How does the server recognize the source and target databases. Elaborate on this.
68 List the transformation used for the following:
1. Heterogeneous Sources

2. Homogeneous Sources

3. Find the 5 highest paid employees within a dept.

4. Create a Summary table

5. Generate surrogate keys 

69 What is the difference between sequential batch and concurrent batch and which is recommended and why?

70 A session S_MAP1 is in Repository A. While running the session error message has displayed

71 ‘server hot-ws270 is connect to Repository B ‘. What does it mean?

72 How do you do error handling in Informatica?

73 How do you implement scheduling in Informatica?

74 What is the meaning of up gradation of repository?

75 How can you run a session without using server manager?
Consider two cases:

1. Power Center Server and Client on the same machine

2. Power Center Sever and Client on the different machines

76 what is the basic difference in these two setups and which is recommended?

77 Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

78 When you connect to repository for the first time it asks you for user name & password of repository and database both.

79 But subsequent times it asks only repository password. Why?

80 What is the difference between normal and bulk loading?

81 Which one is recommended?

82 What is a test load?

83 How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?

84 What is the difference between a shortcut of an object and copy of an object? 85 What is mapplet and a reusable transformation?

86 How do you implement configuration management in Informatica?

87 What are Business Components in Informatica?

88 Dimension Object created in Oracle can be imported in Designer

89 Cubes contain measures

90 COM components can be used in Informatica

91 What is the advantage of persistent cache? When it should be used.

92 When will you use SQL override in a lookup transformation?
Two different admin users created for repository are ______ and_______

Two Default User groups created in the repository are ____ and ______
93 A mapping contains
1. Source Table S_Time ( Start_Year, End_Year )

2. Target Table Tim_Dim ( Date, Day, Month, Year, Quarter ) 

94 Stored procedure transformation : A procedure has two input parameters I_Start_Year, I_End_Year and output parameter as O_Date, Day , Month, Year, Quarter. If this session is running, how many rows will be available in the target and why?

95 Active/passive transformation (Lookup /sorted active or passive)

96 schema type, start schema can we have more than 1 fact

97 type of datawarehouse

98 what is ODs (differet type of storage)

99 session level optmziation (parameter set)

100 type of cache

101 connected/unconnected tranformation

102 bulk/normal mode (when we will go for it)

103 type of logs generate in informatica

104 how to set no of rejection (more than 10 rejction)

105 dependency of session (if one session fails will it continue next?)

106 what is mapplet, why we need it, can we have mapplet under mapplet

107 how achive update staergy without using tranformation update staergy

108 differnce between parameter and varaible

109 pcmcd differnt parameter

110 what is scd? explain scd3 ?

111 10k record in source and insert 10k in target (which mode we need to use?)

112 explain what details we get in workflow log

113 what is datawearhousr/why we need

114 what is rank transformation

115 sql override

116 if we have 5core record ,is it better to use bulk or normal mode

117 can we have lookup on file (source is file) how can we join file?

118 What's the restriction for Pushdown optimization, can we use aggregator pushdown optimization

119 why Joiner is required, we can use in source qualifier (what are differnt join)

120 How to pass value to un connected stored procedure

121 in Router without any condition, which group it will get oputput

122 SCD type 2, how to achive, how to update exisitng record

123 Parttion, what is pass throgh parttion

124 explain Performance tuning achived in your project

125 what DTM buffer size

126 How to check cache size

127 what peristant cache, how to get latest data using persitant cache, what details will contain in cache file

128 what is target/source override

129 what are all new features in 9

130 differnce between lookup and joiner

131 what is source/target commit interval

132 what is concurrent work flow, how to achive?

133 chekin/checkout (steps to taken care for checkout mapping)

134 why lookup is connected in 9

135 what is reporting tool used informatica

mkashu: Top 135 Informatica Interview Questions
Review : Kashif | Kashif
Update: November 02, 2014 | Rating: 4.5

Comment for "Top 135 Informatica Interview Questions"


Post a Comment

Blog Archive