What is the use of SYSPRINT, SYSIN, DUMMY in JCL ?
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: 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
4. How do we Tune the BO Reports for Performance Improvement?
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: 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
8. Which of the following type of data member can be shared by all instances of its class?
Correct Answer: A library of container templates approved by the ANSI committee for inclusion in the standard C++ specification A programmer who then launches into a discussion of the generic programming model, iterators, allocators, algorithms, and such, has a higher than average understanding of the new technology that STL brings to C++ programming