Discussion
Home ‣ Interview ‣ Technology Comments
- Question
How do you generate Sequence number in Datastage?
- Correct Answer
- Sequence numbers can be generated in Datastage using certain routines They are -KeyMgtGetNextVal -KeyMgtGetNextValConn
- 1. What are the components of DataStage? Discuss
- 2. What is DataStage? Discuss
- 3. Describe the foreign key columns in fact table and dimension table. Discuss
- 4. What are the activities we will do in SAP MM module implementation? Discuss
- 5. What is the differences between ABAP and OOABAP. In which situation we use OOABAP? Discuss
- 6. How to perform incremental load in DataStage? Discuss
- 7. What is the difference between operational data stage (ODS) and data warehouse? Discuss
- 8. 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
- 9. Difference between ActiveX Exe and Dll ? Discuss
- 10. With a heredoc syntax, do I get variable substitution inside the heredoc contents? Discuss
Technology problems
Search Results
Correct Answer: Datastage has two components -Client Components ? Designer, Director, Manager and Administrator -Server Components ? Server, Repository and Plug-ins
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: -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
Correct Answer: Yes
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.