Here you can find Sterling Integrator Interview Questions and Answers.
In this Sterling Integrator Interview Questions and Answers section you can learn and practice Sterling Integrator Interview Questions and Answers to improve your skills in order to face technical inerview by IT companies. By Practicing these interview questions, you can easily crack any Sterling Integrator interview.
AllIndiaExams provides you lots Sterling Integrator Interview Questions and Answers with proper explanation. Fully solved examples with detailed answer description. All students, freshers can download Sterling Integrator Interview Questions and Answers as PDF files and eBooks.
You no need to worry, we have given lots of Sterling Integrator Interview Questions and Answers and also we have provided lots of FAQ's to quickly answer the questions in the Sterling Integrator technical interview.
What are the Advantages of IBM Sterling B2B Integrator ?
Sterling B2B Integrator is designed to be configured strategically around the specific processes crucial to your company's success. Its systematic and managed approach supports your integration requirements for both transaction-oriented and batch processes, and works with both pre-existing Electronic Data Interchange (EDI) protocols and Internet-based XML protocols. You can enable your existing systems to integrate past, present, and future technologies and practices
Sterling B2B Integrator 5.2 System Requirements ?
System requirements for IBM® Sterling B2B Integrator vary with your business needs and system environment. Contact your Sterling B2B Integrator sales representative to help you evaluate performance and system usage requirements. Contributing factors include (but are not limited to) the following: 1. Number of transactions processed. 2. Amount of data being transferred. 3. Whether you run Sterling B2B Integrator with or without perimeter servers. 4. Whether your environment is clustered (multiple node) or non-clustered (single node). The following sections list the platforms and databases that are supported by Sterling B2B Integrator: 1. Platforms 2. Databases The following sections list minimum system requirements, and other information,needed to install and run Sterling B2B Integrator on particular platforms: 1.IPv6 Capabilities 2.UNIX/Linux Requirements 3.Windows Requirements 4.iSeries Requirements The following sections list additional information that is needed to install and run Sterling B2B Integrator: v JCE Requirements (All Platforms) 1.JDBC Driver Requirements (All Databases) 2.Perimeter Server Requirements (UNIX/Linux and Windows) 3.Internet Browser and Plugin Requirements (All Platforms) 4.Map Editor and Graphical Process Modeler System Requirements 5.Supported Third Party Software
What's New in Sterling B2B Integrator ?
Sterling B2B Integrator 5.2 Enhancements Soft Stop of Sterling B2B Integrator Sterling B2B Integrator 5.2 now has the ability to gracefully stop the system—allowing existing processes the opportunity to complete, be transferred to other cluster nodes or be saved for resumption after restart. This saves time by eliminating the need to manually examine and resume processes after a restart. The softstop functionality combined with a rolling restart of nodes will allow for minimal interruption of processing. You can initiate the soft stop command from either the UI or from the command line. The soft stop UI provides the ability to interactively step through the shutdown process allowing for: 1. The transfer of a running business processes to other cluster nodes or to the database for recovery 2. The ability to control the completion of queued business processes on the local node 3. The ability to show the status of adapter activity and open sessions Performance Tuning Utility Sterling B2B Integrator 5.2 includes an updated utility that calculates the tuning parameter values for you. You can use the Performance Tuning utility to tune and configure Sterling B2B Integrator according to your needs. Queue settings can be changed, as well as memory allocations, JVM settings, and pool settings. Additionally, future Sterling B2B Integrator patches will not overwrite the performance tuning changes made by the Performance Tuning utility. Sterling B2B Integrator License Files You no longer need to contact IBM to acquire a license file prior to product installation. Product functionality is grouped into large offering areas. During installation, you must select the product offerings applicable to your purchase and a bundled license file will be used. Sterling Standards Library 8.0 Applying Sterling B2B Integrator, Release 5.2 automatically includes Sterling Standards Library 8.0. Your specific standards implementation will depend upon the terms of your licensing agreement. Sterling Standards Library version 8.0 adds support for the following X12 5010 HIPAA transactions: v 5010 220A1 834 v 5010 221A1 835 v 5010 222A1 837 v 5010 223A2 837 v 5010 224A2 837 v 5010 279A1 270 v 5010 279A1 271
Sterling B2B Integrator for Financial Services Overview ?
Sterling B2B Integrator for Financial Services is the solution that enables banks, broker-dealers, investment managers, and market infrastructures in payments, securities, treasury and trade to optimize financial sector process integration—both internally and with external enterprises and communities—for secure end-to-end management of financial data exchange. This product leverages components of Sterling B2B Integrator to enable file transfer and translation capabilities using financial-industry transport types and messaging formats. Enhanced reporting and notification tools provide improved insight into business processes, furthering your goal to create a sustainable competitive advantage. Available components include pre-built support for financial standards and protocols, services, adapters, code lists, pre-loaded DTDs and schemas in the Map Editor, and tools such as Reporting Services and the SWIFT Editor. With Sterling B2B Integrator for Financial Services, you can integrate existing systems with a gateway solution offering visibility and simplified error/exceptions management, including routing of files and messages into legacy systems. This complete and streamlined automation of processes can help you reduce costs, increase revenue, and improve customer satisfaction while leveraging Sterling B2B Integrator security features to provide secure, non-repudiated exchange of B2B information. Depending on your needs, Sterling B2B Integrator for Financial Services can be a simple file transfer solution for financial documents, a translation engine supporting financial standards and those of your back office systems, or a complex full gateway solution involving all types of file transfer, intelligent routing, translation, and transmission activities. Your solution can be configured to be fully convertible between payments networks, platform agnostic, and deployed behind the corporate firewall. If needed, IBM® Support can help you customize Sterling B2B Integrator for Financial Services to enable full payload inspection and customized visibility into documents processed. Sterling B2B Integrator for Financial Services is highly scalable to suit your evolving needs. Sterling B2B Integrator for Financial Services makes process continuity of business finance part of your organization's integrated value chain, shared by the business partners and financial institutions that make up your B2B communities.
Sterling B2B Integrator for Financial Services Supported Standards and Protocols ?
The diversity of communications systems and standards makes it difficult to respond to customer demands for better and more comprehensive service. Sterling B2B Integrator for Financial Services' built-in support for financial standards reduces the information technology costs involved in custom coding and enables you to more cost-effectively integrate disparate systems to overcome information silos. Pre-defined financial standards are automatically loaded into the Sterling B2B Integrator Map Editor graphical mapping tool, including code lists. With Sterling B2B Integrator for Financial Services, you can translate and move data among many different environments. The following financial services standards are supported, but are not limited to: 1. FIX, FIXML, FpML, IFX 2. ISO 8589, 20022, and 150222, including TWIST 3. XBRL 4. NACHA ACH 5. SWIFTNet FIN MT messages (2005 & 2006) and SWIFTNet MX messages (including those specific to SWIFT Solutions) 6. TARGET2 7. EBA STEP2 Sterling B2B Integrator for Financial Services supports batch and real-time protocols, including FTP and FTP/S; SSH/SFTP; Sterling Connect:Direct®; HTTP/s; dial-up communications; SMTP; SOAP, MQ, JMS, and MSMQ messaging; AS2, and RosettaNet. In addition to the full suite of available Sterling B2B Integrator protocol support, Sterling B2B Integrator for Financial Services also supports the SWIFTNet InterAct and FileAct protocols for financial services communications.
What is Managed File Transfer (MFT) ?
According to Gartner “Managed file transfer software and services enable users to manage and monitor file transfers within and between organizations.” In this definition Gartner uses “manage” and “monitor” to highlight and explain the key differences between MFT and FTP. Manage – means to manage all file transfers using one interface (one place) across all business units, operations, systems, applications, partners, etc. Monitor – means to monitor all file transfers in one centralized location which in turn means better governance, compliance and reduced IT costs
About IBM Sterling File Gateway ?
Sterling File Gateway is an application for transferring files between partners by using different protocols, conventions for naming files, and file formats. Sterling File Gateway uses the Sterling B2B foundation, which includes IBM® Sterling B2B Integrator, Sterling Standards, and the Sterling platform. The capabilities that are delivered are similar to the features found in Advanced File Transfer and IBM Sterling Connect:Enterprise® for UNIX, plus new functionality.Use Sterling File Gateway for movement of large and high-volume file transfers, with end-to-end visibility of file movement in a process-oriented and highly-scalable framework. This framework alleviates file transfer challenges, such as protocol and file brokering, automation, and data security. Sterling File Gateway supports integration with: Sterling B2B Integrator Mailbox IBM Sterling Control Center IBM Sterling Secure Proxy IBM Sterling Connect: Direct® for UNIX server products IBM Sterling Connect: DirectIBM WebSphere® MQ File Transfer Edition Sterling File Gateway, which is delivered on the Sterling B2B Integrator platform with a unique application URL, provides single sign-on access to the Sterling B2B Integrator administrative console through menu selection.
What are the features of Sterling File Gateway ?
File/File name Transformations – Mapping of input to output file names; system-wide, group, and partner-specific policies; common file processing tasks such as compression/decompression, PGP encryption/decryption, and signing. File Transfer Visibility – Events are recorded for monitoring and reporting; detailed tracking for input-output file structure processing and dynamic route determination; ability to view and filter Sterling File Gateway data flows for all users. Replay/Redeliver – One click replay/redeliver capability that allows users to reprocess one or multiple transmissions from the beginning or to resend one or multiple processed files to specific delivery destinations. Notifications – Partners and operators can subscribe to be notified about events by email. Predefined business processes – Define common behaviors in file-transfer scenarios, reducing the need for customization. Extensibility – Custom event codes, protocols, facts, and consumer identification policies can be added to support unique scenarios. Broad Communications Protocol Support – FTP, FTP/S, SSH/SFTP, SSH/SCP, IBM® Sterling Connect:Direct®, and IBM WebSphere® MQ File Transfer Edition are supported upon installation, and additional protocols (such as AS2, AS3, or Odette FTP) may be configured through use of the extensibility feature. Partner Interface (myFileGateway) – Web browser-based interface that enables partners to upload/download files, subscribe to notifications of events, manage passwords, search and view file transfer activity, and generate reports about file transfer activity. Flexible Mailbox Structures – Ability to specify mailbox structures that leverage pattern matching policies and specify attributes that must be true of all partners or a subset of partners. Dynamic Routing – Consumer derived at run-time, either through mailbox structure, file name, business process-derived consumer name, or map-derived consumer name. Partner On boarding – Easy-to-use graphical user interface to onboard partners and configure the various combinations of communication protocols to enable Sterling File Gateway operations.
How Sterling B2B Integrator and Sterling File Gateway work together ?
Sterling File Gateway utilizes the Sterling B2B foundation, which includes Sterling B2B Integrator, Sterling Standards, and the Sterling platform, to deliver capabilities similar to those found in Sterling Advanced File Transfer and Sterling Connect:Enterprise® for UNIX, while adding new features and functionality. Within Sterling File Gateway, Sterling B2B Integrator is known as the B2B Console, and is accessed from the Tools menu. Administrative functions such as creating and managing user accounts, permission groups, and security keys for Sterling File Gateway are handled in Sterling B2B Integrator. Sterling File Gateway utilizes the communication adapters of Sterling B2B Integrator, which include the following: FTP Server adapter FTP Client adapter SFTP Server adapter SFTP Client adapter HTTP Server adapter HTTP Client adapter Connect:Direct Server adapter Command Line adapter 2 (for PGP)
About the Web application myFileGateway ?
Partners send and retrieve files from the Web application myFileGateway. To log in to myFileGateway, a valid user account is required. This user account is created when a Route Provisioner onboards the partner. From within myFileGateway, partners can: Upload or download files. Search for routes they participated in. View recent activity and status for file transfers they participated in. Generate reports for activity they participated in. Change their password. Subscribe to notifications.
What is BPML ?
Business process modeling language is an xml based language for describing business process designed by the business process management initiative. BPML activities provide the directions for how data should be handled.
What is GPM ?
Graphical process modeler is a stand alone graphical interface tool used in sterling integrator to create and modifying a business process.
What is process data ?
Process data is nothing but the information and the primary document for all the services in a business process in the form of XML. To access process data we use xpath expression language.
What is Correlation ?
Correlation is used for document tracking. Correlation data enable you to record document, a specific correlation parameters generated during the translations by the correlation service or by the document tracking function.
What is xpath ?
Xpath is an expression language used to navigate the xml data.
What is EDIINT ?
EDI over the Internet (EDIINT) is a working group of the Internet Engineering Task Force (IETF). Formed in February of 1996, EDIINT was chartered by the IETF to create a set of secure protocols for sending EDI data over the Internet. The two EDIINT standards that have been certified are AS1 and AS2.
How Does AS2 Work ?
AS2 provides an Internet solution for securely exchanging EDI over the Internet using Multipurpose Internet Mail Extensions (MIME) and the hypertext transmission protocol (HTTP) instead of the simple mail transport protocol (SMTP) as the transport protocol. AS2 specifies the means to connect, deliver, validate, and reply to (receipt) data in a secure and reliable way. AS2 does not concern itself with the content of the EDI document, only the transport. AS2 essentially creates a wrapper around EDI flat files that enables sending them over the Internet, instead of using a dial-up connection to a value-added network (VAN). AS2 is a real-time technology that provides security and encryption around the HTTP packets.
What are the benefits of Using AS2 ?
AS2 provides faster, almost instantaneous data transfers directly to your network and reduces the points of failure in data transmissions. Using AS2 eliminates day-to-day value-added network (VAN) charges and long distance dial-ups. AS2 also provides increased reliability and sped, improving supply-chain efficiency. Listed below are some of the main benefits of using AS2: • 24x7 availability • Designed to push data securely and reliably over the Internet • Fast and reliable connectivity • Encryption ensures that only the sender and receiver can view the data • Digital signatures ensure authentication • AS2 detects if the document was altered during transmission • Non-repudiation of receipt confirms that the intended party received the data • Faster turn-around time for business processes
What is Required to Exchange Data Using AS2 ?
• A dedicated persistent Internet connection • A web server with your EDIINT software
What is the Risk for Using AS2 ?
There is no more risk involved with transactions over AS2 then there would be with any form of normal e-Business transactions. If there is any risk with AS2, it is far outweighed by the cost savings implicit in its operation.
What are the rules available in map editor?
1. Pre session rule: In pre session rule we can declare and initialize the variables and also we can write the conditions as per the business rules. It will get executed at the beginning of the map translation. The variables we declare in the pre session rule are having global scope. 2.Loop extended rule: Loop extend rule is applied to the record or segment level. We have on begin and on end rules in loop extended rule. For looping records or groups on begin rule executed once for each occurrence of the loop at the beginning of each loop. For looping records or groups on end rule executed once for each occurrence of the loop at the end of each loop. 3. Extended rule: In extended rule we can write the business rules using functions available in the SI map editor and we can declare the variables. The variables we declare in the extended rule are having local scope. 4.Standard rule: We can apply standard rules to the field level using predefined functions available in the standard rule. Those predefined functions are 1.Select 2.Update 3.Use system variable, it enables you to set a variable that maps current date and time to the selected field. The selected map component must have a data type of Date Time. 4.Use constant, it enables you to move a constant value to the specified field. 5.Use accumulator, it gives access to a set of numeric variables that you can manipulate using numeric operations and then transfer to fields. 6.Loop count, it enables to count number of times a loop is repeated if the field is the part of the loop. 7.Use code. It enables to use code lists to validate the content of a field and use as a reference to look up an associated description for a field. 5. Post session rules: It is same as pre sessions but only difference is pre session rules will get executed at the beginning of the translation but post session rules will get executed after the translation.
Explain the execution of a map in SI map editor?
In map editor, what are all the conditions and variables listed in the pre session rule that will execute first because presession rules will get execute at the beginning of the translation. And then it will check the group or record if is there any on begin rule that will execute next. Then it goes in to fields in the record, if is there any Standard rule/ Extended rule we apply for the field that will execute Extended rule for the field will be executed. At the end of the record, on end rule will be executed if we write any conditions there.
Explain the process in migration map development?
We will analyse the business rules on the mapping for the customer in the production system then we will create the specification. We will test the map by taking existing production system input file and run that in SI then compare existing production system to corresponding output file. At last SI generates output.
When to use temporary records and fields ?
Use temporary records and fields When you cannot use a simple link or if you must extract only specific occurrences of a record from your data file. If you must map from a repeating map component to a single map component, or vice versa. If the Input hierarchical level in a map does not match the Output hierarchical level. If you only want to populate an Output field with data if a specified qualifier is used or if specific criteria is met. If you must use extended rules in addition to creating temporary records and fields.
Where to use temporary records and fields ?
You can add temporary records and fields at any hierarchical level in a map. However, when you use temporary records and fields, you must locate them after the map component that contains the necessary data. You must use a record tag that you would never receive in your Input file, and the recommended default is $$$. If you are creating a temporary record for an XML file, use the tag XXX, because $$$ is not permitted as a tag in XML. The translator does not run standard or extended rules on temporary records.
Sterling Integrator Interview Questions and Answers
Sterling File Gateway Interview Questions
Sterling Secure Proxy & Control Center
SI Services and Adapters Interview Questions
SI Protocols Interview Questions
Sterling Integrator EDI Mapping