behavioral interview techniques

30
Behavioral Interview Techniques June 24, 2007 - 03:18 — shilpa Below are some behavioral interview techniques that you'll find useful: 1. Be prepared for the interview by analyzing and making an educated guess as to which skills are most desired by the employer. You can study the job description of the position or go to some job boards to review requirement sections of related jobs. 2. Compile a list of skills that are relevant to the position you are applying. 3. Identify behavioral interview questions by introductory phases like "Tell me about a time when...," " Describe a situation where you...," "Give me an example of..." etc. 4. Listen carefully to each question. If necessary, rephrase the question and ask for clarification. 5. Use STAR formula to answer behavioral interview question. STAR stands for Situation, Task, Action and Result. Make sure that your answers are detailed and specific. This behavioral interview technique is widely recommended by career advisors. 6. Use your real-life examples instead of your opinions or theoretical statements. The employers want to know what you have done in the past, not what you think you would do in the future. 7. Vary the length of your answers. You can prepare short description of each situation but be ready to give details if asked. You can also determine if you have given enough information by asking questions like, "Would you like more details on that?" "Would you like another example?" 8. Be honest. It will be bad for you if the interviewer find out that your story is built on weak foundation.

Upload: shaneeje

Post on 07-Apr-2018

223 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 1/30

Behavioral Interview Techniques

June 24, 2007 - 03:18 — shilpa 

Below are some behavioral interview techniques that you'll find useful:

1. Be prepared for the interview by analyzing and making an educated guess

as to which skills are most desired by the employer. You can study the job

description of the position or go to some job boards to review requirement

sections of related jobs.

2. Compile a list of skills that are relevant to the position you are applying.

3. Identify behavioral interview questions by introductory phases like "Tell

me about a time when...," " Describe a situation where you...," "Give me an

example of..." etc.

4. Listen carefully to each question. If necessary, rephrase the question and

ask for clarification.

5. Use STAR formula to answer behavioral interview question. STAR stands

for Situation, Task, Action and Result. Make sure that your answers are

detailed and specific. This behavioral interview technique is widely

recommended by career advisors.

6. Use your real-life examples instead of your opinions or theoretical

statements. The employers want to know what you have done in the past,

not what you think you would do in the future.

7. Vary the length of your answers. You can prepare short description ofeach situation but be ready to give details if asked. You can also determine

if you have given enough information by asking questions like, "Would you

like more details on that?" "Would you like another example?"

8. Be honest. It will be bad for you if the interviewer find out that your

story is built on weak foundation.

Page 2: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 2/30

Things You Should Not Do At An Interview

April 10, 2007 - 02:08 — shilpa 

There is enough literature on what you should do at an interview. But here’s

a list of things that you would definitely not want to do at an interview,

unless you don’t want that job or that B-school admit that you have so

wanted.

Never Go Unprepared

Yes sir, I hear you. You know it all. You even counted the number of stepson that staircase to the interview room. But you know that funny thing

called odds. It’s always a damp squib. You might want to do a bit of

preparation. If you have stated, Accountancy as your best subject on your

CV, you’d better be darned well at it. Learn every rule in every accounting

principle, by rote. And while you’re at it, it probably isn’t a bad idea to

memorize the number of pages in the Accounting Standards Book. Some

interviewers ask for weakness. What a silly thing to ask, like your weakness

would be of any help anyway. But you can’t argue with their logic. So turn

around any weakness on its head and make it your strength. If you’re a

weirdo, say you are quite innovative. If you’re a lazy goose and leave things

to last minute, say you work well with short deadlines. If you have had a not

so great time at grad school, tell them you believe in holistic education and

were active at extra-curriculars (of-course you need to back it up). Now if

you think you’re perfect, make up a not so debilitating weakness like

unbridled appetite or chewing nails…

Avoid Over Zealous Dressing

‘Green is the new blue’. Nice tagline, no? Did you buy that green shirt

already? Tsk, tsk, consumerism. Take my advice and save it for your best

Page 3: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 3/30

friend’s wedding. Yes, I know you bought it for this special occasion, your

first interview. Classic white is out, I know. But how about sticking to other

safe colors like blue or maybe gray. So what if its boring? At least you won’t

look like a radioactive leprechaun. Funny ties. Haha! That’s a good

attention grabber my friend. Focus, focus. . . We are here to grab that job…

the pink piggies on that yellow tie may prove more an unhealthy distraction

