Discussion
Home ‣ Interview ‣ Technology Comments
- Question
Why we can't create an aggregate on an ODS Object?
- Correct Answer
- 1 Operational Data Store has very low data latency Data moved to ODS mostly on event based rather than time based ETL to Data Warehouse/Data Mart 2 ODS is more closer to OLTP system We don't normally prefer to store aggregated data in OLTP So it is with ODS 3 Unlike data warehouse where data is HISTORICAL, ODS is near real time(NRT) So data aggregation is less important is ODS as data keeps changing
- 1. How do we Tune the BO Reports for Performance Improvement? Discuss
- 2. What are the challenges faced while successfully implementing Business intelligence? Discuss
- 3. Can any object be stored in a View state in .NET ? Discuss
- 4. What is MDM ? Discuss
- 5. Which command displays memory usage in linux?
Options- A. Top
- B. Free
- C. Buffer
- D. Swap Discuss
- 6. What is hierarchy relationship in a dimension. whether it is: 1) 1:1 2) 1:m 3) m:m Discuss
- 7. What is a key field in an IMS database? Discuss
- 8. What is the use of SYSPRINT, SYSIN, DUMMY in JCL ? Discuss
- 9. How will you call the return code of JCL ? Discuss
- 10. How do you check the syntax of a JCL without running it? Discuss
Technology problems
Search Results
Correct Answer: We can tune the report by using index awarness in universe
Correct Answer: Most companies grasp the potential value of successful business intelligence applications However, a common challenge that IT professionals encounter is how to find successful BI application that are adopted by users and make a positive impact on the organization and on the bottom line It can be difficult to structure effective BI project teams, select the right BI application, manage business-IT communications and measure BI success BI is robust application, developing and optimizing successful BI application is always a challenge which involves structuring BI teams and managing business-IT communication
Correct Answer: View state is a repository in an ASPNET page that can store values that need to be retained during postback
Correct Answer: MDM is short for Mobile Device Management The term generally refers to a system that hooks into the operating system on smartphones to collect information or apply restrictions and security precautions that may be sound company policy This is true for Miradore Online, our free MDM product you can get started with today
Correct Answer: Free
Explanation:
Free command displays memory usage in linux.
Correct Answer: 1:m
Correct Answer: A Field that DL/I uses to maintain the segments in the ascending order is called the key field
Correct Answer: SYSPRINT: All system output will appear under this DD card Suppose you are copying a VSAM file using IDCAMS Then, number of records processed, highest condition code etc will appear under sysprint You cannot customise SYSPRINT output SYSIN: This is nothing but SYStem INstruction Suppose, you want to sort a file on certain key You have to have following command under SYSIN SORT FIELDS = (starting-col,length,data-type,A/D) SUM FIELDS = NONE DUMMY: Mainly used where user is intended to simulate a program without creating an output file
Correct Answer: Return Code in JCL can b obtained by the use of COND paramaterit is used to know the return codes of previous steps
Correct Answer: TYPERUN=SCAN on the JOB card or use JSCAN TYPERUN=HOLD on the job card it is used for syntatical checks and direct job to spool and hold it
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.