Ab initio Online Training

ABINITIO ONLINE TRAINING

Ab Initio means Starts From the Beginning. Ab-Initio application works with the client-server model.

The client is called Graphical Development Surroundings (you can call it GDE). It resides on user desktop.The server or back-end is called Co-Operating Technique . The Co-Operating Technique can reside in a mainframe or unix remote machine.

How Ab-Initio Job Is Run What happens when you push the Run button?
*Your graph is translated in to a script that can be executed in the Shell Development
*This script and any metadata files stored on the GDE client machine are shipped (by FTP) to the server.
*The script is invoked (by REXEC or TELNET) on the server.
*The script creates and runs a job that may run across plenty of hosts.
*Monitoring information is sent back to the GDE client.
Ab-Intio Surroundings The advantage of Ab-Initio code is that it can run in both the serial and multi-file technique surroundings. Serial Surroundings: The normal UNIX file technique. Muti-File Technique: Multi-File Technique (mfs) is meant for parallelism. In an mfs a specific file physically stored across different partition of the machine or even different
machine but pointed by a logical file, which is stored in the co-operating technique. The logical file is the control file which holds the pointer to the physical locations.
About Ab-Initio Graphs: An Ab-Initio graph comprises number of parts to serve different purpose. Information is read or write by a part according to the dml ( do not confuse with the database information manipulating language The most often used.) The Ab-Initio code is called graph, which has got .mp extension. The graph from GDE is necessary to be deployed in corresponding .ksh version. In Co-Operating technique the corresponding .ksh in run to do the necessary job. We provide Abinitio Online Training by Real time IT Expert.

ABINITIO ONLINE TRAINING COURSE CONTENT

Data Warehousing Concepts
• Introduction to Abinitio with excellent faculties
• Ab Initio detailed architecture Salient
• features of Ab Initio Graph, Component, Port, DML
• Introduction to .dat and .dml files
• Various ports available on overall components
• TYPES Partition Components

• Braod Cast
• Partition by Expression
• partition by range
• partition by community
• partition by percentage
• partition by Round Robin

Departition Components

• Concatenate
• Gather
• Interleave
• Merge

Multifile System(MFS)
Types of parallelism
Layouts

• Sort Components
• Sort
• Sort with in groups
• Sample
• Partition by key and sort

Transform Components

• Filter by expression
• Aggregate
• Scan
• Rollup
• Denormalize Sorted
• Normalize
• Reformat
• Match sorted
• Dedup sorted

Working with Databases

• Database components
• Run SQL
• Input Table
• Output Table
• Truncate Table
• Update table

• Phase and check Points

Miscellaneous component

• Gather logs
• Run program
• Redefine format
• Trash
• Replicate

Dataset Components

• Input File
• Output File
• Lookup File
• Intermediate File

FTP Components

• FTP From
• FTP To

Compress Components

• Compress
• Uncompress
• Gzip
• Gunzip

Validate Component

• Check Order
• Generate Records
• Generate Random bytes
• Compare Records
• Compute Check Sum
• Compare Check Sum

Translate components

• Record XML
• Write XML

• Project and Sandbox

• Performance Tuning

We also provide other Data Warehousing Classes like Datastage

Hyperion Essbase Interview Question

Hyperion Financial Management Interview Questions and Answers

   What is Hyperion Financial Management ?

Oracle Hyperion Financial Management is a comprehensive, Web-based application that delivers global financial consolidation, reporting and analysis in a single, highly scalable software solution. Oracle Hyperion Financial Management utilizes today's most advanced technology, yet is built to be owned and maintained by the enterprise's finance team.

  What are the benfits of the Hyperion Financial Management ? 

• BENEFITS
• Accelerate reporting cycles - Reduce closing cycles by days, deliver more timely results to internal and external stakeholders.
• Improve transparency and compliance - Helps reduce the cost of compliance (as stipulated by the Sarbanes-Oxley Act, electronic filing, and other regulatory requirements) and support disclosure requirements, such as sustainability reporting
• Perform strategic analysis - Spend less time on processing and more time on value-added analysis
• Deliver a single truth - Provide a single version of the truth to support financial management and statutory reporting
• Easily integrate - Integrate not only with Hyperion products but also with your existing infrastructure

     Define Hyperion ?

Hyperion is Business Intelligence (BI) and Business Performance Management (BPM ) tool. It is the market leader in Operational , Financial and Strategic Planning. It contains the applications for reporting, Planning , dashboards, Analysis, scorecarding, consolidation, Workspace, Master Data Management and Foundation.

    Explain Olap and mention if it is related to HYPERION FINANCIAL MANAGEMENT ?