than attraction. Oh, I love that crocodile handbag of yours. Lets hide your

entire disregard for the ecosystem, in the closet. You can flaunt it in that

cocktail party, this weekend.

Never Underestimate Traffic Jams

The venue is only a block away and 15 minutes is all you need to get there.

Have you heard of a certain someone called Mr. Murphy? No? I’ll tell you

that story later. But he devised some fine laws. One of them says on the day

of your interview, every single car will be neatly lined in a jam from your

gate till the venue and every signal will chose to turn red the moment youturn the key in the ignition. So leave home at least one hour in advance.

Okay, so now you have reached too early. What are books for, silly?

Do Not Fake Accent

Does your guy love the way you roll your ‘R’s? Have people told you how

close you come to sounding Oxford educated? Good for you, mate. But its

hard to keep that up all the time, no? See, now that’s the thing with fake

accents. They have a habit of coming undone in the most inappropriate of

moments. And chances are it will happen at the interview too. Take my

word; the interviewer WILL NOT be impressed. So let your natural accent do

the talking this time, eh?

Page 4: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 4/30

Do Not Invoke Skeletons in the Closet

Everyone has them. I have a closet bursting at its hinges and a new one on

its way. No need to be ashamed. But an interview is not the place to

unleash them. If you got sacked from your last job, this is not the best place

to tell them your sob story. NO, I did NOT ask you to lie about it. All I am

saying is, don’t go about telling them what a @$*# %*@ your old boss was or

bad mouth your colleagues. Chances are they just might call him up to

confirm your little story. So be honest. But leave out the details. In this one

exceptional case, the devil is in the details.

Never Lose Your Cool

Surely you have heard of ‘stress interviews’. The ultimate aim of every soul

in that room will be to make you scream and run for life, tearing out your

hair. So never lose that thing called cool. It’s a slick one, Mr. Cool. Once

he’s gone, you might chew those manicured nails, twiddle your fingers or

tear at that loose thread on your skirt (imagine all of it coming undone.

Very Grim, yes). So pick up that Mr. Cool from under the table and be the

pro that you are… By the way, no matter what you do, do not gnash teeth.

You might never get it in shape for the next interview, should you lose out

on this one.

Page 5: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 5/30

PRESENCE OF MIND

April 8, 2006 - 01:02 — shilpa 

In an IIM interview PANEL-Shall i ask u one tough question or 10 easy

questions? CANDIDATE-ask me one tough question sir p-ok which comes

first.The day or the night? c-the day sir. p-how do u say that? c-Sir, u

promised me that you wont ask me the second toughest question. the guy

was selected.....

Page 6: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 6/30

SAP Interview Questions

August 1, 2007 - 22:01 — sandeep 

1.What are the differences between a OLAP and OLTP applications

OLAP

a.Summarized data

b.Read only

c.Not Optimized

d.Lot of historical data

OLTP

Detailed

Read write

Optimized for data applications

Not much old data

2.What is a star schema?

A fact table at the center and surrounded (linked) by dimension tables

3.What is a slowly changing dimension?

A dimension containing a characteristics which changes over a time; for

example take employee job title; this changes over a period of time with

different job titles

4. What are the advantages of Extended star schema of BW vs. the star

schema

a. use of generated keys (numeric) for faster access

b. external hierarchy

c. multi language support

d. master data common to all cubes

Page 7: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 7/30

e. slowly changing dimensions supported

f.aggregates in its own tables for faster access

5.What is the namespace for BW?

All SAP objects start with 0 and customer is A-Z; all tables begin with /BIO

for SAP and /BIC for customers; All generated objects start with 1-8 (like

export data source); prefix 9A is used in APO.

6.What is an info object?

Business object like customer, product, etc; they are divided into

characteristics and key figures; characteristics are evaluation objects like

customer and key figures are measurable objects like sales quantity, etc;

characteristics also include special objects like unit and time.

7. What are the data types supported by characteristics?

NUMC, CHAR (up to 60), DATS and TIMS

8.What is an external hierarchy?

Presentation hierarchies are stored in its own tables (hierarchy tables) for

characteristic values

9.What are time dependent text / attribute of characteristics?

If the text (for example a name of the product /person over time) or if the

attribute changes over time (for example job title) then these must be

marked as time dependent.

10. Can you create your own time characteristics?

No

11. What are the types of attributes?

