Discussion
Home ‣ Interview ‣ Technology Comments
- Question
How to perform incremental load in DataStage?
- 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
- 1. How do you generate Sequence number in Datastage? Discuss
- 2. What are the components of DataStage? Discuss
- 3. What is DataStage? Discuss
- 4. Describe the foreign key columns in fact table and dimension table. Discuss
- 5. What are the activities we will do in SAP MM module implementation? Discuss
- 6. What is the difference between operational data stage (ODS) and data warehouse? Discuss
- 7. 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
- 8. Difference between ActiveX Exe and Dll ? Discuss
- 9. With a heredoc syntax, do I get variable substitution inside the heredoc contents? Discuss
- 10. Will comparison of string "10" and integer 11 work in PHP? Discuss
Technology problems
Search Results
Correct Answer: Sequence numbers can be generated in Datastage using certain routines They are -KeyMgtGetNextVal -KeyMgtGetNextValConn
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: 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
Correct Answer: Yes, internally PHP will cast everything to the integer type, so numbers 10 and 11 will be compared
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.