• Hyperion HFM/ Hyperion Planning both are Essbase based. They are front-end tech and Ess-base is the back end. Ess-base is a M-OLAP. There are three types of OLAP technology present in the market. These are ROLAP, MOLAP and HOLAP.
• An example of ROLAP is BO. Here we deal with table and they acts as a virtual cube. But if we think about Oracle Express Hyperion Essbase and Cognos then they are real cubes. Thus MOLAP. ROLAP+MOLAP=HOLAP.
• In case of BO, we need to join to attain the OLAP effect virtually but behind is a joined table. But in Case of MOLAP there is no concept of table it is cube only.
• For example a page is a table then a Book is a Cube.
• If the data is large then it is advisable to take up ROLAP not MOLAP. because the performance of the cubes degrade. If the size of data is arround 100 GB to 150 GB then it is fine to go with MOLAP and if it is more then that then we should choose BO.

    Explain why we use Hyperion ?

• We have IIS for HFM although there is no IIS for OLAP's. If there is no IIS then it is a time taking process to retrieve financial data.
• Is it possible to have one ASO database and one BSO database in a single application. Justify .
• No because ASO/BSO classification is defined at Application level and not at the database.

    Can we have multiple databases in single application ?

Yes, in this one database per application.

    Can we start and stop an application individually and how to increase performance using this ?

We can manage our server resources by starting only applications which receive heavy user traffic. When an application is started, memory is accompanied by all associated data bases.

     Explain custom based macro?

We write Ess base calculator functions and special macro functions under Ess base macros. Custom defined macros makes use of an internal Ess base macro language that enables to combine calculation functions and also helpful to operate on multiple input parameters.

     Explain data file cache ? 

Ans. It represents buffer in memory which holds compressed data files (.PAG ).

    What does 'DOU' mean ? 

In reference to RPG, DOU means (Do Until).This will execute a loop matched with an End or End do

For instance
Eval X=1
DOU X=4
Eval X=X=1
EndDo
This example will go through the loop 4 times with the result of X being 4.
'DOU' is similar to Do While('DOW') where the difference lies in that the DOU will always perform 1 pass through the loop and DOW will perform the comparison and only continue into the loop if the condition meets else the program continues after the End (EndDo).
For example
Eval X=1
DOW X=4
X=X+1
Enddo
The result is that the loop will not execute and the value of X will be 1.

    Which property helps us to consider using ACE ?

A very little population of intercompany data forces us to consider using ACE.

    Which two functions can produce a report that includes only Elimination entities ?

Two functions which can produce a report that includes only Elimination entities are a Fixed Name List and Dynamic Name List.

    Explain Dense and Sparse Dimensions ?

Dense dimension is a dimension in which most data exists for every combination of dimension members whereas sparse dimensions are the dimensions which has low probability that data will exist for every combination of dimension members.

     What are the three primary build methods for building dimensions ?

The following are the three primary build methods for building dimensions :-

1) Generation references
2) Level references
3) Parent-Child references.

    Differentiate between ASO & BSO ?

1) We cannot write back in ASO although we can write back in BSO.
2) Most dimensions in ASO are sparse whereas in BSO most of them are dense.
3) We cannot create more than 1 database in ASO but we can create more than 1 db per application. If we have more than 10 dimensions then we should opt for ASO.

   Explain attributes ?

Classification of a member in a dimension is known as an attribute. We can do selection of group members based on their associated attributes. We can also specify an attribute while performing calculations and along with we can use calculation functions. As example, the db in Sample Basic with product dimension has some attributes like package type, size, and flavor. We can add attributes to the dimensions and can retrieve data. For example, to retrieve 'coke with 8 Oz with bottles'.

IBM COGNOS TM1 ONLINE TRAINING

Cognos-TM1 Online Training Highlights

• Fundamental and advanced report building techniques
• Customizing and managing professional reports
• Simplified Cognos TM1 curriculum + Free Material
• Mock tests and assessment
• Real time Interview Questions
• Cognos TM1 Resume Preparation
• Placement Assistance

Download COGNOS TM1 Online Training Course content  Cognos TM1 Online Training with DURATION of 40 HOURS with free REAL TIME Interview questions. We provide you Job Assistance along with resume preparation by senior experts. We conduct classes on weekdays or weekends based on member’s flexibility.Each Cognos TM1 Online Training batch will have only limited slots with 4 to 5 members. You will be having online interactive sessions through Gotomeeting or Skype with your faculty. Cognos TM1 Server access is given to every individual with his/her own log in credentials.

