15+ Must-Know Tibco [Spotfire] Interview Questions & Answers
Last updated on 03rd Jul 2020, Blog, Interview Questions
Spotfire is an extremely powerful enterprise-grade analytical platform for deriving valuable business insights. It is a smart, secure, flexible, and scalable tool that provides data visualization, discovery, wrangling, and predictive analytics capabilities. Spotfire also includes an effective dashboard and interactive analytical apps as well.
1) 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.
2) 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.
3) 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 4GL 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 4000 functions for data manipulation, graphics, statistical modeling, and integration.
CSAN library of available packages.
4) 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.
5) Explain what is the use of Spotfire Analytics?
TIBCO Spotfire Analytics provides an incredibly fast and flexible environment for analysing 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 analysing 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.
6) 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/3, 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
7) 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.
8) Describe the main features of TIBCO Spotfire 6.5?
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
9) 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.
10) 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.
11) 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.
12) 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.
13) 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
14) 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.
15) 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.
16) 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.
17) 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.
18) What is difference between fault tolerant and Load balanced deployment in TIBCO?
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 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.
19) 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.
20) 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.
21) 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.
22) 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.
23) Have you heard about personalized information link?
Yes, using this method we can filter the users to view the dashboard. 2 parameters are used for this. CURRENT_USERS AND GROUP_USERS, from version 6 onwards there is one more named CURRENT_USER_DOMAIN.
24) 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 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.
25) Can we use different filters on different pages?
We can use filtering schema to apply different filter.
26) 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.
27) 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
28) 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.
29) 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.
30) 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.
Get On-Demand Spotfire Training from TOP-Rated Instructors
- Instructor-led Sessions
- Real-life Case Studies
31) What are the transactions in Tibco?
In Tibco, every transaction is a business-related message. We have JNDI, XA transactions available in Tibco.
32) 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.
33) 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.
34) 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.
35) 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.
36) 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.
37) 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:
Java Transaction API (JTA) UserTransaction
38) Is it possible to create a drop-down filter?
Yes, using the text area you can create a drop-down filter.
Get Spotfire Training Course from leading Professional Certification Training ProviderWeekday / Weekend BatchesSee Batch Details
39) 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.
40) What is the difference between SQL direct and other JDBC activities?
Other JDBC activities can only do a specific DML operation (insert, update, modify), whereas sql direct can execute all the DML operations including table creation and deletion too.SQL direct is mainly used for dynamic DB operations.
41) 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.
42) 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.
43) 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.
44) 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.
45) 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.
46) 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.
47) 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.
48) How do you send a response from a web service?
We write to output to the queue from which we received the request.