InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Is file format in Data Services type of a data store? |
| Answer» | |
| 2. |
How do you manage slowly changing dimensions? What are the fields required in managing different types if SCD? |
| Answer» | |
| 3. |
What is slowly changing dimension? |
| Answer» | |
| 4. |
Suppose you have updated the version of Data Services software? Is it required to update the repository version? |
| Answer» | |
| 5. |
You want to perform multiuser migration in SAP BODS. How you can perform this? |
| Answer» | |
| 6. |
What do you understand by multiuser development in BODS? How do you manage multiuser development? |
| Answer» | |
| 7. |
Explain the different performance optimization techniques in BODS? |
| Answer» | |
| 8. |
What is the use of Data Profiling? |
| Answer» | |
| 9. |
What are the different recovery mechanism that can be used in failed jobs? |
| Answer» | |
| 10. |
How variables are different form parameters in a Data Services job? |
| Answer» | |
| 11. |
What are local and global variables in Data services job? |
| Answer» | |
| 12. |
What are the different types of embedded data flow? |
| Answer» | |
| 13. |
What is an embedded data flow? |
| Answer» | |
| 14. |
Explain the different between real time and batch job in Data Services? |
| Answer» | |
| 15. |
What is a real time job in Data Services? |
| Answer» | |
| 16. |
What is difference between text data processing and data cleansing? |
| Answer» | |
| 17. |
What is text data processing transformation? |
| Answer» | |
| 18. |
What is the use of query transformation? |
| Answer» | |
| 19. |
What are different transformations under data integration? |
| Answer» | |
| 20. |
What are the common transformations that are available in Data Services? |
| Answer» | |
| 21. |
What is a transformation in Data Services? |
| Answer» | |
| 22. |
What is the use of conditionals? |
| Answer» | |
| 23. |
Give an example of work flow in production? |
| Answer» | |
| 24. |
Is it possible that a workflow call itself in Daa services job? |
| Answer» | |
| 25. |
What are the different objects that you can add to work flow? |
| Answer» | |
| 26. |
Why do you use work flow in DS? |
| Answer» | |
| 27. |
What are the different properties that you can set for a data flow? |
| Answer» | |
| 28. |
What are different objects that you can add to a dataflow? |
| Answer» | |
| 29. |
What is the use of data flow in DS? |
| Answer» | |
| 30. |
You want to extract data from an Excel work book. How you can do this? |
| Answer» | |
| 31. |
What are the different types of files can be used as source and target file format? |
| Answer» | |
| 32. |
You want to import application metadata into repository. How you can perform this? |
| Answer» | |
| 33. |
What is linked datastore? Explain with an example? |
| Answer» | |
| 34. |
How do you improve the performance of data flows using memory datastore? |
| Answer» | |
| 35. |
How do you check existing objects in DS repository? |
| Answer» | |
| 36. |
What is SAP Data Services Designer? What are main ETL functions that can be performed in Designer tool? |
| Answer» | |
| 37. |
How do you check the execution history of a job or a data flow? |
| Answer» | |
| 38. |
What is the template table? |
| Answer» | |
| 39. |
You want to generate the quality reports in DS system, data validation, and documentation. Where you can see this? |
| Answer» | |
| 40. |
How do you manage object versions in BODS? |
| Answer» | |
| 41. |
What is a real time Job? |
| Answer» | |
| 42. |
You want to set up a new repository in BODS. How do you create it? |
| Answer» | |
| 43. |
What is a Data Store in Data services designer and what are different types of Data Stores? |
| Answer» | |
| 44. |
What is single object and reusable objects in Data services? |
| Answer» | |
| 45. |
What is a repository in BODS? What are the different types of Repositories in BODS? |
| Answer» | |
| 46. |
Explain the architecture of BODS with Job Server, Repository Manager, and Management Console? |
| Answer» | |
| 47. |
What is SAP Data services? |
| Answer» | |
| 48. |
Why do we need a staging area in an ETL process? |
| Answer» | |
| 49. |
What is the difference between OLTP and a Data warehouse? |
| Answer» | |