About Trainier

Our trainers are highly experienced and skilled.
All our cognos trainers are employed with top level IT companies.
All our trainers are cognos certified professionals.
Our trainers have 8+ years’ experience in cognos
Many of our cognos online trainers are working on the relevant platform and have 5+ years of real time experience on Oracle and settled as cognos Consultants.
Oracle Online Training techniques of us are specially designed for the global learners and are globally proven.
Our trainers are excellent Online Training experts
Our Trainers aims at quality teaching, which earned them multitudes of learners and also trains in corporate companies.

Top 4 SAP modules of more demand?

Top 4 SAP modules of more demand?

SAP is a system in which businesses use to complete various tasks. SAP systems are divided into modules that help to map the business process for the department or unit within the company. Each module will have letters which represent an area of the business. FI is the coding for Financial Accounting while PS stands for Project Systems and so on. These modules are used to provide applications for different processes within the business and some SAP modules are in more demand than others. Below is an inside look into four different SAP modules that are the most popular among top performing companies. 

SAP FI

This module is otherwise known as SAP Financial Accounting. With this option, organizations business transactions are tracked and monitored. Management and report capabilities are available so businesses can stay abreast of all financial activity. Financials are the life-blood of the business and should be documented properly, which can be done with SAP solutions. The following sub-modules are found within this option:

Accounts Payable

General Ledger

Bank Accounting

Asset Accounting

Accounts Receivable

Funds Management

Special Purpose Ledger

Travel Management

SAP SD

This option is known as SAP Sales and Distribution. With this option, companies can keep track of the master data, system configuration and transactions. Sales Orders, Deliveries, Pricing, Billing, Credit Management and more are followed with this application. 

SAP LE

This application is known as SAP Logistics Execution and covers all aspects of Warehouse Management from inbound receiving to outbound shipping. With this application, stock locations can be viewed as well as quantities of stock. Picking and putaway strategy is also available via this application. 

SAP HR

Human resources are very important within a company and SAP Human Resources works well to provide the software solutions needed for master data, system configuration and transitions of the Hire to Retire process. This application consists of specific components and sub-components.

Personnel Management

·         Personnel Administration

·         Recruitment

·         Personnel Development

·         Compensation management

·         Organization Structure

Organizational Management

Travel management

Payroll

Time management

Each of these modules works well to help with the everyday processes of a business. Keeping track of the master data of the business as well as the regular daily activities is essential to the operation and success of the business. SAP offers a wide variety of modules and with the combination of specific modules customized for companies can help to streamline activity.

Any company using SAP will need to research the options and find the best SAP solution for their business. Consultants are a great resource to determine the right application options for any business.

 

How to choose SAP training institute

How to choose SAP training institute

SAP is a business software company that creates applications for business across the globe. These applications are used to run the daily activities of the business including financials, sales, purchasing, production, analysis and planning. SAP provides training opportunities for individuals who want to learn the skills to run such applications and many institutions provide training in SAP. It can be difficult for students to determine which institute to use when learning SAP. Below is a simple guide on how one can choose a SAP training institute.

The software created by SAP was designed to both improve and manage the information and processes of a business. Training programs will teach students how to use the software to advance their current career or break into a different industry. Training programs provide instruction for different areas of business include data table retrieval, input screen creation, IT warehouse building and more.

SAP training programs take place online, making it easy for students to get started and work on their own time. Many schools offer classroom training that is hands-on so students feel more comfortable working with training teachers or in a group setting.

Students should keep in mind that there are different training options when it comes to SAP. Students will want to enroll in an institution that provides training based on the technical aspects they require for certain goals of employment.

There are three types of SAP Training Programs:

Employer Provided

Professional

Graduate

The employer provided option is SAP system training that an employer provides their employees. This training will give a basic understanding of how a program works. The knowledge is required to run new systems or programs within the business successfully. Training usually takes place online and will be conducted on the employee computer.

Professional training is an option that is conducted by the individual to have a competitive edge in their industry. Professional training is conducted online on the student’s on time to learn additional skills for employment advancement.

The graduate certificate is one that provides an understanding of SAP software with advanced training. This option is for students who have experience in computer or business industries and want to further their education.

When searching for an institute that provides SAP training, keep in the mind the institute must be working with the SAP organization. Look for schools that are highly rated and offer optimal online opportunities with teacher/student aide so you can easily understand and have assistance with the