Interview Questions.

Question 1. What Are Adapters?

Answer :

Adapters are connectors to statistics resources to trap occasion changes. Once an Adapter catches a occasion alternate, Adapter publishes the message to a message container using both EMS or RVD.Adapter is a gateway among exceptional packages the usage of messaging channels.

Question 2. What Are The Different Types Of Adapters?

Answer :

Technical Adapters ( File Adapter, DB Adapter )
Functional Adapters ( PeopleSoft Adapter, SAP R3 Adapter)
Custom Adapters
Soap Tool Interview Questions
Question 3. Explain About Adapter Components ?

Answer :

Each adapter has  primary components, an adapter palette and a run-time adapter. In addition, a few adapters consist of a design-time adapter. The adapter palette and layout-time adapter are used all through configuration, and the run-time adapter is used at production time.

Question 4. Explain About Adapter Palette ?

Answer :

Each adapter includes a palette this is used for configuration. The palette is automatically loaded into TIBCO Designer at some point of adapter set up and to be had the subsequent time Designer is started out. The palette enables you to configure adapter precise alternatives, which includes its connection to the vendor utility, logging options, and adapter offerings. During the design segment, the palette connects to the vendor utility and fetches information about connection alternatives and statistics schemas. You can then graphically pick the right gadgets. For instance, during configuration of a TIBCO Adapter for ActiveDatabase adapter example, the palette fetches all pertinent tables within the database. You then pick the tables that the specific service is to ship or get hold of.

Service Oriented Architecture (SOA) Tutorial
Question 5. What Is Run-time Adapter ?

Answer :

Once the adapter has been configured the usage of TIBCO Designer, it is able to be deployed. A deployed adapter instance is referred to as a run-time adapter. A run-time adapter operates in a production environment, handling communique between a supplier utility and other applications which might be configured for the TIBCO surroundings.

TIBCO Interview Questions
Question 6. Design-time Adapter ?

Answer :

Some adapters use a design-time adapter (DTA) to get right of entry to a supplier software and return layout-time configuration data. The palette is a patron of the DTA process. The DTA connects to the vendor application, fetches statistics schemas and sends them to the palette.

Question 7. Explain About Adapter Lifecycle ?

Answer :

The following is an overview of the adapter lifecycle:

Install the seller application to which the adapter connects before installing the adapter. For many adapters, the adapter and vendor utility need not be hooked up at the same machine.

Adapters depend on different software from TIBCO. Before putting in an adapter, the TIBCO Run-Time Agent software ought to be installed on each pc on which the adapter runs.

Create an adapter example and shop it in a mission using TIBCO Designer™. A undertaking includes configuration information required for a run-time adapter to have interaction with the seller software and different applications.

Deploy the adapter. An adapter instance is deployed the usage of TIBCO Administrator.      

Using TIBCO Designer, create an Enterprise Archive (EAR) report, which contains information about the adapter times and approaches you desire to set up.

Using TIBCO Administrator, upload the EAR, then deploy the adapter on the device(s) of your desire. You can set runtime options earlier than deployment.

Using TIBCO Administrator, begin and prevent the adapter.

Monitor the adapter the usage of the integrated tracking tools provided by TIBCO Administrator.

Tibco BW Interview Questions
Question eight. Explain About Adapter Services ?

Answer :

Adapters are answerable for making records from one-of-a-kind programs to be had to other programs throughout an agency. To accomplish that, an adapter is configured to offer one or greater of the following services: 

Publication Service 
Subscription Service 
Request-Response Service 
Request-Response Invocation Service
1) Publication Service : 

An adapter e-book provider acknowledges while business events appear in a seller utility, and asynchronously sends out the event statistics in realtime to fascinated systems in the TIBCO environment. For instance, an adapter can submit an event every time a brand new customer account is delivered to an application. Other packages that acquire the occasion can then update their records just because the authentic software did. When an application receives a request to create a consumer record, the application notifies the adapter approximately the request and the adapter publishes the event. 

User Interface-----------------Application X--------------Adapter -------------- TIBCO Messaging 

Create report Send to adapter Publishing 

Polls on the source statistics table (base desk). 

Reads facts from the source desk. Sends the records to the message bus.

2 ) Subscription Service: 

An adapter subscription provider asynchronously performs an movement which include updating business items or invoking local APIs on a seller application. The adapter provider listens to outside business occasions, which trigger the perfect movement. Referring to the preceding instance, an adapter subscription provider can pay attention for consumer report introduction activities (going on in an application and posted to the TIBCO infrastructure) and update some other software. 

TIBCO Messaging------------Adapter-----------Application Y Subscribing Update record 

Reads facts from the message bus. 

Gives the statistics to the destination table.

3) Request-Response Service: 

In addition to asynchronously publishing and subscribing to events, an adapter can be used for synchronously retrieving data from or executing transactions inside a seller utility. After the action is accomplished inside the vendor utility, the adapter provider sends a reaction back to the requester with either the effects of the action or a confirmation that the action took place. This entire procedure is known as request-response, and it is useful for movements together with including or deleting business items. 

Receives requests from other programs. 

