Guys, please give me feedback about the site and about info

Guys, please give me feedback about the site and about info.. what more u r expecting... and what more u r looking for... so that i can share more...

Some of the Useful Questions...

File, JDBC, XML Palette


1.
  What activities are required to Create, Copy & Delete a File?
“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.
“Copy File” Activity - The Copy File activity allows you to copy files and directories to a new location.
“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 thrown.
2.
What activities are required to Read, Write & Rename Files?
“Read File” Activity - The Read File activity is used to read a file and place its contents into the activity’s output.
“Write File” Activity - The Write File activity writes content to the specified file.
“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 location.
3.
What is the use of “Data Format” Activity?
The Data Format resource contains the specification for parsing or rendering a text string using the Parse Data and Render Data activities. This shared configuration resource specifies the type of formatting for the text (delimited columns or fixed-width columns), the column separator for delimited columns, the line separator, and the fill character and field offsets for fixed-width columns. You must also specify the data schema to use for parsing or rendering the text.
4.
What are the two types of Data Format supported by TIBCO?
· Delimiter separated
· Fixed format
5.
What is the use of “Field Offsets” in the Data Format Activity?
When processing “Fixed Format” text, you must specify the line length and the column offsets. This allows a Parse Data or Render Data activity to determine where columns and lines begin and end. The Field Offsets tab allows you to specify the format of fixed-width text.
6.
What is the “Parse File” & “Render File” Activity?
“Parse File” Activity – The Parse Data activity takes a text string or input from a file and processes it, turning it into a schema tree based on the specified Data Format shared configuration.
“Render File” Activity – The Render Data activity takes an instance of a data schema and renders it as a text string. The schema processed is based on a specified Data Format shared configuration.
7.
What is the “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 detected.
8.
What is the “Wait For Change” Activity used for?
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 resuming.
9.
Which Activity is used to create a Database table?
SQL Direct
10.
Which Activities are used to execute a stored procedure or a statement?
“JDBC Call Procedure” is used to execute a stored procedure.
“SQL Direct” is used to execute a database statement ( Create, Alter, Delete etc.)
11.
Which activity is used to establish a connection to a database ?
JDBC Connection
12.
What are the steps need to establish a database connection?
1. Add “JDBC Connection” from the JDBC Palette to the project
2. Set the “Connection Type” to JDBC
3. Select the “JDBC Driver” form the Drop Down List Box (ex: Oracle)
4. In the “Database URL”, set the “host-name”, “port-number” and “database-name”
5. Set the Username & Password for the database
6. Test the connection
13.
How do you add or retrieve a record form a database?
“JDBC Query” is used to execute select statement to retrieve records from a database
“JDBC Update” is used to add records to a database via insert statement
14.
What is the use of “Fetch” in the “JDBC Query” Activity?
The Fetch button on the “JDBC Query” activity allows you to synchronize the activity with the contents of the database. If you do not click the Fetch button before applying your changes, TIBCO ActiveMatrix BusinessWorks displays an error dialog prompting you to first fetch the output schema.
15.
Can we use JNDI to connect to a database instead of JDBC?
We can used the “JDBC Connection” Activity to use the JNDI Context (in the “Connection Type” Dropdown box) instead of a JDBC Connect to establish a database connection
16.
Which activity is used to create a XML Schema?
“Schema” form the “XML Tools” palette is used to define the XML Schema
17.
What is XML Element & Attribute?
XML Elements XML Elements contain the opening and closing tags, child elements, and data.


(Ex:


Robert
A+
)
XML Attribute


An attribute appears within the opening tag of an element. XML requires that all XML attributes have a value. This means all attributes have to be equal to something! In the following example active="true" is the attribute.


(Ex:
Robert
A+
)
18.
What is the use of “Transform XML” Activity?
The Transform XML activity allows you to transform an input XML document into the output specified by the given XSLT File shared configuration resource. Normally, transformation of data occurs by mapping process variables to an activity’s input and applying XPath expressions to perform any transformation. If you have an XSLT file that you are using for transformations, or if an outside source supplies an XSLT file, this activity allows you to use the XSLT file instead of manually creating the mappings.
19.
What is Parse XML activity?
The Parse XML activity takes a binary XML file or an XML string and processes it, turning it into an XML schema tree based on the XSD or DTD specified. The preferred way to parse XML files is to use a Read File activity set to binary mode to read the XML file. Then pass the binary file contents to the Parse XML activity.
20.
What is Render XML Activity?
The Render XML activity takes an instance of an XML schema element and renders it as a stream of bytes containing XML  or an XML string. The schema is processed based on the XSD file specified.