IBM Websphere Interview Questions Part 2

Q.What are OConv () and Iconv () functions and where are they used?
A.
1.IConv() - Converts a string to an internal storage format
2.OConv() - Converts an expression to an output format.

Q.How did u connect to DB2 in your last project?
A.Using DB2 ODBC drivers.

Q.Do u know about METASTAGE?
A.MetaStage is used to handle the Metadata which will be very useful for data lineage and data analysis later on. Meta Data defines the type of data we are handling. This Data Definitions are stored in repository and can be accessed with the use of MetaStage.

Q.Do you know about INTEGRITY/QUALITY stage?
A.Qulaity Stage can be integrated with DataStage, In Quality Stage we have many stages like investigate, match, survivorship like that so that we can do the Quality related works and we can integrate with datastage we need Quality stage plugin to achieve the task.

Q.Explain the differences between Oracle8i/9i?
A.
1.Oracle 8i does not support pseudo column sysdate but 9i supports
2.Oracle 8i we can create 256 columns in a table but in 9i we can upto 1000 columns(fields)

Q.How do you merge two files in DS?
A.Either use Copy command as a Before-job subroutine if the metadata of the 2 files are same or create a job to concatenate the 2 files into one if the metadata is different.

Q.What is DS Designer used for?
A.You use the Designer to build jobs by creating a visual design that models the flow and transformation of data from the data source through to the target warehouse. The Designer graphical interface lets you select stage icons, drop them onto the Designer work area, and add links.

Q.What is DS Administrator used for?
A.The Administrator enables you to set up DataStage users, control the purging of the Repository, and, if National Language Support (NLS) is enabled, install and manage maps and locales.

Q.What is DS Director used for?
A.datastage director is used to run the jobs and validate the jobs.we can go to datastage director from datastage designer it self.

Q.What is DS Manager used for?
A.The Manager is a graphical tool that enables you to view and manage the contents of the DataStage Repository

Q.What are Static Hash files and Dynamic Hash files?
A.As the names itself suggest what they mean. In general we use Type-30 dynamic Hash files. The Data file has a default size of 2Gb and the overflow file is used if the data exceeds the 2GB size.

Q.What is Hash file stage and what is it used for?
A.Used for Look-ups. It is like a reference table. It is also used in-place of ODBC, OCI tables for better performance.

Q.Have you ever involved in updating the DS versions like DS 5.X, if so tell us some the steps you have taken in doing so?
A.Yes. The following are some of the steps; I have taken in doing so:
1.Definitely take a back up of the whole project(s) by exporting the project as a .dsx file
2.See that you are using the same parent folder for the new version also for your old jobs using the hard-coded file path to work.
3.After installing the new version import the old project(s) and you have to compile them all again. You can use 'Compile All' tool for this.
4.Make sure that all your DB DSN's are created with the same name as old one's. This step is for moving DS from one machine to another.
5.In case if you are just upgrading your DB from Oracle 8i to Oracle 9i there is tool on DS CD that can do this for you.
6.Do not stop the 6.0 server before the upgrade, version 7.0
install process collects project information during the upgrade. There is NO rework (recompilation of existing jobs/routines) needed after the upgrade.

Q.Did you Parameterize the job or hard-coded the values in the jobs?
A.Always parameterized the job. Either the values are coming from Job Properties or from a ‘Parameter Manager’ – a third part tool. There is no way you will hard–code some parameters in your jobs. The often Parameterized variables in a job are: DB DSN name, username, password, dates W.R.T for the data to be looked against at.

Q.Explain about IBM Web Sphere edge server?
A.Web sphere edge server is used to improve the performance of web based systems. It can be used as forward or proxy server. Basically four components are present in the web sphere they are Network dispatcher, Caching proxy, Content distribution and application service at the edge.

Q.Explain about extended deployment?
A.Web sphere application server extended deployment increases the functionality of the server in two main areas they are manageability and performance. Dynamic virtualization between servers is possible with the help of XD. A stand alone distributed cache was added to it under the performance header, it is known as Object Grid.

