1) Middleware – why?
Answer: 1.for best performance.
2. For synchronizing data flow amongst various applications with in a enterprise across the enterprise
2) Difference between point-to-point, multicast message and broadcast message
Point to point is between one publisher and single subscriber.
Multicast is between publisher and known subscribers.
Broad cast is between a publisher and many unknown subscribers.
3) What is the advantage of Subject based addressing?
Answer: 1.Can publish broadcast messages to distribute information quickly and reliably to many consumers.
2. (Location Transparency) Program processes can communicate without knowing the details of network addresses or connections.
3. (Decoupling and data independency) we can dynamically add, remove and modify components of a distributed system without affecting other components.
4) Platforms supported by TIBCO?
Answer: Platform independent.
ADB
1) Design Time configuration.
2) Run time ODBS configuration. Which driver did you use?
3) What are the various services provided by ADB?
Answer: 1.Publication Service.
2. Subscription Service.
3. Request-response service.
4) How do you configure the Request Response Service and use it?
Answer: 1. this service is often called as RPC (Remote procedural call).It is demand driven type.
2. In this the adapter receives request from one application, parses the request, calls the appropriate component i.e. query or call procedure to set the input fields.
3. And then calls the other set of component to get output fields. The output
Fields are wrapped into a schema and sent back to the caller as response.
4. We can configure ADBServer with 3 tabs,
A. Configuration tab
B.Call operation tab
C.Advanced tab
5. Configuration tab
a. Name – Service Name
b. Transport Type –JMS or TIBCO RV
C. If TIBCO RV is Transport type Quality of service -- Certified, Reliable and DQ.
D.If JMS is Transport type Connection Factory type—Topic and Queue
E.Delivery Mode if JMS is selected – Durable (Persistent), Non-Durable (Non-persistent).
F.Mode
Request –reply is the basic request reply mode. The Server subscribes the request and publishes the reply.
RPC allows us to configure adapter to act as RPC i.e. remote procedure call.
G.Wire Format—RV Messages (TIBCO RV only)
---XML Message (TIBCO RV or JMS)
---AE Message (TIBCO RV only)
5) In what scenario would you use the Publication and Subscription service?
Answer: Subscriber: When running as a subscriber, the adapter listens on a subject, receives messages and updates the relevant tables, in its associated DB.Then the data is available to other applications that have access to DB.
Publication: When running as a publisher, the adapter extracts data from the
Changed rows from database tables and publishes them on appropriate subject names.
6) How do you create/specify the relationships between the Primary and the child tables?
Answer: JoinTo is the tab available in TABLE tab for parent child relation ship.
7) How does ADB maintain/handle the exceptions that occur?
Answer: Next Question Answer.
8) What are the various exception tables?
Answer: 1.Exception Table
2. Opaque Exception Table
Exception Table: If adapter is unable to write data into subscriber table, it writes the data into Exception table with the exception raised. If this table is not configured previously, it is created by subscription service when an exception raised.
Opaque Exception Table: A message is logged into this table when subscription service is fails to generate records in the destination table or the adapter fails to insert a message into an Exception Table (above Table).
9) Can ADB be used to invoke call procedures? If so, how?
Answer: Subscriber service: In subscriber options tab we have “Pre Commit Stored Procedure”. In this field we have to specify the name of stored procedure .The procedure is called after the insert, delete, update and prior to commit. The procedure is executed and returns results to the adapter.
Request-Response service: If mode option (in configuration tab) is selected with RPC,
“Call operation tab” is going to appear .It have the fields,
A. Name ----unique name of call operation.
B. Catalog/Package—package /catalog where the procedure resides.
C. Schema
D. Procedure name.
E. Select procedure
F. Maximum rows.
G. One way.
10) What are all the databases that ADB support?
Answer: In adapter Instance configuration tab, we have menu called “Vendor”.
It contains the DB’s supported by ADB.Example Oracle, Sql Server, and DB2 etc.
11) If introspecting table and updating table is same then how can you avoid publishing of data after doing some modifications?
Answer: We have to check the checkbox “Enable loop detection” publisher options tab. If loop detection is enabled, the following column is added to the source table “ADB_SOURCE”, T-indicates the row is not to be published, NULL –indicates the row can published.
12) ADB_L_DELIVERY_STATUS (MY QUESTION)
Answer: P-indicates pending Acknowledgement.
N-indicates that new message has arrived, but has not yet been published in the publication table.
C-indicates completed publishing.
F-indicates failed publishing.
13) ADB_OPCODE (MY QUESTION)
Answer: Operation codes used by ADB,
1-indicates INSERT
2-indicates UPDATE
3-indicates DELETE
4-indicates UPDATE if row exists, otherwise INSERT.
BW
1) What is the Difference between 2.x and 5.x – for those who worked on both
2) What is a BW process phases?(MY QUESTION)
Answer: 1.Analysis (Define and analyze problem).—“CLEAR UNDERSTANDING OF REQUIREMENTS”
a. define and delimit the problem.
b. identify process.
c. identify components.
d. describe business events and objects.
e. design business process.
f. consider domain setup.
2. Domain Setup (Install software and configure domain).—“HARDWARE AND SOFTWARE REQUIRMENTS SOTHAT TROUBLE FREE TRANSITION FROM DESIGN, DEPLOYMENT AND ADMINISTRATION”
3. Service Configuration (Configure Adapters). ---”Web services interacting with internet and adapter services interaction with files, DBS and ERP applications”
a. Installing the adapters.
b. Setting up design time adapters.
c. Configuring the run-time adapters.
d. Accessing the adapter service from process.
4. Process Design (Implement & test business process).—Using TIBCO designer GUI we create our business process using predefined activities and add conditions and mapping as appropriate.
5. Deployement (Deploy to run time engine).”After testing it in development environment it is deployed in the test environment. After TIBCO admin GUI is used to deploy the ear files (which are created by TIB Disgner)”
6. Production (Manage & Monitor deployment)
3) What are different types of groups?(MY QUESTION)
Answer: 1.Transaction groups
2. Variable groups-Use global variable groups to allow multiple developers to work on global variables simultaneously. Each group has its own file
in multi-file project.
4) What are the components of process definition?(MY QUESTION)
Answer: 1.Activities 2.transactions 3.Groups 4.Shared Configuration Resources
5. Sub process
5) What is a pallet?(MY QUESTION)
Answer: Pallet is a resource, which organizes activities of same domain.
It allows us to add activities to our project when we select it.
6) What are all the pallets you have used?(MY QUESTION)
Answer: 1.Parse Pallet.
2. JMS pallet.
3. RV pallet.
4. General Activity Pallet.
5. XML Activity pallet.
6. File pallet.
7. JDBC pallet.
8. Soap pallet.
9. Http pallet.
7) What are the various messaging options available in TIBCO BW?
Answer: 1. RV Messaging.
2. EMS Messaging.
3. Smart Sockets.
8) How is Conditional branching possible in Tibco Business Works – what are the various options available?
Answer: 1.If...Else … otherwise ---transition success with condition and other condition.
2. Surround with values.
3.
9) Linked to Q 3 above – how will you accomplish “if ...Else …otherwise” logic using BW.
Answer: transition success with condition and other condition.
10) What are Process and Global variables?
Answers: process variables are those which are local variables’ of a process. Out of process these variables disappears.
Global variables are can be accessed in any process with in the project, these are just like application properties file in java. URLs, username and password of external servers are saved as global variables.
11) Can Process variables be changed at run time?
Answer: yes.
12) How will I change the Global Variables in the Production Env, once it is deployed?
Answer: Tibco administrator has the privileges to change the global variables in the production environment but these values are going to effect only when restart the engine.
13) How is Error Handling done in BW, how can the try….catch block be implemented in Tibco?
Answer: 1.By taking transition with condition type “error”
2. Generate error activity from General activity pallet.
3. Use group to create a set of activities that have a common error transition. This behaves as try catch block .This allows us to have a set of activities with only one error handling transition, instead of trying to catch errors on each activity.
14) What is the difference between DTD’s and XSD’s?
Answer : DTD(Data type definition): it is old version of specification of xml.It do not validate the data types of xml content and sequence of elements and do not have specific rules as like XSD (xml specification definition).XSD validates the data types and as well as parent elements, no of child elements ,sequence of elements and repeating elements.
15) Why would you use the checkpoint activity?
Answer: When detecting duplicating messages, it is important to place the Check point activity before any activities that we do not want to execute more than once.
The state of the variables (input massage) is saved in the check point.
16) How does wait and Notify activity work in Tibco Business works?
Answer: TIBCO BW provides Wait and Notify activities and the ‘Receive notification’ process starter to handle inter process communication.
A process containing wait activity waits for another process to execute a corresponding Notify activity. It is like ‘wait’ and ‘run’ methods in multithreading of java.
17) What is the difference between Copy of and For Each in Tibco Business Works?
Answer: Copy of: It is an XSLT statement to create a copy of selected node, including child nodes .Both the copied node and destination node must have the same name and structure.
For- Each: Performs the specified statements once for each time in the selected node. This is use full if we wish to process each item of a repeating element once.
18) Consider that I have huge file to be read, can I use read file activity? How can I improve the performance, I need to select 10 records at a time, how is it possible.
19) How do you create an EAR file and deploy it. What does an EAR file contain?
20) What is an activity?(MY QUESTION)
Answer: 1. Activities are individual units of work in a process definition.
2. Activities are generally operations that interface to external systems.
3. Activities are communicated with in process.
21) What is the difference between AE schema and the properties file?
22) How will you debug the BW processes?
Answer: 1.Write to log activity from general activity pallets.
2.using break point after every activity and logging inputs and outputs of an activity ,checking all these are properly mapped or not.
MY Questions
23) What are various activities in soap pallet?
Answer: 1.Retrieve Resource. This activity is on soap client, when the client needs
WSDL file we need to configure this activity. This makes WSDL file available to the client.
2. Soap Event Source. It is process starter on the server side. It receives the request from soap client. It creates the process instance for the incoming soap request.
3. Soap request-reply. This activity performs a request on the specified web service and optionally expects a reply from the web service.
4. Soap Send Fault. This activity sends a soap fault /error to the client if an error occurs during processing of a soap request.
5. Soap Send reply. This is sending reply to client.
24) What are various activities in JMS pallet?
Answer: Queue: 1.Queue receiver .receives the request. Process starter on server side.
2. Queue sender. It is also a type requester but it does not expect any reply from the server. It also acts as Queue requester.
3. Queue requester. Sends request to the queue and expects the response .It is used in combination with the ‘reply to JMS message’.
Topic: 1.Topic subscriber. It is process starter on server side .It creates process instance for the request on receiving a request.
2. Topic publisher. It acts as requester but does not expect any response kind from server.
3. Topic requester. It sends request to the server and it expects a response form the subscriber. It is used in combination with the ‘Reply to JMS message’.
25) What are the various activities in the RV pallet?
Answer: 1.Publish RV message. publishes message on subject to the RV subscriber.
2. RV subscriber. It listens the messages on a subject and creates process instance on the
3. RV Transport.
4. Reply to RV request.
5. Send RV request.
RV/JMS
1) What is the different type’s quality of services RV available?
Reliable
Certified
Distributed Queue
Difference between reliable and certified.
Answer: 1.In case of reliable there is no guarantee of delivery of msg but in case certified, guarantee of msg delivery.
2. The msg is saved for 60 sec only on publishing side but in case of certified the msg is saved until it get acknowledgement from scriber.
3. The msg is saved in daemon (temporarily) but in case of certified there is a concept of ledger files.
4. Reliable is best in case of “broadcasting mode” and certified is best in case of multicast and point to point.
What for Distributed Queues are used?
Answer: It is the concept of load balancing on subscriber side. It is implemented when there is a huge rate of data transfer.
What is Persistent/Non-Persistent in JMS?
Answer: messages are made persistent or non persistent .The messages are saved in “persistent store” in case persistent, if ems server is down there is no loss of messages in destination. The subscribers or receivers get messages after ems server is up. But in case of non persistent, once the server is down means the messages are lost.
What is durable /Non-Durable in JMS?
Answer: subscribers are configured as durable or non –Durable. The durable messages will get msg when they are up i.e. we are forcibly make topic subscribers as asynchronous by making them durable subscribers. Non durable subscribers should always in active mode in order to get messages.
Which one is having more security RV or JMS?
Answer: JMS is more secured because it is server based.
What is Network, Service and, Demon Parameter?
Answer: Daemon: It is not specified if RVD is running on the same system. If RVD is running on remote system it is specified. It contains hostname followed by socket number.
Network: This field contains network (hostname, IP address and network name). It contains 3 parts, separated by semicolons network, multicast groups, and send address. Multicast groups it is an IP ADDRESS separated by commas, these are the listeners in the network group.
Service: It is a port number or service name.
Is it possible to change the Service parameter?
Answer: If we specify the service parameter the data is diverted to that port.
Which protocol does RV use for Reliable Messaging
Answer: UDP
How do you detect if RV or JMS Server is down using administrator?
How Point-to-Point is accomplished using the Rendezvous Palette?
How are Distributed Queues configured in Tibco BusinessWorks?
What are the different kinds of Ledger files?
Answer: 1.File based ledger: This ledger file is generated when we are specifying the name. Even the process terminates, transport is destroyed the ledger resides in the disk.
2. Process based ledger: If we are not specifying any name i.e. NULL, it is considered as process base ledger. If process terminates, transport is destroyed the ledger will lost and it can not be used for new transport.
What is the difference between a topic and queue?
Answer: Topic-synchronous mode of communication.
-publisher and subscriber model.
-broad cast type messaging.
-there is no guarantee of delivery.
Queue-asynchronous mode of communication.
-point to point model.
-unidirectional type of messaging.
-there is guarantee of delivery.
When will u use a topic and when will u use a queue?
Answer: 1.only one producer and only one consumer is there then “Queues” are used. Simply “Queue” is of type “Point to Point”. One or more than one publishers and one or more than one subscriber is there than “Topic”. Simply “Topic” is of type “Broadcast messaging”.
Can queues be shared between two consumers?
Answer: Yes. If queue is non-exclusive (default) it can be shared by any number of consumers. Non-exclusive queues are useful for balancing the load of incoming messages across multiple receivers.
What is an exclusive queue? When would u use it?
Answer: If queue is exclusive, then all queue messages can only be retrieved by the first consumer specified for the queue. Exclusive queues are useful when we want only one application to receive messages for a specific queue.
A message in a queue can be consumed by how many consumers?
Answer: if all are non-exclusive queue any number of consumers will receive messages. If exclusive queue, the first consumer will get messages.
How will you grant privileges to topics and queues?
Answer: Only EMS admin have privilege
What are the protocols supported by JMS/EMS?
Answer: 1.SSL (HTTP) 2. TCP
Java
1) What are the various activities available?
2) What is Java method, Java function activity?
3) Java to XML , XML to Java activity
4) For any java methods to be used in BW, what are the conventions to be followed (what should the declaration of the method be)
ADMIN
1) What is fault –tolerance?
2) How do you configure FT?
3) What is Load Balancing? How do you incorporate this using TIBCO?
4) What are the diff types of Load Balancing? What is the difference?
5) In a Fault Tolerant scenario, how will a secondary know Primary is down, and how many Machines can be configured for Secondary servers.
6) What are the various kinds of relationships that can be configured between Master and Secondary?
7) What are Rule bases? How do you configure rule bases? What are the various actions that can be taken?
8) What is a domain, how will we create it, why do you create it, is it necessary?
9) How do you change the RV parameters for a domain?
10) What are the various tabs that appear on uploading an EAR file?
11) Can you create EAR file using Scripts, and also deploy using Scripts, if so what are all the commands.
12) How would you add a machine in the Domain, using what utility?
13) Can a machine be part of Two Domains, if so how?
Adapters/SM
1) How is Dynamic Overriding possible in 5.x is it possible from admin console.
1) U can ask Gen Q’s as to how was the adapter configured , the various msg format conversions , error handling of adapters …
2) How was the data published? Transformation rules etc etc
3) How do you configure the design–time adapter and the Run-time adapter?
4) How does Publish-subscribe and Request-Reply mechanism work in adapters.
5) How you monitor simple Hawk console in administrator, what do I need to change in the TRA entries so that I see the hawk screen in the administrator.
6) What are the different kinds of Ledger files
7) What is SmartMapper, how will you do Cross-referencing. How will you use Lookup method…what are the Parameters that should be specified.
XPATH
1) What are the different conditional statements available?
2) What are the different functions/operators available – String, Date/Time, number, Logical etc etc.
City Bank –Singapore
1) What is Target Name Space while defining XSD?
Answer: 1.It follows the URL syntax.
2. It must be unique for every wsdl file.
2) What are BW Templates?
Answer: Project Template is a pre-built project. It can contain folders for organization, configured resources and partially configured resources .We can use these templates as foundation for other projects similar in nature. Using a template we can leverage our work when performing similar work.
We can customize these templates to use in new project. It make the process fast.
3) What is the Soap version you have used?
4) What is critical situation you have faced while mapping?
5) What is the difference between AE Schema and RV message?
6) How we can change Global variables after deployment and design time?
7) What is namespace in relation with XSD?
IBM –Rahul
1) What is an event object?
2) What are event-queues?
3) What are inbox-names?
Answer: Transport objects can create inbox names, designating a destination that is unique to that transport object and its process. Rendezvous software uses point-to-point techniques to deliver messages with inbox subject names.
One common use of inbox names is as reply subject names in request/reply interactions
4) What are the wire formats supported by file adapter?
OSI-HYD
1) How we can implement DQ with ADB adapter?
2) How many Child tables can be added to a Parent table?
3) How you deploy application with Administrator?
4) What is TIBCO designer?
Answer: TIBCO Designer is a graphical user interface for designing and creating integration project configurations.TIBCO designer allows us to drag and drop components into a project and build an EAR for the project.
5) What are all the protocols used in RV?
6) What is TRDP?
7) What is the difference between RVD and RVRD?
8) What is mapper activity?
Answer: A Mapper activity adds new process variable to the process definition. This variable can be simple data type, a TIBCO AE Schema, an XML-schema or complex structure. It is usually used with data format.
9) What is Direct Communication?
Answer: A direct communication is a scenario, communication without RVDS on both sides of applications.
10) What is loop detection in case of ADB?
11) How many ways we can create ear file?
Answer: 1.We can create EAR file through the Designer. In general pallet of designer we have Enterprise archive icon before this we have select a folder then only we can get the general pallet of designer. And give the required information in the configuration tab and click the ‘build archive’.
2.Through “Adapter resource” pallet of designer we can create the Adapter Archive (aar)file.
12) How the scheduler is created in RVDQ?
Answer: The scheduler is decided basing on different parameters,
1. Scheduler weight.
The group members with higher weight become the scheduler when services are started.
2. Heart beat interval.
3. Schedular Activation Interval.
13) What are designer pallets?
Answer: 1.General pallet.
2. XML-tools pallet.
3. Adapter resource pallet.
4. Adapter schema pallet.
5. Repository pallet.
14) How do test the performance of the ADB adapter?
Answer: Performance of ADB adapter depends on
1. Polling Mechanism. In ‘Adapter services tab’ we have fields ‘use polling batch size’ , ‘Poling Interval’ and ‘Polling batch size’. If ‘use polling batch size’ is not checked i.e. not activated, the adapter is going to pick all the new rows and publishes .This could effect the adapter performance. If this field is checked ‘Polling batch size’ field is activated, only that number of records is picked up by adapter per polling interval. So performance of adapter is improved.
Polling interval is the field specified in milliseconds. The default is 5000.This is the time interval often checked by the adapter publishing service into the table for new records. If the Polling interval is set to 0 (zero), it is assumed that we are using alerter to manage the polling.
2. Messaging groups.
Dubai-raja & Chandra Bose
1) What is ‘spanning ‘while using ‘call process’ activity?
Answer: If this option is checked the parent process cannot access the sub process output. The called process (sub process) executed as separate process instance.
2) What is ‘pick first groups’ while working with groups?
Answer: Pick first groups allow process execution to wait for one or more events. The first event that completes determines which transition to take to continue processing.
Only request/reply, wait for activities and the activities that have the pause symbol can have valid transitions from the start of the pick first group.
3) What is dynamically determining the process to call?
Answer: Here we can call a sub process basing on a condition like if … else. If some condition is true executes one process else other process. The condition is an X-path expression. Here in this case dynamically determined which sub process to be basing on request condition.
4) What is the ‘critical section’ of a group activity?
Answer: 1.critical section groups are used to synchronize the process instances so that only one process instance executes the grouped activities at any given time. All other process instances will be in waiting until the currently executing process instance completes critical section group.
2. Critical section groups are particularly useful for controlling concurrent access to shared variables.
3. Synchronization can be done for 1.single process definition for single process engine.2.multiple process definition for multiple process engines.
4. We have select single group/multiple groups from ‘SCOPE’ field.
5) What is TIBCO BW?
Answer:
