SAP HANA Interview Questions and Answers you must prepare for in 2016

interview

HANA is a revolutionary Relational Database Management System developed by SAP. Its column based search for data retrieval saves memory and results into reporting twice as fast as traditional databases. While SAP HANA Certification has gained tremendous popularity, some of the significant SAP HANA interview questions you should be aware of are –

  1. What are some tasks performed by Modeling Studio?
    • Check database tables and retrieve META DATA
    • Monitoring data transfer from SAPM Business Warehouse to other systems
    • Schedule data replication jobs
    • Utilize data services for modeling
  1. What is Latency?
    The total stretch of time consumed to replicate data from source system to target system is calculated as Latency.
  1. What is Row based and Column based approach?
    The database table is populated in the sequence of rows. Relational databases till now have been following Row based approach. On the contrary, Column based approach has tables being populated in sequence of columns occupying all contiguous memory locations.  HANA supports both but is optimized more for Column approach.
  1. What is SLT? How do you configure it?
    It stands for SAP Landscape Transformation. It triggers replication of data from source to target system where either of the two ends has to be SAP HANA.
    The configuration is performed in the Configuration & Monitoring dashboard using t-code LTR.
  1. What are the prerequisites to configure SLT?
    For SAP source systems – The role IUUC_REPL_REMOTE is assigned to the RFC user
    DMIS add-on has to be installed in the SLT system.For non-SAP systems – DMIS is not essential here. A database user can be authorized to perform replication activities.
  1. What are the different Replication techniques?
    • Trigger based replication using SLT
    • ETL based replication using BODS
    • Extractor data acquisition using DXC
  1. What are Transformation rules?
    These are the rules defined in the Advanced Replication Settings such that the data for the source tables is transformed during replication process.Fill Empty Fields
    Convert Fields
    Skip Records
  1. What factors affect the change in number of jobs?
    Number of Jobs depends upon the following –

    • The number of tables to be replicated
    • Number of configurations managed in SLT system
    • Initial Load speed
    • Expected Replication Latency time
  1. What are the different scenarios in Replication?
    Load – Starts the initial load of replication of data from the source system. It is a one-time process.
    Replicate – Actual phase of replication. Database triggers and different logging tables for every table is created in SLT.
    Stop – Stops any replication currently in process. Database triggers are aborted.
    Suspend – Table replication is paused. Database trigger will not be deleted and changes will be filled in logging tables.
    Resume – Restarts the replication for a suspended table.
  1. What is the maximum table name length and the Max number of columns allowed?
    Max table name length – 127 characters
    Max no of columns – 1000All geared up for a career in SAP HANA? Stay tuned and keep updated with more insights.

For SAP HANA Training needs, Visit http://www.zarantech.com/course-list/sap/SAP-HANA. Call 515-978-9042 or email  kavya@zarantech.com.

How to start preparing for SAP HANA Certification

Ever since its inception 5 years ago, SAP HANA has successfully become the epicenter of all tech talks. Anticipated as the finest technology invention of these times, HANA promises a lucrative stint at business reporting and thus calls for a plethora of opportunities for beginners as well as professional technical consultants.

Preparing for HANA certification can be cumbersome affair if not executed appropriately. Right from initial research to appearing for the exam, it is necessary to cover everything completely.    

12

Know what HANA is

Certification is an expensive affair and plunging at it with no clear objective could delve you into more confusion. It’s better to gain a high level understanding of what HANA is all about. What is so unique about this database approach, its career scope and scalability are some areas you should do your homework. Talk to a reliable SAP HANA course provider or an experienced HANA consultant. You’ll surely earn some valuable feeds.

Plan for prerequisites

Depending entirely upon the course and the certification preparation is a task half-done especially when you have some experience in SAP. Hands on working knowledge of BO, BW and ABAP could be useful. Check within your organization if you can have some opportunity for performing some real time developments upon these.
Beginners can reboot their basic SQL skills with clear focus on Relational databases.

