If you're looking for TIBCO ADB Adapter Interview Questions for Experienced or Freshers, you are in right place. There are a lot of opportunities from many reputed companies in the world. According to research, the average salary for a TIBCO ADB Adapter ranges from approximately $61,739 pa. So, You still have the opportunity to move ahead in your career in TIBCO ADB Adapter. Mindmajix offers Advanced TIBCO ADB Adapter Interview Questions 2021 that helps you in cracking your interview & acquire a dream career as a TIBCO ADB Adapter Administrator.
Subscribe to our youtube channel to get new updates..!
TIBCO ADB Adapter Interview Questions and Answers
Q1. How can you fine-tune an ADB Adapter? What are the different parameters that can be used?
a) We can use publish by value or publish by reference for high speed and data type support like oracle long respectively.
b) Can use polar or alerter for frequent and infrequent data changes respectively.
c) Adb.PollingInterval, _ADB.DUPDECT.adapter_instance_name parameters can be used to do flow control and avoid duplication respectively.
Q2. What is the quality of services we can have in adapter publishing services?
Ans: RV: reliable, certified, transactional
Q3. What are the wire formats we can have in adapter publishing services?
Ans: Wire formats:
a) RV: active enterprise message, RV message, XML message.
b) JMS: XML message
Q4. Explain the internal functioning of ADB publication service?
Ans: When we configure ADB publishing service it creates Publishing table for source table, Trigger acts as a bridge between source and publishing table. Whenever data is being inserted/updated/deleted from source table, it will be inserted into publishing table by means of trigger. ADB has another component called polling agent. Polling agent will be keep looking for new inserts into publishing table and if it finds any then converts the record in p table into the specified wire format and publishes on specified quality of service.
Q5. What is publish by value and publish by reference? Explain the pros and cons?
Ans: Publish by value: In this type, the changes in the source table are reflected in the p_table and the data s taken from there. It's used when high speed is required. It does not support data types like oracle long.
publish by reference: In this type, the data is directly taken from the source table where only the primary key will come from p_table. It allows data types like oracle long. Loss of changes in the source table can be lost because of the waiting time. (This can be avoided using alerter).
Q6. What are the types of message transfers in file adapters?
Ans: Record transfer: To integrate file systems to the TIBCO AE environment.
Simple file transfer: To transfer files to other TIBCO adapters.
Q7. Can we filter the records from publishing when they get updated in the source table? (Data from all regions are coming into the table but I want to publish only New York data)
Ans: Yes – By modifying the trigger we can only insert the New York data into the publishing table
Q8. Can we limit the number of columns to be published from the source table?
Ans: Yes, using the user field in the adapter publishing table tab. Just uncheck the columns you don't want to use.
Q9. Can we publish parent and child table information by using a single adapter configuration and how?
Ans: Yes, in the adapter publisher table tab create a parent table first by lookup and then add the child table using the add child tab then click on the child table column to specify the foreign key then to establish a relationship between the primary key of the parent and the foreign key of the child go to the column in the child table and specify the primary key of the parent table.
In the subscription service, the destination table is created and the child table mapping tab will have the child table on the left mapped with the parent table on the right.TIBCO ADB Adapter Interview Questions