ODI Topmost Interview Questions

1)      What is temporary Interface( Yellow Interface)  ?

2)      Tell me some differences between ODI  g and ODI g?

3)      Tell what are the ODI tools have u used in your project?

4)      What are the Types of repositories in ODI?

5)      Can i create more than one Master Repository in ODI?

6)      What is a scenario in odi?

7)      What is load plan and types of load plans in ODI?

8)      What is CKM and when we will use this CKM?

9)      What is SKM and when we will use this SKM?

10)   What is package and main advantages?

11)   Differences between package and loadplans?

12)   How to load data from multiple files to single target?

13)   How to load data from file to file and what are the KM's re  uired for this re  uirement?

14)   how to pass a variable more than one values?

15)   What is an agent and What are the types of agents?

16)   What is StandAlone Agent and default port number?

17)   What is J  EE Agent and port number?

18)   What is the use solutions?

19)   What is flexfileds and use of flexfileds in odi?

20)   What is CDC and explain complete CDC process flow?

21)   What are the types of profiles in ODI?

22)   What are the types of Generic profiles types in ODI?

23)   Which profile re  uired to access Models in Designer tool?

24)   Which profile re  uired to access solution in Designer tool?

25)   Which profile re  uired to access ODI Console?

26)   What is ODI console?

27)   What are types of LOG LEVELS in ODI?

28)   What is the use of Markers?

29)   What is memo?

30)   How to move objects from DEV to  A and  A to PROD Environments?

31)   How will you handle data  uality in ODI?

32)   What are the variable types? 

33)   What are the knowledge modules types? 

34)   What are the IKM types? 

35)   What are the LKM types? 

36)   How you find which the latest record in SCD type  transformation is? 

37)   When you use CKM? 

38)   Have you created seQuence? When will you use? 

39)   Explain what is ODI?why is it different from the other ETL tools 

40)   Explain about what you have done using ODI?

41)   How will you bring in the different source data into ODI?

42)   How will you bulk load data?

43)   How will you install ODI?

44)   How will you bring in files from remote locations?

45)   How will you handle data  uality in ODI?

46)   What is the history of ODI?

47)   What are the types of Knowledge Modules?

48)   What are the types of data contol?

49)   What is Journalization and why we are using in ODI?

50)   Tell me step by step to enable Journalization?

51)   What is An Interface ?

52)   What is your daily activities? 

53)   Have you attended the client meetings? 

54)   If you are working Microsoft excel, which type of file you used  excel or  csv? 

55)   Have you created fact table and dimension tables? 

56)   How many knowledge modules you used? 

57)   When you used JKM ? 

58)   Can you joined two sources without common column? 

59)   How many types of km&#;s? 

60)   Step by step explain for the Flat file? 

61)   What is the Cdc? 

62)   What is the Repository and how many types of repository? 

63)   What is variable and how many types of variable? 

64)   In topology manager where the data are stored? 

65)   Explain the designer? 

66)   Difference between ETL and E_LT? 

67)   What are the constraints are used in Ur project? 

68)   What is the use of the Service Knowledge module? 

69)   Tell me about ur self? 

70)   Types of Scd&#;s? 

71)   Where is the multi connections are used in ORACLE DATA INTEGATOR? 

72)   How many types of dimensions in oracle? 

73)   In my source different types of technologies like that (File, Excel, and Xml  ? Which data loaded are in target db? 

74)   Can migrate the one ORACLE DATA INTEGATOR studio to another ORACLE DATA INTEGATOR studio? 

75)   What are the variable types 

76)   How you find which is the latest record in SCD type  transformation? 

77)   When you use CKM ? 

78)   Have you attend the client meetings? 

79)   When you used JKM ? 

80)   What is the scd? And Types of SCD? 

81)   Difference between Row Id and Row Num? 

82)   What is the normalization? 

83)   Difference between delete and truncate? 

84)   What is the load plans in odi? 

85)   What is the data  uality in odi? 

86)   What are the constraints in odi? 

87)   where gets store my object id in odi ? can we renumber object id? can we delete object id?

88)   in my file contain   records  what is the size of file?

89)   generally what is the size of interface ?

90)   What are the variable types?

91)   What are the knowledge modules types?

92)   What are the IKM types?

93)   What are the LKM types?

94)   How you find which the latest record in SCD type transformation is?

95)   When you use CKM?

96)   Have you created sequence? When will you use?

97)   What is your daily activities?

98)   Have you attended the client meetings?

99)   If you are working Microsoft excel, which type of file you used .excel or .csv?

100)  Have you created fact table and dimension tables?

101)  How many knowledge modules you used?

102)  When you used JKM ?

103)  Can you joined two sources without common column?

104)  How many types of km’s?

105)  Step by step explain for the Flat file?

106)  What is the Cdc?

107)  What is the Repository and how many types of repository?

