Only with TIBCO Spotfire. Self-service analytics software designed to authorize every individual in your organization with data-driven decisions. TIBCO Spotfire delivers the total set of analytics, unified on a single, centrally-managed platform. Authorize all your users with smart, fast insights. TIBCO Spotfire is a software platform that allows clients to analyze data by statistics.

What is TIBCO Spotfire?

Spotfire’s Enterprise Player, when combined with Core Lab’s RAPID database, allows our clients to perform analytics on the data sets being generated in our Joint Industry Projects. Each active Joint Industry Project has a Spotfire Analytical Template associated with it which allows our clients to investigate the various data sets through tabular and graphical displays. Each display can be filtered by a wide variety of data types stored in our RAPID database such as formation, country, geologic basin, porosity, permeability, geochemistry parameters, etc. Spotfire is extremely easy to use and provides a powerful resource in reservoir evaluation.

What is Spotfire Analytics?

Spotfire Analytics is an enterprise Analytics platform that helps business and technical users quickly to get an actionable insight. This allows customers to perform in-depth analysis of their data through the use of predictive and complex statistics.

What is the use of Spotfire Analytics?

TIBCO Spotfire Analytics provides an incredibly fast and flexible environment for analyzing critical data to help you and your organization make better and smarter decisions. With powerful in-memory analysis, predictive modelling and a highly visual and intuitive interface, Spotfire gives business and technical professionals the ability to rapidly explore their data, helping them find key insights to give them a unique competitive edge.

Spotfire Analytics is a single platform that spans the spectrum from rapid ad-hoc analysis to building custom analytic applications, from analyzing spreadsheet and database data to real-time and event-driven data, and from desktop-based data exploration to widely distributed web-based interactive dashboards. Incorporating powerful statistics, Spotfire is the most powerful analytic platform in the world, giving individuals and organizations an immediate information advantage over their competitors.

What are Spotfire Shared Folders?

