Discussion
Home ‣ Interview ‣ Technology Comments
- Question
What is DataStage?
- Correct Answer
- - A tool for designing Extraction, Transformation and Loading - An ideal tool for data integration projects system migrations - Importing, extracting and creating metadata are within these jobs - Data stage allows scheduling, monitoring and running the jobs - Allows to administer the development and execution in a single environment
- 1. Describe the foreign key columns in fact table and dimension table. Discuss
- 2. What are the activities we will do in SAP MM module implementation? Discuss
- 3. What is the differences between ABAP and OOABAP. In which situation we use OOABAP? Discuss
- 4. Which of these phrases best describes the business cycle?
Options- A. The process of creating policy for businesses, beginning with agenda setting and ending with evaluating the policy's effect on the business's bottom line
- B. A recurring cycle of booms and busts, recoveries and recessions
- C. A system of managing the economy by increasing or decreasing the supply of money
- D. A system of managing the economy by increasing or decreasing federal expenditures Discuss
- 5. What is the difference between BRD, SRS and Use Case documents? Discuss
- 6. What are the components of DataStage? Discuss
- 7. How do you generate Sequence number in Datastage? Discuss
- 8. How to perform incremental load in DataStage? Discuss
- 9. What is the difference between operational data stage (ODS) and data warehouse? Discuss
- 10. Which of the following is not a function of a Warehouse?
Options- A. Ensuring Profit
- B. Stabilisation in price
- C. Risk-bearing
- D. Storage Discuss
Technology problems
Search Results
Correct Answer: The primary keys of entity tables are the foreign keys of dimension tables The Primary keys of fact dimensional table are the foreign keys of fact tablels
Correct Answer: Various activities in SAP MM are : Inventory, Warehouse, Purchasing, Vendor evolution, Invoice varification, etc
Correct Answer: OOABAP is used to develop BSP/PCUI applications and also anthing involved object oriented like BADIs, SmartFormsetcwhere as ABAP is used to develop traditional programs in R/3
Correct Answer: A recurring cycle of booms and busts, recoveries and recessions
Correct Answer: BRD - Business Requirement document is consist of functional Business Requirements, Gap Analysis (between current and future scenarios), In scope and Out of scope of the project, Business rules, Assumptions, Risk etc SRS - Source Requirement Specification is consist of Use cases, Use Case Scenarios, Activity flow diagram, Non functional Business Requirements Use cases - are the pictorial representation of user centric view of the system
Correct Answer: Datastage has two components -Client Components ? Designer, Director, Manager and Administrator -Server Components ? Server, Repository and Plug-ins
Correct Answer: Sequence numbers can be generated in Datastage using certain routines They are -KeyMgtGetNextVal -KeyMgtGetNextValConn
Correct Answer: -Daily loading is known as incremental load -When data is selected from source, selected records are loaded between timestamp of last load and the current time -The parameter that are passed to perform are last loaded date and current date -The first parameter is the stored last run date is read through job parameters -The second parameter is the current date
Correct Answer: Data warehouse - It is a decision support database system for the purpose of organizational needs -It is non volatile, integrated and time variant collection of data Operational Data Stage - It is an integrated collection of information -It can contain 90 days of information at maximum -ODS supports dynamic data
Correct Answer: Ensuring Profit
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.