Discussion
Home ‣ Interview ‣ Technology Comments
- Question
What are the components of DataStage?
- Correct Answer
- Datastage has two components -Client Components ? Designer, Director, Manager and Administrator -Server Components ? Server, Repository and Plug-ins
- 1. What is DataStage? Discuss
- 2. Describe the foreign key columns in fact table and dimension table. Discuss
- 3. What are the activities we will do in SAP MM module implementation? Discuss
- 4. What is the differences between ABAP and OOABAP. In which situation we use OOABAP? Discuss
- 5. 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
- 6. How do you generate Sequence number in Datastage? Discuss
- 7. How to perform incremental load in DataStage? Discuss
- 8. What is the difference between operational data stage (ODS) and data warehouse? Discuss
- 9. 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
- 10. Difference between ActiveX Exe and Dll ? Discuss
Technology problems
Search Results
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
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: 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
Correct Answer: ActiveX DLL: It is an in process server It runs within the application time ActiveX Exe: It is an out of process server MS-Excel is an activex exe when u call the excel from the vb application u can in the task manager an excel exe will run, whereas for dll u can't see like that
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.