Decide upon your expertise

Earlier a common SAP HANA certification C_HANAIMP_10 was hosted for Associate Consultants. Now, a diversification has 2 different certification exams – C_HANAIMP_1 for Application Consultants and C_HANATEC_1 FOR Technical Consultants. Based on prior experience, SAP Functional Consultants should opt for C_HANAINP_1.

Not just passing the cut-off!

SAP Certification exams usually focus more on in detailed conceptual ability. Mastering theoretical syllabus can help clear the exam but the ultimate objective is to utilize the opportunity with a long term vision. Hunt for an institute that lets you perform a real time full scale implementation project. This will nourish your skills and the overall problem solving ability.

The right institute

SAP HANA is a trending course and institutes of all scales try to capitalize it. Opt for an institute that offers complete training. Compare the syllabus from the SAP training shop and be aware if any gaps exist. Also, e-learning should be a preferred choice and a full scale project is must.  Check for the institute’s website and look for relevant blogs, whitepapers etc that reflect their expertise in the domain.

Appropriate planning and undying hard work can weave a substantial career in HANA. Don’t just join the flock and do your research for an effective plan. Gear up and act wisely, HANA is a promising way.

Stay tuned for more valuable insights.

For SAP HANA Training needs, Visit http://www.zarantech.com/course-list/sap/SAP-HANA. Call 515-978-9042 or email  kavya@zarantech.com.

Attend a Live WEBINAR about Big Data Hadoop Training on May 19, 2016 @8:00 p.m. CST

hadoop

Time : Thursday May 19th , 2016 @ 8:00 pm CST

You are most welcome to join our Upcoming batch, details of the same as follows:

Attend a Live Demo Session : Sign up for Hadoop Webinar
Batch Start Date : May 27, 2016 @ 08:00 p.m. CST
For More Information Big Data Hadoop Course Details
Class Schedule Mon-Wed-Fri 08:00 p.m. CST 3 hrs each session

Contact : Ilyas @ 515-978-9788 , Email : ilyas@zarantech.com

Demo by Trainer Sai

Attend a Free Live WEBINAR about Hadoop Developer Training on 19-May-16 @8:00 PM CST. Register Link  – http://goo.gl/I9Ynoq

Attend a Live WEBINAR about SAP FICO Training on Apr 18, 2016 @7:00 p.m. CST

SAP FICO Training

Time : Wednesday May 18th, 2016 @ 7:00 pm CST

You are most welcome to join our upcoming batch, details of the same are as follows:

Attend a Live Demo Session Sign up for SAP FICO Webinar
Batch Start Date : May 23, 2016 @ 07:00 p.m. CST
For More Information
SAP FICO Course Details
Class Schedule : Mon-Wed-Fri @ 07:00 p.m. CST, 3 hrs each session 

Contact : Kavya @ 515-978-9042, Email : kavya@zarantech.com

Demo Session by Trainer Sumit

Attend a Live WEBINAR about SAP FICO Training on 18-May-16 @7:00 PM CST. Register Link  – http://goo.gl/JOXUjS

Attend a Live WEBINAR about Salesforce Training on Apr 17, 2016 @8:00 p.m. CST

salesforceTime : Tuesday Apr 17, 2016 @ 8:00 p.m. CST

You are most welcome to join our upcoming batch, details of the same are as follows:

Attend a Live Demo Session Sign up for SALESFORCE Webinar
Batch Start Date : Apr 21, 2016 @ 08:00 p.m. CST
For More Information
SALESFORCE Course Details
Class Schedule : Sat-Sun @ 09:30 a.m. CST, 3 hrs each session 

Contact : Richard @ 515-309-7846, Email : richard@zarantech.com

Demo Video by Trainer Priya

Attend a Live WEBINAR about Salesforce Training on April 17, 2016 @8:00 p.m. CST. Register Link  – http://goo.gl/LpvnkU

8 reasons you should learn Tableau