Spotfire Cloud allows you to share what you discover instantly. In order to share Spotfire analysis files, you must save the file to a folder in your library. Personal users create folders in their online library; Work Group users can create folders in both their online or desktop libraries. Folders can be public, shared (by you or with you. or private depending on your subscription type.

What are the features of Spotfire?

. Analyze and explore data with intuitive, interactive visualizations
. Bar charts, scatter plots, treemaps, box plots, map charts etc.
. In-Memory data architecture provides incredible speed and flexibility
. Direct access to corporate and local data sources, including spreadsheets
. SAP BW, SAP R/, Oracle E-Business Suite, Salesforce.com, any ODBC database etc.
. Excel, csv, any flat data file
. Create and distribute analytic applications for the Web
. Zero Footprint Client; no coding required
. Easily creates sophisticated statistical analysis
. Tight integration between S+ statistical package and Spotfire
. Analyze event-driven and real-time data
. Tight integration with TIBCO infrastructure products

Which version of Spotfire you are working on?

Say only the one you worked, because the next question will be the difference you find in both, Interview questions and Answers

What are the various visualization used in the Spotfire?

You can tell the one you are able to recollect. If possible tell them the importance and the use of one or two.

Is there any difference between the terms Data on Demand & Details on Demand?

Data on Demand is one of method we used to adding data and Details on Demand is the way of displaying the detailed view of data.

Is TIBCO Spotfire a Core Lab product?

The Spotfire Enterprise Player is a product of TIBCO, which Core Lab licenses for use in conjunction with our Joint Industry Projects. The Analytical Templates themselves are a product of Core Laboratories. In order to facilitate the transfer of data from our RAPID database to our Spotfire Analytical Templates, Core Lab developed RAPIDLink which automatically delivers all data to which a client is entitled.

Explain what is S Programming Language?

The award-winning S programming language is at the core of both TIBCO Spotfire S+ and R. The only language created specifically for exploratory data analysis and statistical modeling, the S programming language allows you to create statistical applications up to five times faster than with other languages.

Object-oriented, interpreted GL language.

Interactive exploration and fast prototyping.

Rich data structures: vector, matrix, array, data frame, list and many more.

User-defined functions, objects, classes, methods and libraries.

While debugging TIBCO BW processes, which activity can be used to write complete schema information to a file?

TIBCO provides Inspector activity which can be used for debugging purposes while developing applications in TIBCO designer. Inspector activity can be used to write all output information of designer activities to a local file including process variables and other details.

Describe the main features of TIBCO Spotfire .?

Faster, Easier Use of Data

Create Spotfire applications that interact directly with complex big data sources while hiding the complexity from end users

Access huge volumes of information quickly and easily

Create complex applications faster and leverage existing database skill sets

Richer Location Analytics:

Visualize sophisticated location source data directly in Spotfire

Get access to existing Esri and WMS data sources for richer data visualization

Bring GIS and data analysis strategies together seamlessly Spotfire Desktop

The most complete desktop analytics authoring for Excel users, business analysts, R- knowledgeable analysts, and data scientists

Full Spotfire desktop authoring for a single user

Connect to the wide array of Spotfire direct connect data sources

Explain what are Spotfire Shared Folders?

Spotfire Cloud allows you to share Explain what you discover instantly. In order to share Spotfire analysis files, you must save the file to a folder in your library. Personal users create folders in their online library; Work Group users can create folders in both their online or desktop libraries. Folders can be public, shared (by you or with you. or private depending on your subscription type.

Explain what is TIBCO Certified Messaging?

TIBCO certified messaging is an approach to guarantee delivery of every message from sender to its intended recipient. TIBCO certified messaging works on the principle of registration and acknowledgement.

What is the role of TRA (Tibco Runtime Agent.?

There are two main functions of TRA:

TIBCO Runtime Agent (TRA. is responsible for starting and stopping of processes running on a machine.

TRA provides runtime environment for TIBCO applications.

TRA runs on every TIBCO machine in the background.

What type of resources in TIBCO EAR file?

Following type of resources are typically added in EAR file in TIBCO:

Local Project Resources (Processes, Schemas, Connections, Services, Variables etc.

Library Builder Resources Files.

Files referred in designer CLASSPATH

Files under Designer Installation directory

Can we have backward transitions in TIBCO BW Processes?

In TIBCO Designer Processes, transitions between activities are always uni-directional. This means that we can’t go back to a previous transition from any point.

What are different Panels of TIBCO designer window and what is the purpose of each?

There are following four types of panels available in TIBCO designer window:

Project Panel: This panel shows project hierarchy.

Design Panel: This panel is used to design new BW Processes in TIBCO.

Palette Panel: This Panel has all the available Palettes with bundled activities which can be dragged and used in design panel during process development.

Configuration Panel: Configurations including input, output details for any activity are specified in the configuration panel.

What is difference between fault tolerant and load balanced deployment in TIBCO?

Load balancing:
Load balancing is done between two or more servers where the load is distributed between servers to avoid any server crashes due to heavy load on a single server.

Fault tolerance:
Fault tolerance is achieved between two servers where one server acts as a primary and the second server acts as a secondary/backup server for the primary server. Whenever failure occurs for primary server, the backup secondary server becomes the primary server.

What are the options for configuring storage for process engine’s checkpoint repository?

The options for configuring storage for process engine’s checkpoint repository are:

Local File: Information is stored in a local file which in case of engine crash/failure and same information is used to resume the process flow once engine is up. This mechanism works only in case of single server or load balancing approach.

Database: Information is stored in a database table which is used to resume engine later. Fault tolerant engines can recover from a checkpoint only when database is used.

What are the modes of TIBCO BW Installations?

GUI mode
Console mode
Silent mode

What is the role of TRA?

TRA stands for TIBCO Runtime Agent.
The TRA has two main functions:

Supplies an agent that is running in the background on each machine.
The agent is responsible for starting and stopping processes that run on a machine according to the deployment information.
The agent monitors the machine. That information is then visible via TIBCO Administrator.
Supplies the run-time environment, that is, all shared libraries including third-party libraries.

What are the resources that gets included in the EAR file, created by the TIBCO Designer?

EAR file can contain local project resources, LibraryBuilder resources, and files as specified in AliasLibrary resources. In addition, the TIBCO Designer classpath may include references to other files that are included in the EAR file.

What are the revision control system options available in TIBCO designer?

File sharing
VSS
Perforce
XML Canon
ClearCase
iPlanet
CVS
PVCS

What are the TIBCO BW activities that can participate in transactions?

Not all TIBCO BusinessWorks activities can participate in a transaction. Only the following types of activities have transactional capabilities:

JDBC activities
JMS activities
ActiveEnterprise Adapter activities that use JMS transports
EJB activities
TIBCO iProcess BusinessWorks Connector activities

What are the different types of Transactions TIBCO provides?

TIBCO BusinessWorks offers a variety of types of transactions that can be used in different situations. You can use the type of transaction that suits the needs of your integration project. When you create a transaction group, you must specify the type of transaction. TIBCO BusinessWorks supports the following types of transactions:

JDBC
Java Transaction API (JTA. UserTransaction
XA Transaction

What is the purpose of the inspector activity ?

The Inspector activity is used to write the output of any or all activities and process variables to a file and/or stdout. This is particularly useful when debugging process definitions and you wish to see the entire schema instead of mapping specific elements to the Write File activity.

What are maximum/minimum of threads available for incoming HTTP ?

The maximum/minimum of threads available for incoming HTTP : /

How can unauthorized users be prevented from triggering process ?

Unauthorized users be prevented from triggering a process by giving ‘write’ access for the process engine to only selected users. Only users with ‘write’ access can do activities like deploying applications, starting/stopping process engines etc.

How to use legacy .dat file format with latest designer?

Convert .dat file to multi file project using Administration tab while starting up Designer(Other one being Project tab. and then open the multifile project in the normal way.

What are the encodings supported by designer?

Ans. Encodings supported by designer are

ISO-(Latin-.
UTF-

How do you determine if there are broken references in the project?

Project -> Validate for deployment

What are the options for configuring storage for process engine’s checkpoint repository?

The options for configuring storage for process engine’s checkpoint repository are:
Local File
Database. Fault tolerant engines can recover from a checkpoint only when database is used.

Process engines in a fault tolerant group can be configured as peers or master secondary. How do these differ ?

The options for configuring storage for process engine’s checkpoint repository are:

Peer means all of them have the same weight. In this case when one engine fails another one takes over and continues processing till it fails.
In master secondary configuration weights are unequal, the secondary starts processing when master fails. But when master recovers, secondary stops and master continues processing.

What are the uses of grouping activities?

Uses of grouping activities are:
Create a set of activities having a common error transition.
Repeat group of activities based on a condition.
Iterate over a list.
Repeat until condition true.
Repeat on Error until condition true.
Group activities into a transaction.
To create a critical section area that synchronizes process instances.
A ‘Pick First Group’ allows you to wait for the occurrence of multiple events and proceed along a path following the first event to occur.

Can there be two error transitions out of an activity?

No. There can be only one Error and one Success if no matching condition transition out of each activity.

When is a ‘No Action’ group used?

‘No Action’ group used to have a set of activities having a common error transition

What activity can be used to set the value of a ‘User defined process variable’ ?

The ‘Assign’ activity can be used to set the value of a ‘User defined process variable’.

Which are the two process variables available to all activities with inputs ?

$_globalVariables
$_processContext

Which activity is used for detecting duplicate message processing?

CheckPoint activity – Specify the uniueID for the duplicate key field and engine maintains list of these key fields. When a process come to checkpoint activity with the same value for duplicate key which already exists, it throws a DuplicateException. An error transition can then handle this case.

Give an example where graceful migration of service from one machine to another is not possible.

HTTP Receiver. In this case the receiver on new machine starts listening on the same port, but you need to redirect reuests from the old machine to the new one.

What are the types of adapter services ?

Types of adapter services are :
Subscriber Service
Publisher Service
Reuest-Response Service
Reuest-Response Invocation Service

What are the output formats for XSLT?

XML
HTML
Text

What does ‘ Success if no matching condition’ transition mean ?

Lets say between two nodes N and N, there are success transitions with condition and there is no success transition without condition. If none of the conditions match then a ‘Success if no matching condition’ transition can be used. Also if there is a success transition and also success transitions with condition and if the condition matches then both the success transition (no condition. as well as the transition (s. with matching conditions are followed. So you can use ‘Success if no matching condition’ to prevent duplicate paths of execution.

What is the Purpose of $_error variable ?

$_error variable is available in the node following the error transition. It captures the error message, error code etc.

What are the cases where business process cant proceed correctly subsequent to restart from a checkpoint ?

Sending HTTP response, confirming an email/jms message etc. This is because the confirmation or sending HTTP response has to done in the same session. When engine crashes these sessions are closed at their socket level. In such cases send response/confirm before checkpoint.

Which group do you use to wait for multiple events and proceed with the first to occur ?

A ‘Pick First Group’.

Explain what is TIBCO Spotfire?

Spotfire Enterprise Player, when combined with Core Lab’s RAPID database, allows our clients to perform analytics on the data sets being generated in our Joint Industry Projects. Each active Joint Industry Project has a Spotfire Analytical Template associated with it which allows our clients to investigate the various data sets through tabular and graphical displays. Each display can be filtered by a wide variety of data types stored in our RAPID database such as formation, country, geologic basin, porosity, permeability, geochemistry parameters, etc. Spotfire is extremely easy to use and provides a powerful resource in reservoir evaluation.

Explain what are the features of Spotfire?

Analyze and explore data with intuitive, interactive visualizations

Bar charts, scatter plots, treemaps, box plots, map charts etc.

In-Memory data architecture provides incredible speed and flexibility

Direct access to corporate and local data sources, including spreadsheets

SAP BW, SAP R/, Oracle E-Business Suite, Salesforce.com, any ODBC database etc.

Excel, csv, any flat data file

Create and distribute analytic applications for the Web

Zero Footprint Client; no coding required

Easily creates sophisticated statistical analysis

Tight integration between S+ statistical package and Spotfire

Analyze event-driven and real-time data

Tight integration with TIBCO infrastructure products

While debugging TIBCO BW processes, which activity can be used to write complete schema information to a file?

Describe the main features of TIBCO Spotfire .?

Faster, Easier Use of Data

Create Spotfire applications that interact directly with complex big data sources while hiding the complexity from end users

Access huge volumes of information quickly and easily

Create complex applications faster and leverage existing database skill sets

Richer Location Analytics:

Visualize sophisticated location source data directly in Spotfire

Get access to existing Esri and WMS data sources for richer data visualization

Bring GIS and data analysis strategies together seamlessly Spotfire Desktop

The most complete desktop analytics authoring for Excel users, business analysts, R- knowledgeable analysts, and data scientists

Full Spotfire desktop authoring for a single user

Connect to the wide array of Spotfire direct connect data sources

What is vcrepo.dat and when this file is created in TIBCO?

Vcrepo.dat file is used to store certain properties like TIBCO RV encoding, display name; description etc. vcrepo.dat file gets created automatically when a TIBCO BW project is saved for the first time. This file can be used for identification purposes.

How Restful web services can be developed in TIBCO?

TIBCO provides a Plugin for REST and JSON which can be used to develop Restful web services in TIBCO designer.

Can we have backward transitions in TIBCO BW Processes?

In TIBCO Designer Processes, transitions between activities are always uni-directional. This means that we can’t go back to a previous transition from any point.

What are different Panels of TIBCO designer window and what is the purpose of each?

There are following four types of panels available in TIBCO designer window:

Project Panel: This panel shows project hierarchy.

Design Panel: This panel is used to design new BW Processes in TIBCO.

Palette Panel: This Panel has all the available Palettes with bundled activities which can be dragged and used in design panel during process development.

Configuration Panel: Configurations including input, output details for any activity are specified in the configuration panel.

What are the options for configuring storage for process engine’s checkpoint repository?

The options for configuring storage for process engine’s checkpoint repository are:

Local File: Information is stored in a local file which in case of engine crash/failure and the same information is used to resume the process flow once the engine is up. This mechanism works only in case of a single server or load balancing approach.

Database: Information is stored in a database table which is used to resume the engine later. Fault-tolerant engines can recover from a checkpoint only when the database is used.

Have you ever created dashboard using procedures with input parameter? If your answer is yes, definitely the next question will be how?

You can create the procedures through IL, instead of table columns create procedures. While creating the procedures there is one option to select the query type. If it is with input parameters change that to post – query, write default values and save. Create IL using the procedure, and refresh the parameters to get the values.

What is the caption of TIBCO?

The information Bus Company’. Since it transfers the messages in the form of a bus from one end to the other.

What are the three levels of validations that can be performed in TIBCO designer?

Following are the three levels of
validations supported by TIBCO BW:
Activity level validation
Process level validation
Project level validation

Are you able to edit the marking, the name, and color?

Yes, from the Document Property, we can change the marking properties based on your requirement.

Is there any difference between the terms Data on Demand & Details on Demand?

Data on Demand is one of the methods we used to add data and Details on Demand is the way of displaying the detailed view of data.

Tell me the way you created the dashboard using IL (information link..

First create the data source, then take the columns you wanted for the dashboard and save in a folder in the library. If using multiple tables, create the joins. Finally, create the IL. Add data from the library to access the IL to the front end.

What are the transactions in Tibco?

In Tibco, every transaction is a business-related message. We have JNDI, XA transactions available in Tibco.

What are the resources that get included in the EAR file, created by the TIBCO Designer?

An EAR file can contain local project resources, Library Builder resources, and files as specified in Alias Library resources. In addition, the TIBCO Designer classpath may include references to other files that are included in the EAR file.

What are the different types of Transactions TIBCO provides?

TIBCO BusinessWorks supports the following types of transactions:

JDBC

Java Transaction API (JTA. UserTransaction

XA Transaction

Is it possible to create a drop-down filter?

Yes, using the text area you can create a drop-down filter.

What is prefetch and failsafe?

Prefetch is fetching the messages from the server before receiver calls. Failsafe property enables to write persistence messages to the file with synchronous i/o calls.

What is the difference between SL direct and other JDBC activities?

Other JDBC activities can only do a specific DML operation (insert, update, modify., whereas sl direct can execute all the DML operations including table creation and deletion too.SL direct is mainly used for dynamic DB operations.

What Is the Difference Between Concrete Wsdl And Abstract Wsdl?

The Abstract WSDL describes the interface of the web service which includes the format of request and response messages of each operation.

The Concrete WSDL describes the abstract WSDL plus transport information. Concrete WSDL contains messages, operations and transport specific information (JMS or Http., which is used by SOAP client.

What is the use of spawn option in the called process?

If the spawn is checked, then that process will be executed externally with the main process. And we are not supported to make this spawn when we are using job shared variables.

What Is the Use of Critical Section Group?

Critical section groups are used to synchronize process instances so that only one process instance executes the grouped activities at any given time.

What are TIBCO Ledger files and why they are important?

TIBCO Ledger files are used to store messages in case of RV certified messaging. Ledger files are important as they ensure delivery of each and every message to the intended recipient in a certified RV communication model in TIBCO.

Explain what is Spotfire Cloud?

A : Spotfire Cloud is the leading data visualization and cloud-based business analytics software available today. Spotfire enables users to create beautiful, interactive visualizations from their laptop or tablet. While traditional business intelligence tools force the user to know Explain what question to ask first, Spotfire allows users to explore trends, outliers and previously undiscovered insights in their data.

Is TIBCO Spotfire a Core Lab product?

A : The Spotfire Enterprise Player is a product of TIBCO, which Core Lab licenses for use in conjunction with our Joint Industry Projects. The Analytical Templates themselves are a product of Core Laboratories. In order to facilitate the transfer of data from our RAPID database to our Spotfire Analytical Templates, Core Lab developed RAPIDLink which automatically delivers all data to which a client is entitled

Explain what is S Programming Language?

A : The award-winning S programming language is at the core of both TIBCO Spotfire S+ and R. The only language created specifically for exploratory data analysis and statistical modeling, the S programming language allows you to create statistical applications up to five times faster than with other languages.
Object-oriented, interpreted GL language.
Interactive exploration and fast prototyping.
Rich data structures: vector, matrix, array, data frame, list and many more.
User-defined functions, objects, classes, methods, and libraries.
Library of over functions for data manipulation, graphics, statistical modeling, and integration.
CSAN library of available packages.

Explain what are Spotfire Shared Folders?

A : Spotfire Cloud allows you to share Explain what you discover instantly. In order to share Spotfire analysis files, you must save the file to a folder in your library. Personal users create folders in their online library; Work Group users can create folders in both their online or desktop libraries. Folders can be public, shared (by you or with you. or private depending on your subscription type.

How Restful web services can be developed in TIBCO?

A : TIBCO provides a Plugin for REST and JSON which can be used to develop Restful web services in TIBCO designer.

Explain what is TIBCO Certified Messaging?

A : TIBCO certified messaging is an approach to guarantee delivery of every message from sender to its intended recipient. TIBCO certified messaging works on the principle of registration and acknowledgment.

What is vcrepo.dat and when this file is created in TIBCO?

A : Vcrepo.dat file is used to store certain properties like TIBCO RV encoding, display name; description etc. vcrepo.dat file gets created automatically when a TIBCO BW project is saved for the first time. This file can be used for identification purposes.

Is there any difference between the terms Data on Demand & Details on Demand?

Data on Demand is one of method we used to adding data and Details on Demand is the way of displaying the detailed view of data.

Have you heard about personalized information link?

Yes, using this method we can filter the users to view the dashboard. parameters are used for this. CURRENT_USERS AND GROUP_USERS, from version onwards there is one more named CURRENT_USER_DOMAIN

Have you ever created dashboard using procedures with input parameter? If your answer is yes, definitely the next question will be how?

Is it possible to create drop down filter?

Yes, using the text area you can create drop down filter.

What type of resources in TIBCO EAR file?

Following type of resources are typically added in EAR file in TIBCO:

Local Project Resources (Processes, Schemas, Connections, Services, Variables etc.

Library Builder Resources Files.

Files referred in designer CLASSPATH

Files under Designer Installation directory

How Restful web services can be developed in TIBCO?

TIBCO provides a Plugin for REST and JSON which can be used to develop Restful web services in TIBCO designer.

Can we have backward transitions in TIBCO BW Processes?

In TIBCO Designer Processes, transitions between activities are always uni-directional. This means that we can’t go back to a previous transition from any point.

What are the three levels of validations that can be performed in TIBCO designer?

Following are the three levels of validations supported by TIBCO BW:

-Activity level validation

-Process level validation

-Project level validation

What is the difference between sldirect and other jdbc activities?

Other jdbc activities can only do a specific DML operation (insert, update, modify., whereas sl direct can executes all the DML operations including table creation and deletion too.SL direct is mainly used for dynamic db operations.

Is it possible to create drop down filter?

Yes, using the text area you can create drop down filter.

What are the different types of Transactions TIBCO provides?

TIBCO BusinessWorks supports the following types of transactions:

JDBC
Java Transaction API (JTA. UserTransaction
XA Transaction

What are the main panels of the Designer window?

The main panels of the Designer window are

Project panel
Palette panel
Design panel
Configuration panel

Is TIBCO Spotfire a Core Lab product?

What is S Programming Language?

. Object-oriented, interpreted GL language.
. Interactive exploration and fast prototyping.
. Rich data structures: vector, matrix, array, data frame, list and many more.
. User-defined functions, objects, classes, methods and libraries.
. Library of over functions for data manipulation, graphics, statistical modeling, and integration.
. CSAN library of available packages.

If I want to see the outlier which visualization I need to use?

Scatter plot.

Are you able to edit the marking, the name and color?

Yes, from the Document Property, we can change the marking properties based on your requirement.

Can we use different filters in different pages?

We can use filtering schema to apply different filter.

Describe the main features of TIBCO Spotfire .?

. Faster, Easier Use of Data
. Create Spotfire applications that interact directly with complex big data sources while hiding the complexity from end users
. Access huge volumes of information quickly and easily
. Create complex applications faster and leverage existing database skill sets
. Richer Location Analytics
. Visualize sophisticated location source data directly in Spotfire
. Get access to existing Esri and WMS data sources for richer data visualization
. Bring GIS and data analysis strategies together seamlessly New Spotfire Desktop
. The most complete desktop analytics authoring for Excel users, business analysts, R- knowledgeable analysts, and data scientists
. Full Spotfire desktop authoring for a single user
. Connect to the wide array of Spotfire direct connect data sources

What is Spotfire Cloud?

Spotfire Cloud is the leading data visualization and cloud-based business analytics software available today. Spotfire enables users to create beautiful, interactive visualizations from their laptop or tablet. While traditional business intelligence tools force the user to know what question to ask first, Spotfire allows users to explore trends, outliers and previously undiscovered insights in their data.

What is TIBCO Certified Messaging?

The way dashboard using IL (information link..

First create the data source, then take the columns you wanted for dashboard and save in a folder in the library. If using multiple tables, create the joins. Finally create the IL. Add data from library to access the IL to the front end.

Have you heard about personalized information link?

Yes, using this method we can filter the users to view the dashboard. parameters are used for this. CURRENT_USERS AND GROUP_USERS, from version onwards there is one more named CURRENT_USER_DOMAIN

Have you ever created dashboard using procedures with input parameter? If your answer is yes, definitely the next question will be how?

Is it possible to create drop down filter?

Yes, using the text area you can create drop down filter.

Explain what is TIBCO Spotfire?

Explain what is Spotfire Analytics?

Explain what is the use of Spotfire Analytics?

Explain what are the features of Spotfire?

Analyze and explore data with intuitive, interactive visualizations

Bar charts, scatter plots, treemaps, box plots, map charts etc.

In-Memory data architecture provides incredible speed and flexibility

Direct access to corporate and local data sources, including spreadsheets

SAP BW, SAP R/, Oracle E-Business Suite, Salesforce.com, any ODBC database etc.

Excel, csv, any flat data file

Create and distribute analytic applications for the Web

Zero Footprint Client; no coding required

Easily creates sophisticated statistical analysis

Tight integration between S+ statistical package and Spotfire

Analyze event-driven and real-time data

Tight integration with TIBCO infrastructure products

Explain what is Spotfire Cloud?

Spotfire Cloud is the leading data visualization and cloud-based business analytics software available today. Spotfire enables users to create beautiful, interactive visualizations from their laptop or tablet. While traditional business intelligence tools force the user to know Explain what question to ask first, Spotfire allows users to explore trends, outliers and previously undiscovered insights in their data.

What is vcrepo.dat and when this file is created in TIBCO?

How Restful web services can be developed in TIBCO?

TIBCO provides a Plugin for REST and JSON which can be used to develop Restful web services in TIBCO designer.

What are the three levels of validations that can be performed in TIBCO designer?

Following are the three levels of validations supported by TIBCO BW:

-Activity level validation

-Process level validation

-Project level validation

If you have installed a particular version of TIBCO software e.g. TIBCO BW X.Y.Z, What are X, Y and Z number stands for?

Integration can be at different application layers:

X:Patch
Y:Major
Z:Minor

What are the different modes of service invocation?

Services can be invoked in several ways.

A one-way operation is executed once and does not wait for a response.
A request-response operation is executed once and waits for one response. In a request-response service, communication flows in both directions. The complete interaction consists of two point-to-point messages—a request and a response. The interaction is only considered complete after the response has arrived.
Publication (notification. means an operation sends information on an as-needed basis, potentially multiple times.
Subscription means incoming information is processed on an as-needed basis, potentially multiple times.

What is vcrepo.dat?

TIBCO Designer creates a file named vcrepo.dat in the project root directory when you first save the project. This file is used to store properties such as display name, TIBCO Rendezvous encoding, and description. This file can be used for identification in place of the project root directory and can be used as the repository locator string (repoUrl..

What activities are supported in JTA Transaction?

The Java Transaction API (JTA. UserTransaction type allows:
JDBC
JMS
ActiveEnterprise Adapter (using JMS transports.
EJB activities
to participate in transactions.

What activities are supported in XA Transaction ?

The XA Transaction type allows:

JDBC activities
ActiveEnterprise Adapter activities that use the JMS transport
JMS activities
to participate in transactions.
Note:For JMS activities and ActiveEnterprise Adapter activities, request/reply operations cannot participate in an XA transaction. Also, EJB activities cannot participate in an XA Transaction group.

What are the possible Error output’s of Read File activity?

Integration can be at different application layers:

FileNotFoundException :Thrown when yhe file does not exist.
UnsupportedEncodingException:Thrown when the text file’s encoding is not valid and the content of the file is read into process data.
FileIOException :Thrown when an I/O exception occurred when trying to read the file.

What are the mandatory configuration parameters for FTP Connection & FTP with firewall?

The mandatory configuration parameters for FTP Connection

FTP host
Port
Username & Password>

If Firewall is enabled in addition the proxy host and port are required.

How to design a process such that depending on number of records updated in a database, different sub-processes may be called?

Define transitions from JDBC update with condition on the no of updates and call appropriate child processes.

Where are the Designer preferences stored?

Designer preferences stored are stores in a file called ‘Designer .prefs’ in the user home directory.

Explain the process configuration parameters – Max Jobs, Flow Limit & Activation Limit?

Max Jobs :
Max Jobs specifies the number of process instances that are kept in memory. Once this limit is reached newly created process instances (subject to flow limit. are paged out to disk. specifies no limit and is the default.

Flow Limit :
Flow Limit specifies the maximum number of running process instances that are spawned before the process starter is suspended i.e. it enters a FLOW_CONTROLLED state and does not accept new events. This can be used to control the number of process instances running simultaneously and when the protocol generating the event can store the event till it is received, like email servers, JMS, RV etc. specifies no limit and is the default.

Activation Limit :
Activation limit flag specifies that once a process instance is loaded it must be placed in memory till it completes execution. By default it is enabled.

What is the purpose of a Lock shared configuration resource?

A Lock is specified for a ‘Critical Section’ group when the scope is ‘Multiple’. It can be used to ensure synchronization across process instances belonging to multiple processs definitions or for process instances across engines(Check multi engine flag for lock in this case and the BW engine needs to be configured with database persistence while deployment.. If synchronization is for process instances belonging to the same processs definition inside one engine, just specify the scope as ‘Single’.

How to control the sequence of execution of process instances created by a process starter?

Use the sequencing key field in the Misc tab of any process starter. Process instances with the same value for this field are executed in the sequence in which they are started.

Which mechanism can be used to pass data between a process instance and a called sub process other than mapping from/to the callee’s input/output ?

This can be accomplished using job shared variables, unless in the call process activity the ‘Spawn’ flag is enabled in which case the called sub process is a new job and hence gets a fresh copy of the job shared variable initialized as per its configuration. A shared variable can overcome this limitation as it’s scope is not limited to one job.

What are the three scenarios where BW engine has to be configured with database persistence instead of Local File ?

The three scenarios are:

Shared Variables across BW engines.
Locking across groups in multiple BW engines.
Wait Notify across BW engines.

If you want a group to be executed if there is some unhandled error but subject to some max number of iterations which group do you use ?

We can use Repeat on Error until true

When is a ‘Generate Error’ activity useful?

When you handle an error inside a called subprocess or group and want to rethrow the error to the caller(happens by default if you don’t handle the error in the called process.

If the business process needs to invoke another web service which resource do you use ?

SOAP request reply activity. If the business process needs to be exposed as SOAP service use SOAP Event Source in conjunction with SOAP Send Reply or SOAP Send Fault.

What is the functionality of the Retrieve Resources resource?

It can be used to serve the wsdl file of a SOAP Event Source to a (http. client.
Construct a process like: HTTP Receiver -> Retrieve Resources -> Send HTTP Response

Now the WSDL file for a SOAP service can be retrieved using the http request

where ‘path’ is the folder path to the SOAP Event Source process and ‘resourceName’ is the name of the process

What is the scope of user defined process variables ?

The scope of user defined process variables is only the process in which it is defined.(Not even inside a sub process that is invoked from this process.

What is difference between shared variable and job shared variable ?

Both of them can be manipulated via the palette resources ‘Get shared variable’ and ‘Set shared variable’.
A job shared variable is private to one instance of job or in other words each job has a fresh copy. In the case of shared variable the same copy is shared across all job instances. It can even be persisted and can survive BW engine restarts and even shared across multiple BW engines(when deployed using DB persistence..

How do wait-notify resources work ?

Basically wait and notify should share a common notification configuration which is just a schema definition for data that will be passed from notifier to waiter. Specific instances of waiter & notifier are correlated via a key.

For example: when one process is in wait state for key ‘Order-’, it waits till another process issues a notification with the same key value.

What is the default Axis in XPath ?

Child axis- What this means is that when you select “BOOK” from the current context, it selects a child node with that name, not a sibling with that name. Other axes are parent , self , sibling etc.

Is TIBCO Spotfire a Core Lab product?

Explain what is S Programming Language?

Object-oriented, interpreted GL language.

Interactive exploration and fast prototyping.

Rich data structures: vector, matrix, array, data frame, list and many more.

User-defined functions, objects, classes, methods and libraries.

Library of over functions for data manipulation, graphics, statistical modeling, and integration.

CSAN library of available packages.

Explain what is Spotfire Analytics?

Spotfire Analytics is an enterprise Analytics platform that helps business and technical users quickly to get an actionable insight.This allows customers to perform in-depth analysis of their data through the use of predictive and complex statistics.

Explain what is the use of Spotfire Analytics?

Explain what is Spotfire Cloud?

Explain what are Spotfire Shared Folders?

Explain what is TIBCO Certified Messaging?

What is the role of TRA (Tibco Runtime Agent.?

There are two main functions of TRA:

TIBCO Runtime Agent (TRA. is responsible for starting and stopping of processes running on a machine.

TRA provides runtime environment for TIBCO applications.

TRA runs on every TIBCO machine in the background.

What type of resources in TIBCO EAR file?

Following type of resources are typically added in EAR file in TIBCO:

Local Project Resources (Processes, Schemas, Connections, Services, Variables etc.

Library Builder Resources Files.

Files referred in designer CLASSPATH

Files under Designer Installation directory

What is difference between fault tolerant and Load balanced deployment in TIBCO?

Load balancing:

Load balancing is done between two or more servers where the load is distributed between servers to avoid any server crashes due to heavy load on a single server.

Fault tolerance:

Fault tolerance is achieved between two servers where one server acts as a primary and the second server acts as a secondary/backup server for the primary server. Whenever failure occurs for primary server, the backup secondary server becomes the primary server.

What are the options for configuring storage for process engine’s checkpoint repository?

The options for configuring storage for process engine’s checkpoint repository are:

Database: Information is stored in a database table which is used to resume engine later. Fault tolerant engines can recover from a checkpoint only when database is used.

Have you heard about personalized information link?

Yes, using this method we can filter the users to view the dashboard. parameters are used for this. CURRENT_USERS AND GROUP_USERS, from version onwards there is one more named CURRENT_USER_DOMAIN.

What is the difference between fault-tolerant and Load balanced deployment in TIBCO?

Load balancing: Load balancing is done between two or more servers where the load is distributed between servers to avoid any server crashes due to heavy load on a single server.

Fault tolerance:

Fault tolerance is achieved between two servers where one server acts as a primary and the second server acts as a secondary/backup server for the primary server. Whenever a failure occurs for the primary server, the backup secondary server becomes the primary server.

Can we use different filters on different pages?

We can use filtering schema to apply different filter.

The way dashboard using IL (information link.?

First, create the data source, then take the columns you wanted for the dashboard and save in a folder in the library. If using multiple tables, create the joins. Finally, create the IL. Add data from the library to access the IL to the front end.

What is the difference between in-memory ledger and file ledger in TIBCO?

Programs that require certification only for the duration of the program process can choose a process-based ledger. Once the process terminates the ledger file is no longer available. Programs that require certification that transcends process termination and program restart can choose a file-based ledger. Therefore, a file-based ledger preserves certified delivery information beyond transport invalidation, or process termination and restart. A memory/process-based ledger does not possess these characteristics.

What are the different modes of service invocation?

Services can be invoked in several ways.

A one-way operation is executed once and does not wait for a response.

A request-response operation is executed once and waits for one response. In a request-response service, communication flows in both directions. The complete interaction consists of two point-to-point messages—a request and a response. The interaction is only considered complete after the response has arrived.

Publication (notification. means an operation sends information on an as-needed basis, potentially multiple times.

Subscription means incoming information is processed on an as-needed basis, potentially multiple times.

Can we use Multicast on queues?

No, multicast can be used only for topics. queues are a point to point and can’t be used for multicast.

Where we will go for ADB adapter and JDBC Activities?

We can go for ADB adapter where the data flow is synchronous and data integration is required between multiple databases. Whereas JDBC Activities can be used for asynchronous operations and where data integration is not required.

What is the difference between parsed XML and render XML?

Parse XML will parse the XML content as per the XML Schema or DTD or XSD that we defined. Render XML will render the data from the output and provide an XML string as per the Shema or XSD we defined.

Does Copy Create File Activity Allows Creating New Directories?

Yes. The Create File activity creates a new file or directory with the specified name. When creating a file, you can also provide the file contents.

How Do You Use Xslt File?

The Transform XML activity allows you to transform an input XML document into the output specified by the given XSLT File shared configuration resource.

How do you send a response from a web service?

We write to output to the queue from which we received the request.

Explain what is TIBCO Spotfire?

A : Spotfire Enterprise Player, when combined with Core Lab’s RAPID database, allows our clients to perform analytics on the data sets being generated in our Joint Industry Projects. Each active Joint Industry Project has a Spotfire Analytical Template associated with it which allows our clients to investigate the various data sets through tabular and graphical displays. Each display can be filtered by a wide variety of data types stored in our RAPID database such as formation, country, geologic basin, porosity, permeability, geochemistry parameters, etc. Spotfire is extremely easy to use and provides a powerful resource in reservoir evaluation.

Explain what is Spotfire Analytics?

A : Spotfire Analytics is an enterprise Analytics platform that helps business and technical users quickly to get an actionable insight. This allows customers to perform in-depth analysis of their data through the use of predictive and complex statistics.

Explain what are the features of Spotfire?

A : Analyze and explore data with intuitive, interactive visualizations
Bar charts, scatter plots, treemaps, box plots, map charts etc.
In-Memory data architecture provides incredible speed and flexibility
Direct access to corporate and local data sources, including spreadsheets
SAP BW, SAP R/, Oracle E-Business Suite, Salesforce.com, any ODBC database etc.
Excel, csv, any flat data file
Create and distribute analytic applications for the Web
Zero Footprint Client; no coding required
Easily creates sophisticated statistical analysis
Tight integration between S+ statistical package and Spotfire
Analyse event-driven and real-time data
Tight integration with TIBCO infrastructure products

Can we have backward transitions in TIBCO BW Processes?

A : In TIBCO Designer Processes, transitions between activities are always uni-directional. This means that we can’t go back to a previous transition from any point.

What is the role of TRA (Tibco Runtime Agent.)?

A : There are two main functions of TRA:
TIBCO Runtime Agent (TRA. is responsible for starting and stopping of processes running on a machine.
TRA provides runtime environment for TIBCO applications.
TRA runs on every TIBCO machine in the background.

What are the options for configuring storage for process engine’s checkpoint repository?

A : The options for configuring storage for process engine’s checkpoint repository are:
Local File: Information is stored in a local file which in case of engine crash/failure and the same information is used to resume the process flow once the engine is up. This mechanism works only in case of single server or load balancing approach.
Database: Information is stored in a database table which is used to resume the engine later. Fault tolerant engines can recover from a checkpoint only when database is used.

What is difference between fault tolerant and Load balanced deployment in TIBCO?

A : Load balancing:
Load balancing is done between two or more servers where the load is distributed between servers to avoid any server crashes due to heavy load on a single server.

: How Restful web services can be developed in TIBCO?
A : TIBCO provides a Plugin for REST and JSON which can be used to develop Restful web services in TIBCO designer

While debugging TIBCO BW processes, which activity can be used to write complete schema information to a file?

A : TIBCO provides Inspector activity which can be used for debugging purposes while developing applications in TIBCO designer. Inspector activity can be used to write all output information of designer activities to a local file including process variables and other details.

What type of resources in TIBCO EAR file?

Following type of resources are typically added in EAR file in TIBCO:

Local Project Resources (Processes, Schemas, Connections, Services, Variables etc.
Library Builder Resources Files.
Files referred in designer CLASSPATH
Files under Designer Installation directory

Describe the main features of TIBCO Spotfire .?

A : Faster, Easier Use of Data
Create Spotfire applications that interact directly with complex big data sources while hiding the complexity from end users
Access huge volumes of information uickly and easily
Create complex applications faster and leverage existing database skill sets
Richer Location Analytics :
Visualize sophisticated location source data directly in Spotfire
Get access to existing Esri and WMS data sources for richer data visualization
Bring GIS and data analysis strategies together seamlessly Spotfire Desktop
The most complete desktop analytics authoring for Excel users, business analysts, R- knowledgeable analysts, and data scientists
Full Spotfire desktop authoring for a single user
Connect to the wide array of Spotfire direct connect data sources

What are Spotfire Shared Folders?

Spotfire Cloud allows you to share what you discover instantly. In order to share Spotfire analysis files, you must save the file to a folder in your library. Personal users create folders in their online library; Work Group users can create folders in both their online or desktop libraries. Folders can be public, shared (by you or with you. or private depending on your subscription type.

Explain what are the features of Spotfire?

Analyse and explore data with intuitive, interactive visualizations

Bar charts, scatter plots, treemaps, box plots, map charts etc.

In-Memory data architecture provides incredible speed and flexibility

Direct access to corporate and local data sources, including spreadsheets

SAP BW, SAP R/, Oracle E-Business Suite, Salesforce.com, any ODBC database etc.

Excel, csv, any flat data file

Create and distribute analytic applications for the Web

Zero Footprint Client; no coding required

Easily creates sophisticated statistical analysis

Tight integration between S+ statistical package and Spotfire

Analyse event-driven and real-time data

Tight integration with TIBCO infrastructure products

While debugging TIBCO BW processes, which activity can be used to write complete schema information to a file?

Describe the main features of TIBCO Spotfire .?

Faster, Easier Use of Data

Create Spotfire applications that interact directly with complex big data sources while hiding the complexity from end users

Access huge volumes of information quickly and easily

Create complex applications faster and leverage existing database skill sets

What is the role of TRA (Tibco Runtime Agent.?

There are two main functions of TRA:

TIBCO Runtime Agent (TRA. is responsible for starting and stopping of processes running on a machine.

TRA provides runtime environment for TIBCO applications.

TRA runs on every TIBCO machine in the background.

What is difference between fault tolerant and Load balanced deployment in TIBCO?

Load balancing:

Load balancing is done between two or more servers where the load is distributed between servers to avoid any server crashes due to heavy load on a single server.

Fault tolerance:

How do you send a response from a web service?

We write to output to the queue from which we received the request.

How Do You Use Xslt File?

The Transform XML activity allows you to transform an input XML document into the output specified by the given XSLT File shared configuration resource.

What are TIBCO Ledger files and why they are important?

TIBCO Ledger files are used to store messages in case of RV certified messaging. Ledger files are important as they ensure delivery of each and every message to intended recipient in certified RV communication model in TIBCO.

What Is the Use of Critical Section Group?

Critical section groups are used to synchronize process instances so that only one process instance executes the grouped activities at any given time.

What is the use of spawn option in called process?

If spawn is checked, then that process will be executing externally with main process. And we are not support to make this spawn when we are using job shared variables.

What Is the Difference Between Concrete Wsdl And Abstract Wsdl?

The Abstract WSDL describes the interface of the web service which includes the format of request and response messages of each operation.

The Concrete WSDL describes the abstract WSDL plus transport information. Concrete WSDL contains messages, operations and transport specific information (JMS or Http., which is used by SOAP client.

What is the difference between parsed xml and render xml?

Parse XML will parse the xml content as per the XML Schema or DTD or XSD that wedefined.Render XML will render the data from the output and provide a xml string as per the Shema orXSD we defined.

Where we will go for ADB adapter and JDBC Activities?

We can go for ADB adapter where the data flow is synchronous and data integration required between multiple data bases. Whereas JDBC Activities can be used for asynchronous operations and where the data integration is not required.

What are the transactions in tibco?

In tibco every transaction is a business-related message. We have JNDI, XA transactions available in tibco.

Tell me the way you created the dashboard using IL (information link.)?

What type of resources in TIBCO EAR file?

Type of resources in EAR file in TIBCO: Local Project Resources (Processes, Connections, Services, Schemas, Variables, etc..
Files referred in designer CLASSPATH
Library Builder Resources Files.
Files under Designer Installation directory

What is the role of TRA (Tibco Runtime Agent.)?

Role of TRA: TRA is responsible for beginning and stopping of processes running on a machine.
IT provides runtime environment for TIBCO applications.
TRA runs on every TIBCO machine in the background.

So, this brings us to the end of the TIBCO Spotfire Interview Questions blog. This Tecklearn ‘Top TIBCO Spotfire Interview Questions and Answers’ helps you with commonly asked questions if you are looking out for a job in TIBCO Spotfire or Business Intelligence Domain. If you wish to learn TIBCO Spotfire and build a career in Business Intelligence domain, then check out our interactive, TIBCO Spotfire Training, that comes with 24*7 support to guide you throughout your learning period.

https://www.tecklearn.com/course/tibco-spotfire/

TIBCO Spotfire

About the course

Tecklearn’s TIBCO Spotfire Training makes you an expert in using Spotfire and teach you about Spotfire automation services, statistics server and enable students to enhance their troubleshooting skills. As part of this program, you will learn Spotfire administration, data visualization, analytics, creating dashboards, working with data tables and data sources and IronPython scripting.

Why should you take TIBCO Spotfire Training?

The average annual pay for a Spotfire Developer is $146,600 per annum. -ZipRecuiter.com.
Pfizer, Amgen, Samsung Electronics, Genentech and many other MNCs across countries use TIBCO Spotfire.
Main benefits of TIBCO Spotfire are cutting costs, offering necessary features for analyzing data, providing many visualizations, working with third-party tools, and being flexible to cater to your needs.

Curriculum

Introduction to TIBCO Spotfire

TIBCO Spotfire
Spotfire features
Data visualization techniques and Charts
Data Filtering
Spotfire Dashboard

Data Modelling

Data Tables
Properties of Data Table
Data sourcing
Relations in data table
Data table filters
Binned and Hierarchy Column creation

Spotfire visualization techniques and Charts

Spotfire visualization techniques
Colour Coding Concepts
Bar chart
Pie Chart
Combination chart and line chart
Cross-table Visualization
Column Selectors
Bars and data labels
Analyzing data
Tree Map and Scatter Plot

Features of Spotfire

Library and Information services
Deployment
Spotfire Expressions, Labels, Charts, Schemas

Spotfire Dashboard

Dashboard Creation
Features
Data filtering
Analysis techniques
Box plot, Pareto chart and Combination chart

Map Visualization

Map Visualization
Features of Text Area
Drag and Drop of Visualization
Forecasting
Application of Profiler

Data Analysis

Visualization and analysis
Custom expressions
Deploying Action control

Visual Insights

Visual Appearance
Data Panel
Data Connector
Data Profiler

Spotfire Administration

Administration and maintenance Concepts
Installation of Spotfire
Deployment
Authorization process
Security and authentication

Spotfire Project

Got a question for us? Please mention it in the comments section and we will get back to you.

1,073