Display only and navigational; display only attributes are only for display

and no analysis can be done; navigational attributes behave like regular

Page 8: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 8/30

characteristics; for example assume that we have a customer characteristics

with country as a navigational attribute; you can analyze the data using

customer and country.

12. What is Alpha conversion?

Alpha conversion is used to store data consistently by storing any numeric

values with prefixing with Os; for example if you defined material as 6 Numc

then number 1 is stored as 000001 but displayed as 1; this removes

inconsistencies between 01 vs. 001.

13. What is the alpha check execution program?

This is used to check consistency for BW 2.x before upgrading the system to

3.x; the transaction is RSMDCNVEXIT

14. What is the attributes only flag?

If the flag is set, no master data is stored; this is only used as attribute for

other haracteristics; for example comments on a AR document.

15.What is compounding?

This defines the superior info object which must be combined to define an

object; for example when you define cost center then controlling area is the

compounding (superior) object.

16.What is the Bex options for characteristics like F4 help for query

definition and execution?

This defines how the data is displayed in query definition screen or when

query is executed; options are from the data displayed, from master data

table (all data) and from dimension data; for example let us assume that

you have 100 products in all, 10 products in a cube; in bex you display the

query for 2 products; the following options for product will display different

data

Page 9: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 9/30

a. selective data only - will display 2 products

b. dimension data - will display 10 products

c. from master data - will display all 100 products

17. What are the data types allowed for key figures?

Amount, number, integer, date and time.

18. what is the difference between amount/quantity and number -

amount/quantity

always comes with units; for example sales will be amount and inventory

quantity.

19. What are the aggregation options for key figures?

If you are defining prices then you may want to set "no aggregation" or you

can define max, min, sum; you can also define exception aggregation like

first, last, etc; this is helpful in getting headcount; for example if you

define a monthly inventory count key figure you want the count as of last

day of the month.

20. What is the maximum number of key figures you can have in an info

cube?

233

21. What is the maximum number of characteristics you can have per

dimension?

248

‹ Sap Interview Questions -part-2upSAP Interview Questions ›

Sap Interview Questions -part-2

22. What are the nine decision points of data warehousing?a. Identify fact table

Page 10: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 10/30

b. Identify dimension tables

c. Define attributes of entities

