✍ Kashif M ™
☎ +91 9994883085
✉ kashif7222@gmail.com


Thursday, 28 May 2015

Oracle Data Integrator Interview questions for experience

Explain what is ORACLE DATA INTEGATOR? why is it different from the other ETL tools.

Ans 1: ORACLE DATA INTEGATOR stands for Oracle Data Integrator. It is different from another ETL tool in a way that it uses E-LT approach as opposed to ETL approach. This approach eliminates the need of the exclusive Transformation Server between the Source and Target Data server. The power of the target data server can be used to transform the data. i.e. The target data server acts as staging area in addition to its role of target databasel. While loading the data in the target database (from staging area) the transformation logic is implemented. Also, the use of appropriate CKM (Check Knowldege Module) can be made while doing this to implement data quality requirement.

Q3.How will you bring in the different source data into ORACLE DATA INTEGATOR?

you will have to create dataservers in the topology manager for the different sources that you want.

Q4.How will you bulk load data?

In ORACLE DATA INTEGATOR there are IKM that are designed for bulk loading of data.

Q6.How will you bring in files from remote locations?

We will invoke the Service knowledge module in ORACLE DATA INTEGATOR,this will help us to accesses data thought a web service.

Q7.How will you handle dataquality in ORACLE DATA INTEGATOR?

There are two ways of handling dataquality in ORACLE DATA INTEGATOR....the first method deals with handling the incorrect data using the CKM...the second method uses Oracle data quality tool(this is for advanced quality options).

Virtuas ORACLE DATA INTEGATOR (ODI) Interview Questions

1) What are the variable types?
2) What are the knowledge modules types?
3) What are the IKM types?
4) What are the LKM types?
5) How you find which the latest record in SCD type2 transformation is?
6) When you use CKM?
7) Have you created sequence? When will you use?
8) What is your daily activities?
9) Have you attended the client meetings?
10) If you are working Microsoft excel, which type of file you used .excel or .csv?
11) Have you created fact table and dimension tables?
12) How many knowledge modules you used?
13) When you used JKM ?
14) Can you joined two sources without common column?

Mahindra Satyam ORACLE DATA INTEGATOR (ODI) Interview Questions 1st Round

1. How many types of km’s?
2. Step by step explain for the Flat file?
3. What is the Cdc?
4. What is the Repository and how many types of repository?
5. What is variable and how many types of variable?
6. In topology manager where the data are stored?
7. Explain the designer?
8. Difference between ETL and E_LT?
9. What are the constraints are used in Ur project?
10. What is the use of the Service Knowledge module?
TCS Interview:
Tell me about ur self?
Types of Scd’s?
Where is the multi connections are used in ORACLE DATA INTEGATOR?
How many types of dimensions in oracle?
Difference between ETl and E_lt?
In my source different types of technologies like that (File, Excel, and Xml)? Which data loaded are in target db?
Can migrate the one ORACLE DATA INTEGATOR studio to another ORACLE DATA INTEGATOR studio?


1. Tell me about Ur self?
2. What is odi? & briefly explain odi architecture?
3. How many types of knowledge Modules? Where are used in km?
4. Diff b/w 10g & 11g in odi?
5. What is data store? How to create data store?
6. What is odi studio?
7. Diff b/w ETL/E-LT?
8. What flow of MS-Excel in odi?
9. Odi used in oracle products?
10. What is a user function?
11. What is variable? What is Flow of variable?
12. Diff b/w case & decode?
13. Diff b/w delete & truncate?
14. How many types of predefined exceptions?
15. What is cursor? How types of cursor types attributes?

Virtuas Interview Questions

1) What are the variable types
2) What are the knowledge modules types?
3) What are the IKM types?
4) What are the LKM types?
5) How you find which is the latest record in SCD type2 transformation?
6) When you use CKM ?
7) Have you created sequence? when will you use?
8) What is your daily activities?
9) Have you attend the client meetings?
10) If you are working microsoft excel, which type of file you used .excel or .csv?
11) Have you created fact table and dimension tables?
12) How many knowledge modules you used?
13)When you used JKM ?
14) Can you joined two sources without common column?

TCS Interview for 2nd Round

1. What is the scd? And Types of SCD?
2. Difference between Row Id and Row Num?
3. What is the normalization?
4. Difference between delete and truncate?
5. What is the load plans in odi?
6. What is the data quality in odi?
7. What are the constraints in odi?

