DS

SAP Data Services


Qs:10 Which data provisioning method can you use to load data from SAP business content DataSources into SAP HANA? (Choose two)

A. SAP Landscape Transformation (SLT) 
B. SAP Landscape Directory (SLD) 
C. SAP Direct Extractor Connection (DXC) 
D. SAP BusinessObjects Data Services

Qs:21 Using SAP BusinessObjects Data Services, in which of the following can you perform data transformations? (Choose two)

A. Query 
B. Datastore 
C. XML File 

D. Script

Qs:44 A company needs to load external data from a flat file into SAP HANA. How can you do this? (Choose two)

A. SAP HANA Direct Extractor Connection (DXC) 
B. SAP System Landscape Transformation (SLT) 
C. SAP HANA SQL Import statement 

D. SAP BusinessObjects Data Services

• Data Services creates tables in column store per default
• ERP and BW can be connected to HANA using Data services or Sybase Replication
• Data from BW into HANA can be loaded into using Data Services and Info spokes
• Admin Workstations: Data Services Designer
• b) SAP BPC or Non-SAP à Data Services/BODS (Near Real-time Replication) à SAP HANA à BO à Presentation

F)  Data Services :

i.  Data Services 4.0

       ii.  Data Services Job Server

      iii.  Repository (shared with BOC)

  Data Services 3 questions
#Analytic Privileges 2 questions

10. What replication method is good for complex transformation?

Ans  ETL base Replication ( Data Services )

39.  How do you verify the quality of HANA
a.  Use SQL Editors 
b.  Compare data with HANA_STATISTICS 
c.  Use data service quality process
d.  Use WEBI report 
e.  Use SLT to very quality 
f.   Compare ERP with HANA data

15.  List out the ETL based replication?     SBO Data Services (ETL Based)

39.  OPD for data replication API is used in which replication ?    Data Services 4.0

48.  Which Business Objects tool is used for replicating data to HANA ?     Data Services Designer

15.  Verify the quality of HANA.

 Ans: a) Use sql editors, b) compare data with HANA_STATISTICS, c) use data service quality process, d) use webi report, e)  use SLT

http://dba1admin.blogspot.com/2012/11/businessobjects-data-services.html