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.