Infosys Interview Questions

1. How to send the e-mails for odi?
2. How to create sequence in odi?
3. Explain for repository?
4. How many types of km’s? And you what are the type’s km are used in ur project?
5. What is the variable?
6. How many types of v variables’? Where will appear for variables in odi?
7. What is the load plans? And how to create for the load plans?
8. What is the data quality?
9. File steps?

Sunday, 24 May 2015

OBIEE 11g Online Training

 1.   Class room training for OBIEE will be given for student who located in Chennai, India.

 2.   OBIEE certification training will be given with assurance of getting minimum 90%
 3.   OBIEE Online training will be given for USA students in evening timings.

 4.   OBIEE training tutorials will be provided at the time of training.

 5. Contact me at +91-9994883085, Skype - kashif7222, Email ID - coogle7222@gmail.com

 Kindly find below syllabus for OBIEE 11g Training:

Repository Development

ü  Repository Basics

1.       Architecture Of OBIEE

2.       Data Sources

3.       Repository – Admin Tool

4.       Physical Layer and its Objects

5.       Business Model and Mapping layer and its Objects

6.       Measures

7.       Presentation Layer and its Objects

8.       Repository Modes

9.       Repository Directory

10.   Publishing Repository

ü  Building Physical Layer

1.       Database and Physical Layer Objects.

2.       Connection Pool

3.       Schema folder

4.       Physical table and columns

5.       Alias

6.       Keys and Joins

7.       Implementation steps

8.       Data source

9.       Importing data source

10.   Consistency check and saving of RPD

ü  Building Business Model and Mapping Layer

1.       BMM Layer objects

2.       Logical Tables

3.       Logical table source (LTS)

4.       Measures

5.       Columns Mappings

6.       Implementation steps

ü  Presentation Layer

1.       Presentation Layer Objects

2.       Subject areas

3.       Presentation tables and Columns

4.       Nesting Presentation tables

5.       Implementation Steps

ü  Testing & Validating Repository

1.       Validating Repository

2.       Consistency Check

3.       Checking Logs

4.       Logging levels

5.       Publishing repository

6.       Available Queries

ü  Logical Table Source (LTS)

1.       LTS – Single and Multiple LTS

2.       Implementation Steps

3.       Import Additional Tables

4.       Creating Aliases

5.       Defining Keys and Joins

6.       Types of methods of importing

7.       Logical Columns

8.       Adding columns from BMM layer to Presentation Layer

ü  Fact Calculations in BMM Layer

1.       Business Problem and solution

2.       Calculation Measures using Existing logical columns

3.       Calculation measures using physical columns

4.       Building Formula

5.       Implementation steps

6.       Expression Builders

ü  Logical Dimensions

1.       Logical Dimension and its types

2.       Level Based Measures

3.       Share Measure

4.       Implementation steps of Level-Based Logical Dimension

5.       Parent level object

6.       Child level object

7.       Drill Path

8.       Parent child Hierarchy

9.       Implementation steps of Parent Child Level Logical dimension

10.   Share Measures

11.   Structure types

12.   Verifying and importing to Presentation layer

ü  Aggregates

1.       Aggregate Tables

2.       Aggregate Navigation

3.       Steps to implement aggregate navigation

4.       Aggregate Persistence wizard

ü  Variables

1.       Variable manager

2.       Variable types

3.        Repository Variables

4.       Session variables

5.       Initialization Blocks

6.       Implementation steps

ü  Modeling time series

1.       Time functions

2.       Time series functions

3.       Ago

4.       ToDate

5.       Period Rolling

6.       Implementation steps

ü  Security

1.       Oracle Bi Security

2.       Security Realms

3.       Users & groups

4.       Application Roles

5.       Application Policies

6.       Types of Security 

ü  Cache Management

1.       Oracle BI server Query Cache

2.       Cache Manager

3.       Purging Cache Entries – Manually & Automatically

4.       Event polling Tables

ü  Usage Tracking

1.       Oracle BI Usage Tracking Methods

2.       Implementation steps of Usage Tracking

ü  MUDE (Multi User Development Environment)

1.       Overview of MUDE process

2.       Steps to implement MUDE

ü  Administration Tool Utilities

1.       Wizards and utilities

2.       Manage sessions

3.       Replacing Columns or tables

4.       Documentation

5.       Update physical Layer