8 reasons you should learn Tableau

Headquartered in Seattle, Washington, Tableau Software was founded in January 2003 by Chris Stolte, Christian Chabot and Pat Hanrahan. Since then, it has come up with various products. Tableau Software is one of the best data visualization and data reporting software. It is a globally trusted business intelligence software and has won many global awards.

Here are the reasons you should learn Tableau:

  1. Easy learning in short amount of time:

Tableau provides thousands of video tutorials and huge knowledge-base which you can easily find at ZaranTech. Apart from this, you can join various Tableau communities, forums, blogs, and social networks and learn built Tableau skills without spending any penny.

  1. Free Tableau Public:

Tableau provides various products like Tableau Desktop, Tableau Server, Tableau Online, Tableau Public etc. Among them, Tableau Public is free of cost. You can download it from its website and ace the software by practicing on your own.

  1. Classifies and stores Big Data:

Tableau makes it easy to operate on Big Data. It gathers, classifies and stores large data sets like no other data visualization tool. You can easily scrutinize your data and modify it within minutes.

  1. Connects to any Data Source:

You can connect Tableau to any database or data warehouse to gather data. You can also input web-based data or data from Microsoft Excel sheet to Tableau for visualization.

  1. Works on any Data:

Tableau treats all types of data equal. So, there’s no need to have different data visualization or data reporting tool for different types of data.

  1. Easy to Use:

Tableau’s user interface is well designed and any newbie can make acceptable visual appearances just in few clicks by using charts, graphs, tables, maps etc.

  1. Growth of an Individual:

Learning Tableau enhances the career growth of an individual. A professional having a complete knowledge of Tableau can appear for Tableau Certification. A professional having a Tableau Certificate can easily be hired by any firm as business analyst, data scientist, visual analyst, or project manager at higher paying salary than any other professional of the same level.

Learning Tableau is like playing with large amount of data, it will definitely enhance your data visualization skills too.

Tableau keeps updating its software to make it faster, easier, and more delightful with new, quick and interactive data visualization products. You can also be updated with that and enhance your skills.

Their latest version, Tableau 10 Beta will be available soon in the market.

  1. Growth of the Organization:

Organizations has to deal with large amount of data and using Tableau makes easy to examine and structure all the data in an appropriate way, analyze it and turn it into useful information. Instead of digging the whole data, this final information makes it easy to find out the reasons for the drawback of the business of an organization.

Attend a Live WEBINAR about Hadoop Admin Training on May 11, 2016 @8:00 p.m. CST

Hadoop Apdmin Training

Time : Wednesday May 11, 2016 @ 8:00 p.m. CST

You are most welcome to join our Upcoming batch, details of the same is as follows:

Attend a Live Demo Session : Sign up for Hadoop Admin Webinar
Batch Start Date : May 18, 2016 @ 08:00 p.m. CST
For More Information http://goo.gl/lBjw99
Class Schedule Mon-Thu 08:00 p.m. CST 3 hrs each session

Contact : Ilyas @ 515-978-9788 , Email : ilyas@zarantech.com

Demo Video by Trainer Ravi

Attend a Free Live WEBINAR about Hadoop Admin Training on May 11, 2016 @8:00 p.m. CST. Register Link  – http://goo.gl/BYufNJ

 

Attend a Live WEBINAR about QA Training on May 12, 2016 @7:30 p.m. CST

Quality Assurance Training

 

 

Time : Thursday May 12, 2016 @ 7:30 p.m. CST

You are most welcome to join our Upcoming batch, details of the same is as follows:

Attend a Live Demo Session : Sign up for QA Webinar
Batch Start Date : May 14, 2016 @ 07:30 p.m. CST
For More Information : http://goo.gl/8457S8
Class Schedule Mon-Thu 07:30 pm CST 3 hrs each session

Contact : Lakshmi @ 515-309-2128, Email : lakshmi@zarantech.com

Demo Video by Trainer Ravi

