Tibco-Interview-Questions-page4

56. Which mechanism can be used to pass data between a process instance and a called sub process other than mapping from/to the caller's input/output ? Answer: 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. 57. What are the three scenarios...

Read More

Tibco-Interview-Questions-page5

66. What is difference between shared variable and job shared variable ? Answer:  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...

Read More

Tibco-Interview-Questions-page3

46. Explain the process configuration parameters - Max Jobs, Flow Limit & Activation Limit ? Answer: Max Jobs : Max Jobs specifies the number of process instances that are kept in memmory. Once this limit is reached newly created process instances (subject to flow limit) are paged out to disk.0 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 ie it enters a FLOW_CONTROLLED state and does not accept...

Read More

Tibco-interview-questions-page2

34. What activities are supported in XA Transaction ? Answer: 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. 35. What are the possible Error output's of Read File activity? Answer: Integration can be at different application...

Read More

JMS Topic Publisher Activity

The JMS Topic Publisher sends a message to the specified JMS top...

Read More

JMS Queue Receiver Activity

Starts a process based on the receipt of a message for the specified JMS que...

Read More

JMS Queue Sender Activity

The JMS Queue Sender activity sends a message to the specified JMS que...

Read More

SQL Direct Activity

The SQL Direct activity executes a SQL statement that you provide. This activity allows you to build a SQL statement dynamically (using other activities), then pass the SQL statement into this activity’s input. This activity also allows you to execute SQL statements that are not supported by other activities in the JDBC palette. For example, DDL commands (for example, CREATE TABLE) are not available using any other activity. If this activity is not part of a transaction group, the SQL statement is committed after the activity completes. If this...

Read More

JDBC Update Activity

The JDBC Update activity performs the specified SQL INSERT, UPDATE, or DELETE statement. If this activity is not part of a transaction group, the SQL statement is committed after the activity completes. If this activity is part of a transaction group, the SQL statement is committed or rolled back with the other JDBC activities in the group at the end of the transaction. If you wish to override the default behavior of transaction groups for certain JDBC activities in a transaction group, you can check the Override Transaction Behavior field...

Read More

JDBC Query Activity

The JDBC Query activity performs the specified SQL SELECT statement. If this activity is not part of a transaction group, the SQL statement is committed after the activity completes. If this activity is part of a transaction group, the SQL statement is committed or rolled back with the other JDBC activities in the group at the end of the transaction. See TIBCO ActiveMatrix BusinessWorks Process Design Guide for more information about creating groups for transactions. If you wish to override the default behavior of transaction groups for certain...

Read More

JDBC Get Connection Activity

The JDBC Get Connection activity retrieves an object reference to a JavaConnectionAccessor object for the specified JDBC Connection from the connection pool. This allows you to use the optimized TIBCO ActiveMatrix BusinessWorks database connection pool instead of specifying database configuration information in your Java code. This database connection can then be used within Java activities to access the specified databa...

Read More

JDBC Connection

The JDBC Connection resource describes a JDBC connection. JDBC connections are used when specifying activities from the JDBC palet...

Read More

JDBC Call Procedure Activity

The JDBC Call Procedure activity calls a database procedure using the specified JDBC connection. If this activity is not part of a transaction group, the SQL statement is committed after the activity completes. If this activity is part of a transaction group, the SQL statement is committed or rolled back with the other JDBC activities in the group at the end of the transaction. If you wish to override the default behavior of transaction groups for certain JDBC activities in a transaction group, you can check the Override Transaction Behavior...

Read More

List File Activity

The List Files activity returns information about files or directories, or a listing of all the files in the specified directo...

Read More

Copy File Activity

The Copy File activity allows you to copy files and directories to a new locati...

Read More

Remove File Activity

The Remove File activity removes the specified file. This activity can also remove empty directories. If a directory that is not empty is specified, an exception is thro...

Read More

Rename File Activity

The Rename File activity is used to rename or move files. This activity can also rename directories, but you cannot use this activity to move a directory to a new locati...

Read More

Wait for File Change Activity

The Wait for File Change activity waits for a file creation, modification, or deletion event to occur during process execution. When this activity is executed, the process instance suspends and waits for the specified change to occur before resumi...

Read More

File Poller Activity

The File Poller process starter polls for files or directories with the given name and starts a process when the specified change (creation, modification, deletion) is detect...

Read More

Write File Activity

The Write File activity writes content to the specified fi...

Read More

Read File Activity

The Read File activity is used to read a file and place its contents into the activity’s outp...

Read More

Create File Activity

Create File Activity 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. Explaination: Create file activity creates a new file or directory with the specified name and even we can provide the contents of the file when creating a file. Specify the File location path in input as at filename. example: "c:\naveen\abc.txt" Points to Remember in Configuration: In Configuration, we have some fields to remember Overwrite: Check this field to overwrite the...

Read More

What is EAI?

Today, Number of organizations fitted with different types of open and proprietary systems. Each with its own development, database, Networking and operating system, thus creating a heterogeneous environment. EAI has come as a boon for enterprise architects to set right everything, which today's enterprises face. EAI has become a sophisticated set of procedures with newly refined technologies, such as middleware and message brokers that allow users to tie systems together using a common glue...

Read More

What is Tibco?

TIBCO: The Information Bus Company (Middleware) In data - level Integration, changes propagated from dependent systems bypass the integrated application, so all inserts, updates, and deletes are done to data that the integrated application accesses. UI level Integration ties integration logic to user interface code. UI - level integration is scripting or proxy - based. Scripting - based UI - level integration embeds integration code into the UI component events, common with client/server...

Read More