Bods Interview Q&A

1) What objects resuse in DataServices?
jobs,workflow,dataflow
2) tell me about transformations in sap bods?
Transforms & Categories (DI, DQ, PF)
Data Integration
Data_Transfer, Date_Generation
Data Integration Effective_Date, Hierarchy_Flattening
Data Integration History_Preserving, Key_Generation
Data Integration Pivot, Reverse_Pivot, XML_Pipeline
Platform Case, Map_Operation, Merge, Query
Platform SQL, Validation Custom ABAP Transform
3) what is job ?
A job is the smallest unit of work that you can schedule independently for e
xecution.
4) what is Workflow in sap bods?
A work flow defines the decision-making process for executing data flows
5) what is Dataflow?
Data flows extract, transform, and load data. Everything having to do with data
, including reading sources, transforming data, and loading targets, occurs insi
de a data flow.
6) tell me about Scripts in sap bods?
A Script is a single-use object that is used to call functions and assign values
in a workflow. To apply decision-making and branch logic to work flows DI scrip
ting language is used
7)tell me about Data Quality Transforms in sap bods ETL processes?
Associate
Country_ID
Data_Cleanse
DSF2_Walk_Sequencer
Geocoder
Global_Address_Cleanse
Global_Suggestion_List
Match
USA_Regulatory_Address_Cleanse
User_Defined
8)tell me about Data Cleanseing processes?
Use the Data Cleanse transform to parse and format custom or person and firm dat
a as well as phone numbers, dates, e-mail addresses, and Social Security numbers
.
Custom data includes operational or product data specific to the business.
The cleansing package we specify defines how our data should be parsed and stand
ardized.
Within a data flow, the Data Cleanse transform is typically placed after the add
ress cleansing process and before the matching process
9)What is Dictionary in BODS?
10) what is Directory in BODS?
11)what are components in Data Services ?
Designer
Repository
Job Server
Engines
Access Server
Adapters
Real-time Services
Address Server
Cleansing Packages, Dictionaries, and Directories
Management Console [sociallocker]
12)How to reduced SCD Type 3 in SAP BODS?
13) what is Pivot Transformation?
14)What is Repository and a Datastore in data Services ?
repository is a set of tables that holds user-created and predefined system obje
cts, source and target metadata, and transformation rules. There are 3 types of
repositories.
A local repository
A central repository
A profiler repository
datastore is a connection to a database
There are three kinds of Datastores namely Database Datastores (RDBMS), Applicat
ion Datastores (ERP) and Adapter Datastores (3rd Party applications).
15) what is Row-by-row select Table Tranform ?
16)what is performance tuning in data services ?
17)what is Case Transform?
18)What is Auto Correct Load in SAP BODS?
Auto correct loading ensures that the same row is not duplicated in a target tab
le
19)what use of A profiler repository?
the profiler repository is used by the Profile Server for doing Data profiling (
statistical analysis and insigh tinto the data content and relationship, Min/Max
values, Frequency Distribution, Pattern Analysis) and Data QUality Assessment t
asks.
A good component to quickly get detailled insight into the content of your table
s and use this information to measure the quality level.
Profiler repositroy stores following information
1 - Profiler tasks, that are created when a profiling request is submitted from
Desginer, from the Management Console you can monitor the progress and execution
of these task
2 - Profiling result (data), when you profile columns of tables, the summay and
detail information will be stored in profiler repo, along with the sample data f
or each profiling attribute (this from where the profiler results are displayed
in Designer)
Profiles repositroy is stores information Like, Profiles of the tasks that occur
when a request is made from profiling desgin of the management console you can
monitor the development and implementation of these two tasks 1. Performance Profiling when the columns of tables profile information profiles
and detailed Summary stored in the repository.
20)tell me about Array fetch size in BODS?
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------***********************************************************
********************************************************************************
********************************************************************************
********************************************************************************
***********************************
Design type 2 in BODS?
1. History preserve transform
2. Table comparison, map operation, case transform
What will happen if a column removed in sql t/f?
1. Job will not show error while validating but during running or if we update s
chema in sql t/f, it will fail.
How to call a batch script in BODS?
1. EXEC function
How oracle table values loaded into variables?
1. SQL function
How to use pushdown sql in BODS?
1. To limit data from source/target
2. Reduce the barrier between source/target to BODS
What are date types available?
Date
Datetime
Timestamp
What are the available memory types in data flows?
1. Pageable
2. In Memory
The software provides the following types of caches that your data flow can use
for all of the operations it contains:
In-memory
Use in-memory cache when your data flow processes a small amount of data that fi
ts in memory.
Pageable cache
Use a pageable cache when your data flow processes a very large amount of data t
hat does not fit in memory.
How to import data from table in datastore?
1. Import table by giving owner name
Company Name
How many types datastores in BODS?
3 Types
Databases and mainframe file systems.

Applications that have pre-packaged or user-written adapters.
J.D. Edwards One World and J.D. Edwards World, Oracle Applications, PeopleSoft,
SAP ERP and SAP NetWeaver BW, and Siebel Applications. See the appropriate suppl
ement guide.
Difference between parameters and variables?
What are the available lookups and brief about those?
Lookup
Lookup_ext
Lookup_seq
Difference between row by row and cached in table comparison?
Huge (more than 50% source) delta data/net change data, then cached
Less than 20% source data then row by row
Available flags in Map Operation transform?
Insert, update, delete, discard
What is the use of row limit fetch?
Commit check points
What is hierarchy transform?
What is dataflow audit?
Use of number of loaders in target?
What are SCD?
Slowly changing concept for dimensions only
Type1
Type2
Type3
What are additive and non additives?
This concept for Fact only
What is conform dimension?
Time dimension - Fiscal and calender can be maintained with same dimension
Same dimension for sales fact and inventory facts
Company Name
Brief about oracle exception? Built in and user defined?
Write an exception to update data when data not inserted?
Exception when unique constraint error exists - Duplicate
Can we do DML operation in oracle function?
Yes
Can we call oracle function with DML operation in SELECT statement?
It throws error
What is the use of user hints?
If table is having multiple indexes, we can suggest which index need to be used.
Parallel option
How parallel hint works?

Based on number of usages
Difference between procedure and package?
Procedure will be locked state when it's using
Package will not be locked
Company Name
What is incremental load?
How dimensional loading and fact loading will be implemented in BODS?
What are the transforms used in BODS?
What is the use of MAP_OPERATION transform?
What are the components in BODS?
Designer
Admin console
Server Manager
Repository Manager
License Manager
Metadata Manager
Locale Selector
What is the types of variables?
Global Variables
Local Variables
What is the use of parameters?
Types of error logs in BODS?
Trace
Monitor
Error log
How to improve performance of a job?
How to identify long running dataflows in a job?
How to improve performance in BODS?

Bods Interview Q&A

Uploaded by

Copyright:

Available Formats

Bods Interview Q&A

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Bods Interview Q&A

Uploaded by

Copyright:

Available Formats

What are the main components in SAP BODS?

What are the different types of transforms used in SAP BODS?

1) What objects resuse in DataServices?

Databases and mainframe file systems.

How parallel hint works?

You might also like