Attend a Live WEBINAR about QA Training on May 12, 2016 @7:30 p.m. Register Link – http://goo.gl/8457S8

All you wanted to know about SAP HANA S/4 Simple Finance

saps4

Evolving from huge successful R/3 architecture to S/4, SAP all in one business suite that runs on HANA is the new age thing. Capitalizing on Finance Management and critical Accounting needs, SAP S/4 HANA – Simple Finance promises to revolutionize the way enterprises have perceived and analyzed their accounts. Pitching it as the ERP Finance for the digital era, S/4 could be a great bet for forecasting financial turnarounds.

Some key advantages that the system garners include –

  • Real time revenue and costing analysis
  • Accurate comparison of dimensions, simulations and predictions
  • Margin improvisation and optimal cash flow
  • Forecasting liquidity and other significant functions

How to establish a career in Simple Finance?

It has never been a cakewalk to develop a career in SAP. S/4 being a new technology is very demanding in terms of basic skill sets blended with staunch accounting and finance penchant.

If you are planning to give it a shot, do a quick run through over the helpful prerequisites –

  • Excellent working knowledge of RDBMS concepts
  • Finance & Accounting knowledge – basic level
  • Deep programming expertise in Open SQL
  • Knowledge of SAP HANA is a big plus
  • Basic understanding of cloud

Experienced SAP Consultants can benefit from the working expertise they have acquired over the years. However, the ones with Finance background will definitely have an edge over others. Professionals from following background could benefit –

  • SAP FICO
  • SAP BW, Business Object with Finance specialization
  • Senior Chartered Accountants
  • Post graduates in Finance including MBAs

What should be the significant inclusions in the course?

S/4 Simple Finance is an extensive subject and aims at nourishing the candidate skill set across on premise and cloud platforms. This makes it imperative for all candidates to be prepared for the end user expectations across devices.

Besides introduction to SAP HANA and Simple Finance, the syllabus should deeply cover the following areas –

  • SAP Simple Finance On Premise – Configurations and Migration
  • SAP Accounting including General Ledger Accounting, Asset and Management Accounting
  • Cash Flow Management – Probably the most critical part. Includes technical understanding and setup of Bank Account Management and Cash Operations

Selecting the Right Institute

As discussed, S/4 Simple Finance is a new technology and immature institutions will not be able to complement critical designing and problem solving. Thus, only an institute with staunch SAP background can commence the task successfully.

The institute you choose should adhere to the following provisions –

  • Instructors with at least 10 years of experience in SAP Finance
  • Not just classroom teaching – blogs, research papers, case studies, real time project implementation content etc should be regularly delivered
  • Long duration course – Simple Finance can’t be completed in fast track batches. Needs detailed learning
  • E-learning could be a great move if the institute hosts such model.

Before plunging at enrollment, it is wise to execute a thorough run through the dos and don’ts.

For SAP S/4 HANA Training needs, Visit http://www.zarantech.com/sap-s4-hana-simple-finance-training/http://www.zarantech.com/sap-s4-hana-simple-finance-training/. Call 515-978-9042 or email  kavya@zarantech.com.

Attend a Live WEBINAR about Selenium Training on May 05, 2016 @7:30 p.m. CST

Selenium

Wednesday May 05, 2016 @ 7:30 p.m. CST

You are most welcome to join our upcoming batch, details of the same are as follows:

Attend a Live Demo Session Sign up for Selenium Webinar
Batch Start Date : May 09, 2016 @ 07:30 p.m. CST
For More Information
Selenium Course Details
Class Schedule : Mon-Thu @ 07:30 p.m. CST, 3 hrs each session 

Contact : Lakshmi@ 515-309-2128, Email :lakshmi@zarantech.com

Demo Video by Trainer Kaushik

Attend a Live WEBINAR about Selenium Training on May 05, 2016 @7:30 p.m. CST. Register Link  – http://goo.gl/B2prdT