d. Define granularity of the fact table (how often

e. Pre calculated key figures

f. Slowly changing dimensions

g. Aggregates

h. How long data will be kept

i. How often data is extracted

23. How many dimensions in a cube

Total 16 out of which 3 are predefined time, unit and request; customer is

left with 13 dimensions

24. What is a SID table and advantages

The SID table (Surrogate ID table) is the interface between master data and

the dimension tables; advantages :-

a. uses numeric as indexes for faster accessb. master data independent of info cubes

c. language support

d. slowly changing dimension support

25. What are the other tables created for master data?

a. P table - Time independent master data attributes

b. Q table - Time dependent master data attributes

c. M view - Combines P and Q 

d. X table - Interface between master data SIDs and time independent

navigational attributes SIDs (P is linked to the X table)

e. Y table - Interface between master data SIDs and time dependent

navigational attributes SIDs (Q is linked to the Y table)

Page 11: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 11/30

26. What is the transfer routine of the info object?

It is like a start routine; this is independent of the data source and valid for

all transfer routines; you can use this to define global data and global

checks.

27. What is the DIM ID?

Dim ids link dimensions to the fact table

28. What is table partition?

SAP is using fact table partitioning to improve performance; you can

partition only on OCALMONTH or OFISCPER;

29. How many extra partitions are created and why?

Usually 2 extra partitions are created to accommodate data before the

begin date and after the end date

30. Can you partition a cube which has data already?

No; the cube must be empty to do this; one work around is to make a copy

of the cube A to cube B; export data from A to B using export data source;

empty cube A; create partition on A; re-import data from B; delete cube B

31. What is the transaction for Administrator work bench?

RSA1

32. What is a source system?

Any system that is sending data to BW like R/3, flat file, oracle database or

external systems.

33. What is a data source?

The source which is sending data to a particular info source on BW; for

example we have a OCUSTOMER_ATTR data source to supply attributes to

OCUSTOMER from R/3

Page 12: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 12/30

34. What is an info source?

Group of logically related objects; for example the OCUSTOMER info source

will contain data related to customer and attributes like customer number,

address, phone no, etc

35. What are the types of info source?

Transactional, attributes, text and hierarchy

36. What is communication structure?

Is an independent structure created from info source; it is independent of

the source system/data source

37. What are transfer rules?

The transformation rules for data from source system to info

source/communication structure

38. What is global transfer rule?

This is a transfer routine (ABAP) defined at the info object level; this is

common for all source systems.

39. What are the options available in the transfer rule Assign info object,

assign a constant, ABAP routine or a Formula (From version 3.x); example

are :

a. Assign info object - direct transfer; no transformation

b. Constant - for example if you are loading data from a specified country in

a

f lat file, you can make the country as constant and assign the value

c. ABAP routine - for example if you want to do some complex string

manipulation; assume that you are getting a flag file from legacy data and

the cost center is in a field and you have to "massage" the data to get it; in

this case use ABAP code

Page 13: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 13/30

d. For simple calculations use formula; for example you want to convert all

lower case characters to upper case; use the TOUPPER formula

40. Give some important formula available

Concatenate, sub string, condense, left/right (n characters),1_trim, r_trim,

replace, date routines like DATECONV, date-week, add_to_date, date_diff,

logical functions like if, and;

41. When you do the ABAP code for transfer rule, what are the important

variables you use?

a. RESULT - this gets the result of the ABAP code

b. RETURNCODE - you set this to 0 if everything is OK; else this record is

skipped

c. ABORT - set this to a value not 0, to abort the entire package

42. What is the process of replication?

This copies data source structures from R/3 to BW

43. What is the update rule?

Update rule defines the transformation of data from the communication

structure to the data targets; this is independent of the source

systems/data sources

44. What are the options in update rules?

a. one to one move of info objects

b. constant

c. lookup for master data attributes

d. formula

e. routine (ABAP)

f. initial value

Page 14: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 14/30

45. What are the special conversions for time in update rules?

Time dimensions are automatically converted; for example if the cube

contains calendar month and your transfer structure contains date, the date

to calendar month is converted automatically.

46. What is the time distribution option in update rule?

This is to distribute data according to time; for example if the source

contains calendar week and the target contains calendar day, the data is

split for each calendar day. Here you can select either the normal calendar

or the factory calendar.

47. What is the return table option in update rules for key figures?

Usually the update rule sends one record to the data target; using this

option you can send multiple records; for example if we are getting total

telephone examples for the cost center, you can use this to return

telephone expenses for each employee (by dividing the total expenses by

the number of employees in the cost center) and creating cost record foreach employee in the ABAP code.

48. What is the start routine?

The first step in the update process is to call start routine; use this to fill

global variables to be used in update routines;

49. How would you optimize the dimensions?

Use as many dimensions as possible for performance improvement; for

example assume that you have 100 products and 200 customers; if you make

one dimension for both, the size of the dimension will be 20,000; if you

make individual dimensions then the total number of rows will be 300. Even

if you put more than one characteristic per dimension, do the math

considering worst case scenario and decide which characteristics may be

combined in a dimension.

Page 15: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 15/30

50. What is the conversion routine for units and currencies in the update

rule?

Using this option you can write ABAP code for unit/currency conversion; if

you enable this flag, then unit of the key figure appears in the ABAP code as

an additional parameter; for example you can use this to convert quantity in

pounds to kilo grams.

‹ SAP BW Interview QuestionsupSAP Interview Questions ›

SAP Interview QuestionsMay 22, 2007 - 17:01 — sandeep 

1. What is ERP? - ERP is a package with the techniques and concepts for the

integrated management of business as a whole, for effective use of

management resources, to improve the efficiency of an enterprise. Initially,

ERP was targeted for manufacturing industry mainly for planning and

managing core business like production and financial market. As the growth

and merits of ERP package ERP software is designed for basic process of a

company from manufacturing to small shops with a target of integrating

information across the company.

2. Different types of ERP? - SAP, BAAN, JD Edwards, Oracle Financials,

Siebel, PeopleSoft. Among all the ERP’s most of the companies implemented

or trying to implement SAP because of number of advantages aver other ERP

packages.

3. What is SAP? - SAP is the name of the company founded in 1972 under the

German name (Systems, Applications, and Products in Data Processing) is

the leading ERP (Enterprise Resource Planning) software package.

Page 16: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 16/30

4. Explain the concept of “Business Content” in SAP Business Information

Warehouse? - Business Content is a pre-configured set of role and task-

relevant information models based on consistent Metadata in the SAP

Business Information Warehouse. Business Content provides selected roles

within a company with the information they need to carry out their tasks.

These information models essentially contain roles, workbooks, queries,

InfoSources, InfoCubes, key figures, characteristics, update rules and

extractors for SAP R/3, mySAP.com Business Applications and other selected

applications.

5. Why do you usually choose to implement SAP? - There are number of

technical reasons numbers of companies are planning to implement SAP. It’s

highly configurable, highly secure data handling, min data redundancy, max

data consistency, you can capitalize on economics of sales like purchasing,

tight integration-cross function.

6. Can BW run without a SAP R/3 implementation? - Certainly. You can runBW without R/3 implementation. You can use pre-defined business content

in BW using your non-SAP data. Here you simply need to map the transfer

structures associated with BW data sources (InfoCubes, ODS tables) to the

inbound data files or use 3rd part tool to connect your flat files and other

data sources and load data in BW. Several third party ETL products such as

Acta, Infomatica, DataStage and others will have been certified to load data

in BW.

7. What is IDES? - International Demonstration and Education System. A

sample application provided for faster learning and implementation.

8. What is WF and its importance? - Business Work Flow: Tool for automatic

control and execution of cross-application processes. This involves

coordinating the persons involved, the work steps required, the data, which

Page 17: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 17/30

needs to be processed (business objects). The main advantage is reduction

in throughput times and the costs involved in managing business processes.

Transparency and quality are enhanced by its use.

9. What is SAP R/3? - A third generation set of highly integrated software

modules that performs common business function based on multinational

leading practice. Takes care of any enterprise however diverse in operation,

spread over the world. In R/3 system all the three servers like presentation,

application server and database server are located at different system.

10. What are presentation, application and database servers in SAP R/3? -

The application layer of an R/3 System is made up of the application servers

and the message server. Application programs in an R/3 System are run on

application servers. The application servers communicate with the

presentation components, the database, and also with each other, using the

message server. All the data are stored in a centralized server. This server is

called database server.

11. What should be the approach for writing a BDC program? - Convert the

legacy system data to a flat file and convert flat file into internal table.

Transfer the flat file into sap system called “sap data transfer”. Call

transaction(Write the program explicitly) or create sessions (sessions are

created and processed ,if success data will transfer).

12. Explain open SQL vs native SQL? - ABAP Native SQL allows you to include

database-specific SQL statements in an ABAP program. Most ABAP programs

containing database-specific SQL statements do not run with different

databases. If different databases are involved, use Open SQL. To execute

ABAP Native SQL in an ABAP program, use the statement EXEC. Open SQL

(Subset of standard SQL statements), allows you to access all database

tables available in the R/3 System, regardless of the manufacturer. To avoid

Page 18: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 18/30

conflicts between database tables and to keep ABAP programs independent

from the database system used, SAP has generated its own set of SQL

statements known as Open SQL.

13. What are datasets? - The sequential files (processed on application

server) are called datasets. They are used for file handling in SAP.

14. What are internal tables check table, value table, and transparent

table? - Internal table: It is a standard data type object, which exists only

during the runtime of the program. Check table: Check table will be at field

level checking. Value table: Value table will be at domain level checking ex:

scarr table is check table for carrid. Transparent table: - Exists with the

same structure both in dictionary as well as in database exactly with the

same data and fields.

15. What are the major benefits of reporting with BW over R/3? Would it be

sufficient just to Web-enable R/3 Reports? - Performance — Heavy reporting

along with regular OLTP transactions can produce a lot of load both on the

R/3 and the database (cpu, memory, disks, etc). Just take a look at the load

put on your system during a month end, quarter end, or year-end — now

imagine that occurring even more frequently. Data analysis — BW uses a

Data Warehouse and OLAP concepts for storing and analyzing data, where

R/3 was designed for transaction processing. With a lot of work you can get

the same analysis out of R/3 but most likely would be easier from a BW.

16. How can an ERP such as SAP help a business owner learn more about

how business operates? - In order to use an ERP system, a business person

must understand the business processes and how they work together from

one functional area to the other. This knowledge gives the student a much

deeper understanding of how a business operates. Using SAP as a tool to

Page 19: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 19/30

learn about ERP systems will require that the people understand the

business processes and how they integrate.

17. What is the difference between OLAP and Data Mining? - OLAP - On line

Analytical processing is a reporting tool configured to understand your

database schema ,composition facts and dimensions . By simple point-n-

clicking, a user can run any number of canned or user-designed reports

without having to know anything of SQL or the schema. Because of that

prior configuration, the OLAP engine “builds” and executes the appropriate

SQL. Mining is to build the application to specifically look at detailed

analyses, often algorithmic; even more often misappropriate called

“reporting.

18. What is “Extended Star Schema” and how did it emerge? - The Star

Schema consists of the Dimension Tables and the Fact Table. The Master

Data related tables are kept in separate tables, which has reference to the

characteristics in the dimension table(s). These separate tables for masterdata is termed as the Extended Star Schema.

19. Define Meta data, Master data and Transaction data - Meta Data: Data

that describes the structure of data or MetaObjects is called Metadata. In

other words data about data is known as Meta Data. Master Data: Master

data is data that remains unchanged over a long period of time. It contains

information that is always needed in the same way. Characteristics can bear

master data in BW. With master data you are dealing with attributes, texts

or hierarchies. Transaction data: Data relating to the day-to-day

transactions is the Transaction data.

20. Name some drawbacks of SAP - Interfaces are huge problem, Determine

where master data resides, Expensive, very complex, demands highly

trained staff, lengthy implementation time.

Page 20: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 20/30

21. What is Bex? - Bex stands for Business Explorer. Bex enables end user to

locate reports, view reports, analyze information and can execute queries.

The queries in workbook can be saved to there respective roles in the Bex

browser. Bex has the following components: Bex Browser, Bex analyzer, Bex

Map, Bex Web.

22. What are variables? - Variables are parameters of a query that are set in

the parameter query definition and are not filled with values until the

queries are inserted into workbooks. There are different types of variables

which are used in different application: Characteristics variables,

Hierarchies and hierarchy node, Texts, Formulas, Processing types, User

entry/Default type, Replacment Path.

23. What is AWB?. What is its purpose? - AWB stands for Administrator

WorkBench. AWB is a tool for controlling, monitoring and maintaining all the

processes connected with data staging and processing in the business

information whearhousing.

24. What is the significance of ODS in BIW? - An ODS Object serves to store

consolidated and debugged transaction data on a document level (atomic

level). It describes a consolidated dataset from one or more InfoSources.

This dataset can be analyzed with a BEx Query or InfoSet Query. The data of

an ODS Object can be updated with a delta update into InfoCubes and/or

other ODS Objects in the same system or across systems. In contrast to

multi-dimensional data storage with InfoCubes, the data in ODS Objects is

stored in transparent, flat database tables.

25. What are the different types of source system? - SAP R/3 Source

Systems, SAP BW, Flat Files and External Systems.

Page 21: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 21/30

26. What is Extractor? - Extractors is a data retrieval mechanisms in the SAP

source system. Which can fill the extract structure of a data source with the

data from the SAP source system datasets. The extractor may be able to

supply data to more fields than exist in the extract structure.

‹ SAP Interview QuestionsupWhat are BIW and BW? Why do they have a

significant role in Enterprise Resource Planning?

Page 22: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 22/30

Questions to ask recuiter

May 22, 2007 - 17:27 — cutegirl 

1. How did you find me?

2. Is this a retainer or contingency assignment?

3. Are you dealing with the client’s HR people, or do you have direct

contact with the hiring manager?

4. How long has the client been with you?

5. How many candidates have you placed with this client?

6. When will I find out the name of the principal or client company?

7. May I have a written job description?

8. Where is the position located?

9. Where is the company headquartered?

10. To whom does the position report?

11. Can you tell me about this executive’s management style?

12. Why is the position open?

13. What happened to the person who previously held this position?

14. Is this a new position?

15. How long has the position been open?

16. How long have you been working on the assignment?

17. What does the position pay?

18. Are here any pay or compensation constraints that I should take into

consideration?

19. What can you tell me about the person who will be interviewing me?

20. What is his or her position, title, management style?

21. Who will make the final hiring decision?

22. After you present my resume, when can I expect to hear from you

regarding the status of this position?

23. Can you describe, specifically, how the company navigates/balanceswork? and personal-life issues?

Page 23: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 23/30

24. What might I do that would violate the culture of the company during

my interview?

25. What is the work environment like, cubicles, offices, large open area,

etc…?

26. What is the proper dress code for the interview?

27. How many people are there on this team/project/assignment that I will

be closely working with?

28. What is the normal/acceptable work schedule, 8/5, 10/4, etc…?

Page 24: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 24/30

A TRUTHFUL HR INTERVIEW

September 13, 2006 - 12:45 — meera 

Honestly, we will have these answers in our mind ... but we give different,

tailored and suitable answers to the guy !

1. Why did you apply for this job?

I have applied for many jobs along with this and you called me now.

2. Why do you want to work for this company?

I have to work for some company who ever gives me a job, I don't have any

specific company in mind.

3. Why should I hire you?

You have to hire some one, you may give me a try.

4. What would you do if this happened?

Well, it depends my mindset and mood at that situation...

5. What is your biggest strength?

Basically, daring to join any company who pays me well, without thinking of

the fate of company

6. What is your biggest weakness?

Girls

7. What was your worst mistake, and how did you learn from it?

Joining my earlier company and learnt that I need to jump to get moremoney, so I am here today

Page 25: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 25/30

8. What accomplishments in your last position are you most proud of?

Had I accomplished any in my last position, why do I need to change my job?

I could demand more and stay there.

9. Describe a challenge you faced and how you overcame it?

Biggest challenge is answering the question "why are you looking for a

change" and I started blabbering irrelevantly to overcome that.

10. Why did you leave/ are you leaving your last job?

For the same reason why you left your earlier job

11. What do you want from this job?

If no work is given but keep giving good hikes

12. What are your career goals and how do you plan to achieve them?

Make more money and for that keep jumping companies for every 2 yrs

13. Did you hear of our company and what do you know of us?

Yeah, I know that you will ask this, I've gone through your website

14. What is the salary expected and how do justify that?

Well, no one will change job for the same salary, hence, give me 20% extra

than what I am getting and that is unpublished industry standard

(I know you will bargain on what ever I ask, hence, I have already hiked my

current salary by 30%)

Page 26: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 26/30

Creativity is the master of presence of mind

May 6, 2006 - 12:26 — sandeep 

Not only our technical knowledge helps, but also the presence of mind and

the right answer at right time. Even if you don't know the answer for a

question, just confuse the questioner...

Question and the Answer given by Candidates, oh! sorry they are IAS*

Officers now. (*Indian Administrative Service)

Q. How can you drop a raw egg onto a concrete floor without cracking it?A. Concrete floors are very hard to crack! (UPSC Topper)

Q. If it took eight men ten hours to build a wall, how long would it take four

men to build it?

A. No time at all it is already built. (UPSC 23 Rank Opted for IFS)

Q. If you had three apples and four oranges in one hand and four apples andthree oranges in the other hand, what would you have?

A. Very large hands.(Good one) (UPSC 11 Rank ! Opted for IPS)

Q. How can you lift an elephant with one hand?

A. It is not a problem, since you will never find an elephant with one hand.

(UPSC Rank 14 Opted for IES)

Q. How can a man go eight days without sleep?

A. No Problems, he sleeps at night. (UPSC IAS Rank 98)

Q. If you throw a red stone into the blue sea what it will become?

A. It will Wet or Sink as simple as that. (UPSC IAS Rank 2)

Q. What looks like half apple ?

A. The other half. (UPSC - IAS Topper )

Page 27: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 27/30

Q. What can you never eat for breakfast ?

A . Dinner.

Q. What happened when wheel was invented ?

A, It caused a revolution.

Q. Bay of Bengal is in which state?

A. Liquid (UPSC 33 Rank )

Q. Interviewer said "I shall either ask you ten easy questions or one really

difficult question. Think well before you make up your mind!"

A. The boy thought for a while and said, "my choice is one really difficult

question."

Q."Well, good luck to you, you have made your own choice! Now tell me

this: "What comes first, Day or Night?"

A. The boy was jolted into reality as his admission depends on the

correctness of his answer, but he thought for a while and said, "It's the DAY

sir!"

Q. "How" the interviewer asked,

A. "Sorry sir,you promised me that you will not ask me a SECOND difficult

question!" He was selected for IIM!

Technical Skill is the mastery of complexity, while Creativity is the master

of presence of mind..........

Page 28: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 28/30

Modesty Pays.......

March 15, 2006 - 14:21 — cutegirl 

Interviewer: Tell me about yourself.

Candidate: I am Rameshwar Kulkarni. I did my Tele Communication

engineering from BabanRao Dhole-Patil Institute of Technology.

Interviewer: BabanRao Dhole-Patil Institute of Technology? I had never

heard of this college before!

Candidate: Great! Even I had not heard of it before getting an admission

into it . What happened is - due to cricket world cup I scored badly! in

12th.I was getting a paid seat in a good college. But my father said (I prefer

to call him 'baap') - "I can not invest so much of money".(The baap actually

said - "I will never waste so much of mon ey on you"). So I had to join this

college. Frankly speaking this name - BabanRao Dhole-Patil, can at the most

be related to a Shetakari Mahavidyalaya. Interviewer: ok, ok. It seems you

have taken 6 years to complete your engineering.

Candidate: Actually I tried my best to finish it in 4 years. But you know,

these cricket matches and football world cup, and tennis tournaments. It is

difficult to concentrat e. So I flunked in 2nd and 3rd year. So in all I took 4 +

2 = 7 years.

Interviewer: But 4+2 is 6.

Candidate: Oh, is it? You know I always had KT in maths. But I will try to

keep this in mind. 4+2 is 6, good, thanks. These cricket matches really

affect exams a lot. I think they should ban it.

Interviewer: Good to know that you want cricket matches to be banned.

Candidate: No, no... I am talking about Exams!!

Interviewer: Ok, What is your biggest achievement in life?

Candidate: Obviously, completing my Engineering. My mom never thought I

would complete it. In fact, when i flunked in 3rd year, she was looking for ajob for me in BEST (Bus corporation in Maharashtra) through some relative.

Page 29: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 29/30

Interviewer: Do you have any plans of higher study?

Candidate: he he he.. Are you kidding? Completing 'lower' education itself

was so much of pain!!

Interviewer: Let's talk about technical stuff. On which platforms have you

worked?

Candidate: Well, I work at SEEPZ, so you can say Andheri is my current

platform. Earlier I was at Vashi center. So Vashi was my platform then. As

you can see I have experience of different platforms! (Vashi and Andheri are

the places in Mumbai)

Interviewer: And which languages have you used?Candidate: Marathi, Hindi, English. By the way, I can keep quiet in German,

French, Russian and many other languages.

Interviewer: Why VC is better than VB?

Candidate: It is a common sense - C comes after B. So VC is a higher version

than VB. I heard very soon they are coming up with a new language VD!

Interviewer: Do you know anything about Assembly Language?

Candidate: Well, I have not heard of it. But I guess, this is the language our

ministers and MPs use in assembly.

Interviewer: What is your general project experience?

Candidate: My general experience about projects is - most of th! e times

they are in pipeline!

Interviewer: Can you tell me about your current job?

Candidate: Sure, Currently I am working for Bata InfoTech ltd. Since joining

BIL, I am on Bench. Before joining BIL, I used to think that Bench was

another sof tware like Windows.

Interviewer: Do you have any project management experience?

Candidate: No, but I gues! s it shouldn't be difficult. I know Word and Excel.

I can talk a lot. I know how to dial for International phone call and use

speaker facility. And very important - I know few words like - 'Showstoppers

Page 30: Behavioral Interview Techniques

8/4/2019 Behavioral Interview Techniques

http://slidepdf.com/reader/full/behavioral-interview-techniques 30/30

' , 'hotfixes', 'SEI-CMM','quality','versioncontrol','deadlines' , 'Customer Satisf

action' etc. Also I can blame others for my mistakes!

Interviewer: What are your expectations from our company?

Candidate: Not much.

1. I should at least get 40,000 in hand.

2. I would like to work on a live EJB project. But it should not have

deadlines. I personally feel that pressure affects natural talent.

3. I believe in flexi-timings.

4. Dress code is against basic freedom, so I would like to wear t-shirt and

jeans.5. We must have sat-sun off. I will suggest Wednesday off also, so as to

avoid breakdown due to overwork.

6. I would like to go abroad 3 times a year on short term preferably 1-2

months) assignments. Personally I prefer US, Australia and Europe. But

considering the fact that there is a world cup in West Indies in 2007, I don't

mind going there in that period. As you can see I am modest and don't have

many expectations. So can I assume my selection?

Interviewer: he he he ha ha ha. Thanks for your interest in our organization.

In fact I was never entertained so much before. Welcome to INFOSYS .. :-))

We look forward to working with you..:-))