2) What is data integrityand how can we achieve this?
3) What is index maintenance and what is the purpose to use this in real time?
4) When and why use infocube compression in real time?
5) What is mean by data modelling and what will the consultant do in data modelling?
6) How can enhance business content and what for purpose we enhance business content (becausing we can activate business content)
7) What is fine-tuning and how many types are there and what for purpose we done tuning in real time. tuning can only be done for infocube partitions and creating aggregates or any other?
8) What is mean by multiprovider and what purpose we use multiprovider?
9) What is scheduled and monitored data loads and for what purpose?
Ans # 1:
Process chains exists in Admin Work Bench. Using these
we can automate ETTL processes. These allows BW guys to schedule all activities
and monitor (T Code: RSPC).
PROCESS CHAIN - Before defining PROCESS CHAIN, let us define PROCESS in any given process chain. Is a procedure either with in the SAP or external to it with a start and end. This process runs in the background.
PROCESS CHAIN is set of such processes that are linked together in a chain. In other words each process is dependent on the previous process and dependencies are clearly defined in the process chain.
This is normally done in order to automate a job or task
that has to execute more than one process in order to complete the job
or task.
1. Check the Source System for that particular PC.
2. Select the request ID (it will be in Header Tab) of
PC
3. Go to SM37 of Source System.
4. Double Click on the Job.
5. You will navigate to a screen
6. In that Click "Job Details" button
7. A small Pop-up Window comes
8. In the Pop-up screen, take a note of
a) Executing Server
b) WP Number/PID
9. Open a new SM37 (/OSM37) command
10. In the Click on "Application Servers" button
11. You can see different Application Servers.
11. Goto Executing server, and Double Click (Point 8
(a))
12. Goto PID (Point 8 (b))
13. On the left most you can see a check box
14. "Check" the check Box
15. On the Menu Bar.. You can see "Process"
16. In the "process" you have the Option "Cancel with
Core"
17. Click on that option.
* -- Ramkumar K
Ans # 2:
Data Integrity is about eliminating duplicate entries
in the database and achieve normalization.
Ans # 4:
InfoCube compression creates new cube by eliminating
duplicates. Compressed infocubes require less storage space and are faster
for retrieval of information. Here the catch is .. Once you compress, you
can't alter the InfoCube. You are safe as long as you don't have any error
in modeling.
This compression can be done through Process Chain and also manually.
Tips by: Anand
Ans#3
Indexing is a process where the data is stored by indexing
it. Eg: A phone book... When we write somebodys number we write it as Prasads
number would be in "P" and Rajesh's number would be in "R"... The phone
book process is indexing.. similarly the storing of data by creating indexes
is called indexing.
Ans#5
Datamodeling is a process where you collect the facts..the
attributes associated to facts.. navigation atributes etc.. and after you
collect all these you need to decide which one you ill be using. This process
of collection is done by interviewing the end users, the power users, the
share holders etc.. it is generally done by the Team Lead, Project Manager
or sometimes a Sr. Consultant (4-5 yrs of exp) So if you are new you dont
have to worry about it....But do remember that it is a imp aspect of any
datawarehousing soln.. so make sure that you have read datamodeling before
attending any interview or even starting to work....
Ans#6
We can enhance the Business Content bby adding fields
to it. Since BC is delivered by SAP Inc it may not contain all the infoobjects,
infocubes etc that you want to use according to your company's data model...
eg: you have a customer infocube(In BC) but your company uses a attribute
for say..apt number... then instead of constructing the whole infocube
you can add the above field to the existing BC infocube and get going...
Ans#7
Tuning is the most imp process in BW..Tuning is done
the increase efficiency.... that means lowering time for loading data in
cube.. lowering time for accessing a query.. lowering time for doing a
drill down etc.. fine tuning=lowering time(for everything possible)...tuning
can be done by many things not only by partitions and aggregates there
are various things you can do... for eg: compression, etc..
Ans#8
Multiprovider can combine various infoproviders for reporting
purposes.. like you can combine 4-5 infocubes or 2-3 infocubes and 2-3
ODS or IC, ODS and Master data.. etc.. you can refer to help.sap.com for
more info...
Ans#9
Scheduled data load means you have scheduled the loading
of data for some particular date and time you can do it in scheduler tab
if infoobject... and monitored means you are monitoring that particular
data load or some other loads by using transaction RSMON.
Tips by: Nikhil
