11. What is the difference between a data store and a database?
A datastore is a connection to a database.
12. How many types of datastores are present in Data services?
Three.
? Database Datastores: provide a simple way to import metadata directly froman RDBMS.
? Application Datastores: let users easily import metadata frommost Enterprise Resource Planning (ERP) systems.
? Adapter Datastores: can provide access to an application’s data and metadata or just metadata.
13. What is the use of Compace repository?
Remove redundant and obsolete objects from the repository tables.
14. What are Memory Datastores?
Data Services also allows you to create a database datastore using Memory as the Database type. Memory Datastores are designed to enhance processing performance of data flows executing in real-time jobs.
15. What are file formats?
A file format is a set of properties describing the structure of a flat file (ASCII). File formats describe the metadata structure. File format objects can describe files in:
? Delimited format — Characters such as commas or tabs separate each field.
? Fixed width format — The column width is specified by the user.
? SAP ERP and R/3 format.
16. Which is NOT a datastore type?
File Format
17. What is repository? List the types of repositories.
The DataServices repository is a set of tables that holds user-created and predefined system objects, source and target metadata, and transformation rules. There are 3 types of repositories.
? A local repository
? A central repository
? A profiler repository
18. What is the difference between a Repository and a Datastore?
A Repository is a set of tables that hold system objects, source and target metadata, and transformation rules. A Datastore is an actual connection to a database that holds data.
19. What is the difference between a Parameter and a Variable?
A Parameter is an expression that passes a piece of information to a work flow, data flow or custom function when it is called in a job. A Variable is a symbolic placeholder for values.
20. When would you use a global variable instead of a local variable?
? When the variable will need to be used multiple times within a job.
? When you want to reduce the development time required for passing values between job components.
? When you need to create a dependency between job level global variable name and job components.
A datastore is a connection to a database.
12. How many types of datastores are present in Data services?
Three.
? Database Datastores: provide a simple way to import metadata directly froman RDBMS.
? Application Datastores: let users easily import metadata frommost Enterprise Resource Planning (ERP) systems.
? Adapter Datastores: can provide access to an application’s data and metadata or just metadata.
13. What is the use of Compace repository?
Remove redundant and obsolete objects from the repository tables.
14. What are Memory Datastores?
Data Services also allows you to create a database datastore using Memory as the Database type. Memory Datastores are designed to enhance processing performance of data flows executing in real-time jobs.
15. What are file formats?
A file format is a set of properties describing the structure of a flat file (ASCII). File formats describe the metadata structure. File format objects can describe files in:
? Delimited format — Characters such as commas or tabs separate each field.
? Fixed width format — The column width is specified by the user.
? SAP ERP and R/3 format.
16. Which is NOT a datastore type?
File Format
17. What is repository? List the types of repositories.
The DataServices repository is a set of tables that holds user-created and predefined system objects, source and target metadata, and transformation rules. There are 3 types of repositories.
? A local repository
? A central repository
? A profiler repository
18. What is the difference between a Repository and a Datastore?
A Repository is a set of tables that hold system objects, source and target metadata, and transformation rules. A Datastore is an actual connection to a database that holds data.
19. What is the difference between a Parameter and a Variable?
A Parameter is an expression that passes a piece of information to a work flow, data flow or custom function when it is called in a job. A Variable is a symbolic placeholder for values.
20. When would you use a global variable instead of a local variable?
? When the variable will need to be used multiple times within a job.
? When you want to reduce the development time required for passing values between job components.
? When you need to create a dependency between job level global variable name and job components.
No comments:
Post a Comment