Parses the requests. Returns response (Sends best the requested facts to the message bus).

Four Request-Response Invocation Service:

An adapter request-reaction invocation carrier is similar to the request-reaction carrier, besides that the jobs are reversed. The dealer utility is now the requester or initiator of the service, in place of the provider of the carrier. The adapter service acts as a proxy, giving the seller software the potential to invoke synchronously capability on an external device.

Question nine. What Are The three Main Configuration Elements Common For All Adapters?

Answer :

Design Time ( For BW Testing )
Run Time ( For Admin Deployment )
Service ( Pub / Sub, Request-Reply )
Soap UI Interview Questions
Question 10. What Is Publish By Value And Publish By Reference?

Answer :

In Publish with the aid of Value, all of the distinct columns inside the supply table are copied into the Publishing desk.

In Publish through reference, only the specified key column values are copied to the publishing desk.

Question eleven. What Is The Difference Between Jdbc Activities And Adb Adapter?

Answer :

ADB makes use of ODBC to connect, JDBC makes use of JDBC
ADB is more suitable for instances wherein you've got quite a few processing
ADB is greater suitable for instances where you want that a specific action on a DB Table triggers a BW method.
ADB adapter is first-class for publishing from database.
For easy inserts and updates then ADB subscriber is excellent.
In case of insert or replace to database then test if you have complicated JDBC inserts, transaction control and different dynamic queries then JDBC activities are best.
JDBC is more appropriate for running dynamic code wherein in runtime you may execute statements with special values relying on procedure execution.
Spotfire (TIBCO) Interview Questions
Question 12. What Are Modes Of Operation For File Adapter In Record Mode?

Answer :

Synchronous mode upon receiving an occasion, the e-book provider will allow other offerings in the example best after it completes the processing and publishing of all of the files that suit the required standards.
In Asynchronous mode the ebook carrier allows different services of the example to receive activities whilst it's far processing and publishing a report. By default Subscription carrier always operates in Asynchronous mode.
Soap Tool Interview Questions
Question 13. What Are Supported Sql Operations In Database Adapters?

Answer :

The database adapter helps the following SQL operations for publishing and subscribing:

INSERT
UPDATE
DELETE
UPDATE/INSERT (update if row exists, otherwise insert)
Question 14. What Are The Transport Types Supported By Adb Adapters?

Answer :

Rendezvous
JMS
Question 15. How Can You Fine-song An Adb Adapter? What Are The Different Parameters That Can Be Used?

Answer :

We can use post by using value or put up via reference for excessive velocity and facts kind assist like oracle lengthy respectively.
Can use polar or alerter for common and infrequent information adjustments respectively.
Adb.PollingInterval, ADB.DUDPECT.Adapter instance_name parameters can be used to do glide manage and avoid duplication respectively.
Service Oriented Architecture (SOA) Interview Questions
Question 16. What Are The Quality Of Services We Can Have In Adapter Publishing Services?

Answer :

RV: reliable, certified, transactional

Question 17. What Are The Wire Formats We Can Have In Adapter Publishing Services?

Answer :

Wire formats:

RV: energetic organization message, RV message, XML message.
JMS: XML message
Tibco Ems Interview Questions
Question 18. Explain The Internal Functioning Of Adb Publication Service?

Answer :

when we configure ADB publishing carrier it creates Publishing desk for supply table, Trigger acts as a bridge between supply and publishing desk. Whenever statistics is being inserted/updated/deleted from supply table, it will likely be inserted into publishing desk by using trigger. ADB has some other factor referred to as polling agent. Polling agent might be hold searching out new inserts into publishing desk and if it reveals any then converts the report in p table into the desired cord format and publishes on designated first-class of carrier.

TIBCO Interview Questions
Question 19. What Is Publish By Value And Publish By Reference. Explain The Pros And Cons?

Answer :

submit via cost: In this type the adjustments in the supply desk are meditated within the p_table and the data s taken from there. Its used whilst excessive pace is required. It does not assist records types like oracle long.

Publish through reference: In this type the facts is at once taken from the supply desk where only the primary key will come from p_table. It permits information kinds like oracle long. Loss of adjustments inside the source desk may be lost due to the ready time. (This can be averted using alerter).

Question 20. What Are The Types Of Message Transfers In File Adapters?

Answer :

Record switch: To combine report systems to TIBCO AE surroundings.

Simple record switch: To transfer files to different TIBCO adapters.

Tibco Admin Interview Questions
Question 21. Can We Limit The Number Of Columns To Be Published From The Source Table?

Answer :

Yes, the usage of the use area in adapter publishing desk tab. Just uncheck the columns you dont need to use.

Question 22. Can We Publish Parent And Child Table Information By Using Single Adapter Configuration And How?

Answer :

Yes, inside the adapter writer desk tab create a figure table first via appearance up after which upload the kid table using the upload infant tab then click on on the kid desk column to specify the foreign key than to establish a dating among the number one key of the parent and the overseas key of the child go to the column in the infant table and specify the primary key of the figure desk.

In the subscription carrier the vacation spot table is created and the kid desk mapping tab could have the child desk at the left mapped with the determine table on the right.