Q.Explain about the security features present in WAS?
A.Security model for web sphere is primarily based on JAVA EE security model. It also depends upon the operating system. User authentication and authorization mechanisms are also provided in WAS. Light weight third party authentication mechanism is the main security feature present in WAS.

Q.Explain about asymmetric clustering?
A.Asymmetric clustering applications are primarily used in electronic trading systems employed in banks. Some of the features are, partitions can be declared during run time and are usually run on a single cluster at a time. Work specific to a particular can be routed to that cluster.

Q.Explain the various Administrator benefits using Web sphere?
A.Web sphere almost reduces the work of server administrator as he can manage load on servers efficiently without any hassles. It also gives him flexibility to divide the load and applications among different server farms. He can also predict about the incoming load on servers. Email alerts, restart options, memory leak detection, etc.

Q.Explain about caching proxy of IBM Web sphere Edge sphere?
A.A caching proxy can be configured in forward direction or as a proxy. Content requested by the user is cached by edge before sending or adhering to the query. Page fragments arising from JSP or servlets are cached by Edge and the caching process is slow. Performance and scalability of J2EE applications can be increased by edge.
.
Q.Explain about the network deployment feature present in WAS?
A.Managing singletons will be a thing of the past and it also provides hot recovery of singletons which makes you forget about your GC collected singletons. Transaction logs can stored on a shared file system. For clustering run time operations deployment manager`s role was eliminated. J2EE failover support and cell configuration support is also present.

Q.Explain about IBM web sphere integration developer?
A.Web sphere integration developer provides an IDE to build applications based on service oriented architecture. Web sphere process server and web sphere ESB were built with WID. WID was built with RAD Eclipse based technology.

Q.Explain about compute Grid?
A.Compute grid is also known as Web sphere batch. Web sphere extended deployment offers a Java batch processing system called as Compute Grid. This forms an additional feature to Web sphere network environment. Various features are provided which help a developer to create, manage and execute batch jobs. Job scheduler, xJCL, batch container and batch programming controller.

Q.Explain about web sphere MQ Real time transport?
A.This feature is very useful in instant messaging across different clients through intranet and internet. This supports high volume and high performance across different clients. It uses the concept of light weight transport which is again based on IP rather than the queue process.

Q.Explain about Web sphere MQ JMS Provider?
A.Web sphere MQ and Web Sphere Business integration manager Broker are very useful in providing Java messaging services to wide range of clients (publisher –subscribe, point to point). Java classes are chiefly responsible for translating the API calls to API`s defined by web sphere. It is very useful to have knowledge of Web sphere MQ for proper configuration.

Q.Explain the attribute CHANNEL in web sphere MQ?
A.CHANNEL specifies the name of the server connection channel. Generally this is Web Sphere MQ network abstraction. The default standard used by CHANNEL is SVRCONN which is the server connection channel. This server is generally used to communicate to the queue manager by the client.

Q.Is the naming of connection factory independent of the name specified by JMS client?
A.Yes, the naming of connection factory is independent of the name specified by JMS client. This is made possible by WAS (Web sphere application server) with its resource references. It isolates the application from object names. This feature is important because it gives us the flexibility to change the administered object without changing the JMS client code.

Q.Are there any differences between Weblogic and Websphere?
A.Webpshere tends to focus more on integration, connectivity and web services. it has rich implementation of J2EE, better performance, more extensive integration and transaction management. In terms of trnsaction weblogic is having default transaction attribute as ’supports’, but websphere does not have any default transaction attribute. Websphere is from IBM and Weblogic is from BEA.

Q.How to implement JDBC-ODBC bridge driver (Type 1) in Websphere?
A.If you use JDBC type (I) driver you dont need to add any driver in websphere. you simply created DSN and use it locally, same we use java class, if you use Type(2) and Type(4) so first go to admin console then go to connection, then add driver there fill other info like conn. 12:05 PM 11/9/2009size, uname pass, max conn. and connect it to you applications.

< Prev		Next >

HotRecruiter.Com