108)  What is variable and how many types of variable?

109)  In topology manager where the data are stored?

110)  Explain the designer?

111)  Difference between ETL and E_LT?

112)  What are the constraints are used in Ur project?

113)  What is the use of the Service Knowledge module?

114)  Tell me about ur self?

115)  Types of Scd’s?

116)  Where is the multi connections are used in ORACLE DATA INTEGATOR?

117)  How many types of dimensions in oracle?

118)  In my source different types of technologies like that (File, Excel, and Xml?

119)  Which data loaded are in target db?

120)  Can migrate the one ORACLE DATA INTEGATOR studio to another

121)  ORACLE DATA INTEGATOR studio?

122)  What is odi? & briefly explain odi architecture?

123)  How many types of knowledge Modules? Where are used in km?

124)  Diff b/w g & g in odi?

125)  What is data store? How to create data store?

126)  What is odi studio?

127)  Diff b/w ETL/E-LT?

128)  What flow of MS-Excel in odi?

129)  Odi used in oracle products?

130)  What is a user function?

131)  What is variable? What is Flow of variable?

132)  Diff b/w case & decode?

133)  Diff b/w delete & truncate?

134)  What are the variable types

135)  What are the LKM types?

136)  How you find which is the latest record in SCD type transformation?

137)  When you use CKM ?

138)  Have you created sequence? when will you use?

139)  What is your daily activities?

140)  Have you attend the client meetings?

141)  What is the scd? And Types of SCD?

142)  Difference between Row Id and Row Num?

143)  What is the normalization?

144)  Difference between delete and truncate?

145)  What is the load plans in odi?

146)  What is the data quality in odi?

147)  What are the constraints in odi?

148)  How to send the e-mails for odi?

149)  How to create sequence in odi?

150)  Explain for repository?

151)  How many types of km’s? And you what are the type’s km are used in ur project?

152)  What is the variable?

153)  How many types of v variables’? Where will appear for variables in odi?

154)  What is the load plans? And how to create for the load plans?

155)  What is the data quality?

156)  What is Oracle Data Integrator ?

157)  Can we call ODI as a ETL tool. If yes then How ?

158)  Is it a ELT tool? Explain.

159)  What are the new features available in ODI g?

160)  What is agent in ODI. Differentiate local agent and java ee agent.

161)  What is the role of context ?

162)  What is logical schema ? What is the importance of it ?

163)  Explain ODI Architecture.

164)  What is the error handling mechanism available in ODI ?

165)  What is the difference between flow_control vs static_control ?

166)  What are knowledge modules ? Which kind of codes they support.

167)  What are different ODI Tools you knows ?

168)  How interface works with aggregation ?

169)  What is dataset and how they are helpful in interface ?

170)  What do you mean by control append and incremental update ?

171)  What is scenario in ODI and why it is required ?

172)  What is local variable and global variable in ODI. How can we access them inside

173)  KM and procedures ?

174)  What are the different datatypes and history of an ODI variable ?

175)  What is temporary interface ? How they are helpful ? Give some scenarios on this.

176)  Can we use a sql query as source in interface ? if yes then how if not then why ?

177)  How can you configure a java ee agent ? Explain.

178)  What is internal id in ODI ? Explain.

179)  What is sunopsis memory engine ?

180)  Can we create multiple local agent ? If yes then how ?

181)  What are the different strategy for promoting a project from one env to other env.

182)  What are the minimum things required to take master and work repository backup.

183)  Is it necessary to have a key in interface. Explain your answer.

184)  How to create agent as a service in  and g version.

185)  What are the known bugs of ODI you have listened ?

186)  What is the oracle forum id of oracle data integrator?

187)  How do you create different user for ODI login. What are the different profile available ? Explain.

188)  What do you mean by webservice ? How ODI support web services ?

189)  What is ODI console and EM ?

190)  How ODI is different than OWB ?

191)  How can you send authenticated emails in ODI.

192)  What are the different temporary tables created in ODI ?

193)  How can you handles when multiples interfaces loading to a same table ?

194)  What is substitution api ? How to get the error message using substitution api ?

195)  What do you know about ODI SDK. What is the use of ODI SDK ?

196)  What technology you will chose to process mdb files ?

197)  What is Oracle Data Integrator (ODI?

198)  What is E-LT?

199)  What components make up Oracle Data Integrator?

200)  What is Oracle Data Integration Suite?

201)  What systems can ODI extract and load data into?

202)  What are Knowledge Modules?

203)  How do ‘Contexts’ work in ODI?

204)  Does my ODI infrastructure require an Oracle database?

205)  Where can I get more information on ODI?

206)  Does ODI support web services?

207)  Where does ODI sit with my existing OWB implementation(s?

208)  What is the ODI Console?

209)  Suppose I having  interfaces and running the interface  rd one failed how to run

210)  remaining interfaces?

