Posts

Advanced MS Excel

Image
myTectra offers Advanced MS Excel training in Bangalore using Class Room. myTectra offers Live Online Advanced MS Excel Training Globally. Chapter 1: Getting Started Excel Overview Excel Ribbon/Menu Commands Basic Data Manipulations Managing Workbooks & Worksheets Formatting Basics Excel Hierarchy Chapter 2: Functions Logical Functions Arithmetic Functions Date Functions Aggregations Strings Chapter 3: Complex Formulas & Functions Lookup Formulas 1. Vlookup 2. Hlookup 3. Nested Vlookup Advanced referencing functions 1. Index 2. Match 3. Offset & etc Chapter 4: What-if Analysis Goal-Seek command Using Data Tables Scenarios Merge scenarios from another worksheet Chapter 5: Chart & Layouts Creating Charts using chart wizard Useful Graphs & Charts 1. One Axis Graphs 2. Two Axis Graphs & etc Gantt Charts Chapter 6: Pivot Tables Steps to create Pivot Table Arranging fields (Methodol

Apache Kafka Interview Questions and Answers

Image
Q1) .Mention what is Apache Kafka? Ans:  Apache Kafka is a publish-subscribe messaging system developed by Apache written in Scala. It is a distributed, partitioned and replicated log service. Q2). Mention what is the traditional method of message transfer? Ans:  The traditional method of message transfer includes two methods   Queuing: In a queuing, a pool of consumers may read message from the server and each message goes to one of them •   Publish-Subscribe: In this model, messages are broadcasted to all consumers Kafka caters single consumer abstraction that generalized both of the above- the consumer group. Q3). Mention what is the benefits of Apache Kafka over the traditional technique? Ans:  Apache Kafka has following benefits above traditional messaging technique Fast: A single Kafka broker can serve thousands of clients by handling megabytes of reads and writes per second •   Scalable : Data are partitioned and streamlined over a cluster of machines to enable l

Zend Framework Interview Questions and Answers

Image
1.What is a  Framework ? In software development, a framework is a defined support structure in which another software project can be organized and developed. An abstract design  Set of common functionality  Developed for a particular domain   2.How to disable layout from controller? $this->_helper->layout()->disableLayout(); Disable Zend Layout from controller for Ajax call only if($this->getRequest()->isXmlHttpRequest()){ $this->_helper->layout()->disableLayout(); } 3.How to change the View render file from controller? function listAction(){ //call another view file file $this->render(“anotherViewFile”); } 4.How to protect your site from sql injection in zend when using select query? $select = $this->select() from(array(‘u’ => ‘users’), array(‘id’, ‘username’)) where(‘name like ?’,”%php%”) where(‘user_id=?’,’5′) where(‘rating<=?’,10); 5.How to check post method in zend framework? if($this->getRequest()-&g

SAP GRC Interview Questions and Answers

Image
1.What is the use of  SAP GRC? SAP Governance , Risk and Compliance solution enables organization to manage regulations and compliance and remove any risk in managing organizations key operations. As per changing market situation organizations are growing and rapidly changing and inappropriate documents, spreadsheets are not acceptable for external auditors and regulators. 2.What are the different activities that you can perform in SAP GRC? SAP GRC helps organization to manage their regulations and compliance and you can perform following activities Easy integration of GRC activities into existing process and automating key GRC activities. Low complexity and managing risk efficiently. Improve risk management activities. Managing fraud in business processed and audit management effectively. Organizations perform better and companies can protect their values. SAP GRC solution consists of three main areas: Analyze, manage and monitor. 3.What are the different GRC modul