6.       Event table

7.       Removing unused physical objects

ü  Write back in analyses

1.       Write back analyses

2.       Steps to configure write back

ü  Partitions & Fragments

1.       Partition

2.       Partitioning by value

3.       Partitioning by Fact

4.       Partitioning by level

5.       Fragmentation

6.       Fragmentation Content

7.       Implementation steps

Create Analyses and Dashboards

ü  Introduction to Oracle Business Intelligence

1.       Business Intelligence

2.       Oracle BI Architecture

3.       Data sources

4.       Sample Analysis Process

5.       Login & Home page

ü  Oracle Business Intelligence Analyses

1.       Subject areas

2.       Tables & columns

3.       Hierarchies

4.       Creating and editing analysis

5.       Subject areas and catalog panes

6.       Steps to create analyses

7.       Sort orders

8.       Formatting the analysis

9.       Customization

10.   Display analyses results

ü  Administration

1.       Administering Objects in Presentation Catalog

2.       Access and actions

3.       Catalog security

4.       Default BI Roles

5.       Presentation catalog folder and object permissions

6.       Object permissions

7.       Manage Privileges 

8.       Users and roles

ü  Limiting and grouping Data analyses

1.       Data Limitation in analyses

2.       Filters

3.       Grouping filters

4.       Dynamic filters

5.       Saved analysis filters

6.       Drills

7.       Analysis Prompts

8.       Multiple column filters

9.       Creating groups

10.   Implementation steps of groups

11.   Creating Calculated items

12.   Implementation of calculated items

13.   Selection Steps

14.   Conditions in Selection steps

15.   Implementation steps 

ü  Advance Features of Analyses

1.       Setting Analysis Properties

2.       Operators

3.       Combining Results of multiple analysis

4.       Steps to implement Combining results

5.        Direct database analysis

6.       Steps to implement Direct database analysis

ü  Views and Graphs in Analyses

1.       Types of views

2.       Compound Layout pane

3.       Bins

4.       Table view and its properties

5.       Link master-Detail views

6.       Graph views and its properties

7.       Formatting graph view

8.       Narrative view

9.       Ticker view

10.   View selector

11.   Column selector

12.   Graphs by position and conditions

ü  Gauge and Map View 

1.       Gauge views – Types and properties

2.       Implementation steps of gauge views

3.       Map Views and its components

ü  Key performance Indicators

1.       KPI – Key performance Indicators

2.       Basic concepts and characteristics

3.       Steps to create KPI’s

4.       KPI Watch list

ü  Pivot table

1.       Pivot table view

2.       Analyzing and displaying data using pivot table

3.       Steps to create pivot table

4.       Sorting – Row Sort, Measure Sort

5.       Aggregation Rules

6.       Formatting – Section ,table and overall properties

7.       Duplicating Measures

8.       Hidden Measures

9.       Summation 

10.   Pivot table properties

ü  Dashboards

1.       Creating and editing Dashboards

2.       Dashboard pages

3.       Adding reports to dashboard pages

4.       Dashboard Properties

5.       Dashboard report links

6.       Sections

7.       Columns

8.       Conditions

9.       Personal customization

10.   Shared customization

11.   Links to dashboard pages

12.   Briefing Book

ü  Configuring Dashboards

1.       Dashboard Objects

2.       Alert section

3.       Action Link

4.       Action Link menu

5.       Link or Image

6.       Embedded Content

7.       Folder

ü  Dashboard Prompts

1.       About Dashboard Prompts

2.       Scope of the dashboard prompts

3.       Column prompts

4.       Creating Second page of the prompt

5.       Applying prompts with default values.

6.       Prompt Selections

7.       Specific values

8.       Conditions

9.       Applying prompts with default values

ü  Dashboard Prompt Variables

1.       Types of variable use in Prompt

2.       Request variable and prompts

3.       Presentation variable and prompts

4.       Steps to implement variable in prompts

ü  Delivers

1.       About delivers

2.       Deliver devices

3.       Deliver profiles

4.       Creating  delivery device and Delivery profile

5.       Alerts

6.       Configuring and steps to implement Agent

7.       Using agents to deliver content

8.       Using conditions to deliver content

Briefing book 

1.       About Briefing book

2.       Edit Briefing book options

3.       Downloading briefing book

Phone - +91-9994883085

Skype - kashif7222

Email - coogle7222@gmail.com