211)  What is profile in ODI?

212)  How to write the sub-queries in ODI?

213)  How to remove the duplicate in ODI?

214)  Suppose having unique and duplicate but i want to load unique record one table and

215)  duplicates one table?

216)  How to implement data validations?

217)  How to handle exceptions?

218)  In the package one interface got failed how to know which interface got failed if we no access

219)  to operator?

220)  How to implement the logic in procedures if the source side data deleted that will reflect

221)  the target side table?

222)  If the Source have total  records with  records are updated and  records are newly

223)  inserted at the target side we have to load the newly changed and inserted records

224)  Can we implement package in package?

225)  How to load the data with one flat file and one RDBMS table using joins?

226)  If the source and target are oracle technology tell me the

227)  process to achieve this requirement(interfaces, KMS, Models

228)  What we specify the in XML data server and parameters for to connect to xml file?

229)  How to reverse engineer views(how to load the data from views?

230)  Is ODI Used by Oracle in their products?

231)  ELT Vs ETL

232)  What is User Parameters?

233)  What is a Project?

234)  What is Folder?

235)  What is an Interface?

236)  What is Sequence?

237)  Explain what is ODI?why is it different from the other ETL tools.

238)  How will you bring in the different source data into ODI?

239)  How will you bulk load data?

240)  What is User Functions ?

241)  What is Marker?

242)  What is E$ table in ODI ?

243)  What is I$ table in ODI ?

244)  What is J$ table in ODI ?

245)  What is Journalization and why we are using in ODI ?

246)  Explain step by step procedure to enable Journalization?

247)  What is Scenario?

248)  What is Context?

249)  What is Memos?

250)  How will you bring in files from remote locations?

251)  How will you handle dataquality in ODI?

252)  What is Sequences?

253)  What is load plans and types of load plans?

254)  How to write the sub queries in odi?

255)  What is Session?

256)  Can I create more than one Master Repository in ODI ?

257)  What is Session Tasks?

258)  What are the types of Knowledge Modules?

259)  What is An Interface ?

260)  What is a temporary Interface (Yellow Interface ?

261)  Explain some differences between ODI g and ODI g?

262)  What is CKM and when we will use this CKM?

263)  What is SKM and when we will use this SKM?

264)  How to write the procedures in odi?

265)  What is Work Repository ?

266)  Where we can use variables?

267)  How to load data from file to file and what are the KM’s required for this requirement?

268)  what's load plans and types of load plans?

269)  If the Source have total  records with  records are updated and  records are newly inserted.

270)  Which knowledge module we should use to get  these changes at the target side.

271)  Can we implement package in package?

272)  How to reverse engineer views(how to load the data from views?

273)  What systems can ODI extract and load data into?

274)  What are the prime responsibilities of Data Integration Administrator?

275)  What do you mean by control append and incremental update

276)  If the Source have total  records with  records are updated and

277)  records are newly inserted. Which knowledge module we should use to

278)  get these changes at the target side

279)  How to load the data with one flat file and one RDBMS table using joins?

280)  How to move objects from DEV to QA and QA to PROD Environments ?

281)  What are types of LOG LEVELS in ODI ?

282)  What is the use of Markers?

283)  What is a procedure and how to write the procedures in ODI?

284)  What are the types of Generic profiles types in ODI ?

285)  Which profile required to access Models in Designer tool?

286)  Which profile required to access solution in Designer tool?

287)  What is local variable and global variable in ODI. How can we access them inside KM and

288)  procedures ?

289)  What are the different datatypes and history of an ODI variable ?

290)  Is it necessary to have a key in interface. Explain your answer.

291)  Which profile required to access ODI Console?

292)  What are the types of data quality control?

293)  What is flexfileds and use of flexfileds in ODI ?

294)  What is profile in ODI ?

295)  What are the types of profiles in ODI ?

296)  Difference between generic and non-generic profiles ?

297)  How do you create different user for ODI login. What are the different profile available ? Explain.

298)  What is a constraint?

299)  What is an agent and What are the types of agents?

300)  Differences between package and load plans?

301)  What is a Procedure?

302)  There are two ways to data quality control

303)  What is  Model ?

304)  What is a Package ?

305)  Suppose I having  interfaces and running the interface th one failed how to run

306)  remaining interfaces?

307)  What’s load plans and types of load plans?

308)  How to write the sub-queries in ODI ?

309)  What is a model in ODI ?

310)  What are User Parameters in Oracle Data Integrator?

311)  What are the Types of repositories in ODI and explain them?

312)  What is a temporary Interface (Yellow Interface

313)  What is Master Repository ?

314)  What is a scenario in ODI? Explain about scenario.

315)  What is package and main advantages?

316)  How to create a package ?

317)  Explain about ODI toolbox ?

318)  Remove the duplicate in ODI ?

319)  What platforms does Oracle Data Integrator support?