tag:blogger.com,1999:blog-87375013051739303152024-03-08T16:21:46.001-08:00Techies pointMost wanted Technologies likeJava(ADVANCED JAVA, CORE JAVA), ,SAP(ABAP, SD, PP, MM, BASIS, BW AND SO ON) , ,ORACLE,DATAWAREHOUSING(DATASTAGE,INFORMATICA, COGNOS, BUSINESSOBJECTS,INFORMATICA,ABNITIO, AND SO ON.,,) and all AND THEIR HISTORY AND SO ON.,,Its For Techieshttp://www.blogger.com/profile/04854561330824512840noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-8737501305173930315.post-18269100844461361862008-07-27T10:42:00.000-07:002008-07-27T10:44:52.406-07:00<h1 style="color: rgb(102, 0, 0);"><span style="font-size:130%;">Datastage solutions, knowledge base, FAQ and best practices</span></h1> <p class="MsoNormal"><o:p> </o:p></p> <h2 style="color: rgb(0, 0, 153);">1. General Datastage issues</h2> <p class="MsoNormal">1.1. What are the ways to execute datastage jobs?</p> <p class="MsoNormal">1.2. How to invoke a Datastage shell command?</p> <p class="MsoNormal">1.3. How to stop a job when its status is running?</p> <p class="MsoNormal">1.4. How to run and schedule a job from command line?</p> <p class="MsoNormal">1.5. How to release a lock held by jobs?</p> <p class="MsoNormal">1.6. User privileges for the default DataStage roles?</p> <p class="MsoNormal">1.7. What is a command to analyze hashed file?</p> <p class="MsoNormal">1.8. Is it possible to run two versions of datastage on the same pc?</p> <p class="MsoNormal">1.9. How to send notifications from Datastage as a text message (sms) to a cell phone</p> <p class="MsoNormal"><o:p> </o:p></p> <h2 style="color: rgb(0, 0, 153);"><br /></h2><h2 style="color: rgb(0, 0, 153);">2. Datastage development and job design</h2> <p class="MsoNormal">2.1. Error in Link collector - Stage does not support in-process active-to-active inputs or outputs</p> <p class="MsoNormal">2.2. What is the DataStage equivalent to like option in ORACLE</p> <p class="MsoNormal">2.3. what is the difference between logging text and final text message in terminator stage</p> <p class="MsoNormal">2.4. Error in STPstage - SOURCE Procedures must have an output link</p> <p class="MsoNormal">2.5. How to invoke an Oracle PLSQL stored procedure from a server job</p> <p class="MsoNormal">2.6. Is it possible to run a server job in parallel?</p> <p class="MsoNormal">2.7. Error in STPstage - STDPROC property required for stage xxx</p> <p class="MsoNormal">2.8. Datastage routine to open a text file with error catching</p> <p class="MsoNormal">2.9. Datastage routine which reads the first line from a text file</p> <p class="MsoNormal">2.10.How to test a datastage routine or transform?</p> <p class="MsoNormal">2.11.When hashed files should be used? What are the benefits or using them?</p> <p class="MsoNormal">2.12.How to construct a container and deconstruct it or switch between local and shared?</p> <p class="MsoNormal">2.13.Corresponding datastage data types to ORACLE types?</p> <p class="MsoNormal">2.14.How to adjust commit interval when loading data to the database?</p> <p class="MsoNormal">2.15.What is the use of INROWNUM and OUTROWNUM datastage variables?</p> <p class="MsoNormal">2.16.Datastage trim function cuts out more characters than expected</p> <p class="MsoNormal">2.17.Database update actions in ORACLE stage</p> <p class="MsoNormal">2.18.Use and examples of ICONV and OCONV functions?</p> <p class="MsoNormal">2.19.ERROR 81021 Calling subroutine DSR_RECORD ACTION=2</p> <p class="MsoNormal">2.20.How to check Datastage internal error descriptions</p> <p class="MsoNormal">2.21.Error timeout waiting for mutex</p> <p class="MsoNormal">2.22.ERROR 30107 Subroutine failed to complete successfully</p> <p class="MsoNormal">2.23.Datastage Designer hangs when editing job activity properties</p>Its For Techieshttp://www.blogger.com/profile/04854561330824512840noreply@blogger.com0tag:blogger.com,1999:blog-8737501305173930315.post-34454486395656012102008-06-18T07:53:00.000-07:002008-06-18T08:58:55.260-07:00Spring FrameworkFor More <a href="http://javanetinfo.blogspot.com/"><strong><span style="font-size:130%;">CLick ME</span></strong></a><strong><span style="font-size:130%;"><br /></span></strong><br /><p></p><p></p><p><strong><span style="color:#660000;">Introduction:</span></strong></p><p>The content of this document is not a detailed description on Spring or Hibernate. This document contains how we have used Spring and Hibernate in our project. I have shared most of the learning experiences I have gathered during execution of the project here. Those who have some prior knowledge on J2EE framework would be able to understand these. Our project got executed using JBoss-3.2 server and Hibernate as back end. We have developed our codes in Eclipse-3 platform using Spring framework.<br /><br />Finally the war file was deployed in Linux and it was platform independent.</p><p><strong><span style="color:#660000;">Spring’s MVC Architecture:</span></strong></p><p>Spring’s MVC framework is designed based on Dispatcher Servlet which dispatches requests to respective request-handlers better known as controllers. Spring can bind any object as a command object which will be available directly in the controller class. To do any validation of the form objects, you need a validation class which is provided by this framework.<br /><br />After validation, if you want to send some data to the JSP that can be done via referenceData method. The controller class returns a view name (the JSP name) and a model Map. The model contains all the bean names and corresponding objects you need to send to the view. View names and it’s location is resolved via view Resolver bean provided in the XML mapping.</p><p><strong><span style="color:#000099;">Features of Spring:</span><br /></strong><br />• Clear separation of roles – controller, validator, command object, form object, model object, Dispatcher Servlet, handler mapping, view resolver etc. separate objects for each role.<br /><br />• Powerful and straightforward configuration, easy referencing across contexts of both framework and application classes as beans.<br /><br />• Separate controllers for different scenarios – plain, form, wizard, simple, multiaction.<br /><br />• Customizable binding and validation – binding of any object is possible along with validation after submission of form.<br /><br />• Customizable handler/controller mapping and view resolver – can handle simple requests via URLs or even can intercept a URL, and view resolvers help to locate the actual path of views.<br /><br />• Map model transfer – transfer of any number of objects is possible via model object, no need to set them as request attributes.<br /><br />• Supports Theme and JSTL tags with or without Spring tags.<br /><br /><strong><span style="color:#000099;">Dispatcher Servlet:<br /></span></strong><br />Spring's web MVC framework is a request-driven web MVC framework, designed around a servlet that dispatches requests to controllers and offers other functionality facilitating the development of web applications. Spring's DispatcherServlet does that.The Spring DispatcherServlet has a couple of special beans it uses, in order to be able to process requests and render the appropriate views. These beans are included in the Spring framework and can be configured in the WebApplicationContext, just as any other bean would be configured. Right now, we'll just mention some of them.<br /><br />For most of the beans, defaults are provided so you don't have to worry about configuring them.<br /><br />• handler mappings – for matching the URL and send them to a controllers<br /><br />• controllers – the actual controller beans<br /><br />• view resolver – to find the exact location of the view (JSP)<br /><br />• theme resolver – capable of resolving themes for the application<br /><br />• handlerexceptionresolver – offers functionality to map different exceptions</p><br />For More <span style="font-size:130%;color:#660000;"><a href="http://javanetinfo.blogspot.com/">CLick ME</a></span><span style="font-size:130%;"><br /></span>Its For Techieshttp://www.blogger.com/profile/04854561330824512840noreply@blogger.com0tag:blogger.com,1999:blog-8737501305173930315.post-27115003324606245742008-04-28T23:20:00.000-07:002008-04-28T23:30:09.727-07:00Slowly Changing Dimensions<p> </p><p><strong><span style="color:#660000;">Slowly Changing Dimensions</span></strong><br /></p><p>Dimensions that change over time are called Slowly Changing Dimensions. For instance, a product price changes over time; People change their names for some reason; Country and State names may change over time. These are a few examples of Slowly Changing Dimensions since some changes are happening to them over a period of time.<br /></p><p>Slowly Changing Dimensions are often categorized into three types namely Type1, Type2 and Type3. </p><p>The following section deals with how to capture and handling these changes over time.<br />The "Product" table mentioned below contains a product named, Product1 with Product ID being the primary key. In the year 2004, the price of Product1 was $150 and over the time, Product1's price changes from $150 to $350. With this information, let us explain the three types of Slowly Changing Dimensions.<br /></p><p><strong>Product Price in 2004:</strong></p><p><strong></strong><br />Product ID(PK) Year Product Name Product Price<br />1 2004 Product1 $150<br /></p><p><strong><span style="color:#000099;">Type 1: Overwriting the old values.</span></strong></p><p>In the year 2005, if the price of the product changes to $250, then the old values of the columns "Year" and "Product Price" have to be updated and replaced with the new values. In this Type 1, there is no way to find out the old value of the product "Product1" in year 2004 since the table now contains only the new price and year information.</p><p><strong>Product</strong><br /></p><p>Product ID (PK) Year Product Name Product Price<br />1 2005 Product1 $250</p><p> </p><p><strong><span style="color:#000099;">Type 2: Creating an another additional record.</span></strong></p><p>In this Type 2, the old values will not be replaced but a new row containing the new values will be added to the product table. So at any point of time, the difference between the old values and new values can be retrieved and easily be compared. This would be very useful for reporting purposes.</p><p> </p><p>Product Product ID(PK) Year Product Name Product Price<br />1 2004 Product1 $150<br />1 2005 Product1 $250</p><p> </p><p>The problem with the above mentioned data structure is "Product ID" cannot store duplicate values of "Product1" since "Product ID" is the primary key. Also, the current data structure doesn't clearly specify the effective date and expiry date of Product1 like when the change to its price happened. So, it would be better to change the current data structure to overcome the above primary key violation.Product<br /></p><p>Product ID(PK) EffectiveDateTime(PK) Year Product Name ProductPrice ExpiryDateTime<br />1 01-01-2004 12.00AM 2004 Product1 $150 12-31-200411.59PM<br />1 01-01-2005 12.00AM 2005 Product1 $250</p><p>In the changed Product table's Data structure, "Product ID" and "Effective DateTime" are composite primary keys. So there would be no violation of primary key constraint. Addition of new columns, "Effective DateTime" and "Expiry DateTime" provides the information about the product's effective date and expiry date which adds more clarity and enhances the scope of this table.</p><p>Type2 approach may need additional space in the data base, since for every changed record, an additional row has to be stored. Since dimensions are not that big in the real world, additional space is negligible.</p><p><span style="color:#000099;"><strong>Type 3: Creating new fields.</strong></span></p><p>In this Type 3, the latest update to the changed values can be seen. Example mentioned below illustrates how to add new columns and keep track of the changes. From that, we are able to see the current price and the previous price of the product, Product1.Product<br /></p><p>Product ID(PK) CurrentYear ProductName CurrentProductPrice Old ProductPrice Old Year<br />1 2005 Product1 $250 $150 2004<br /></p><p>The problem with the Type 3 approach, is over years, if the product price continuously changes, then the complete history may not be stored, only the latest change will be stored. For example, in year 2006, if the product1's price changes to $350, then we would not be able to see the complete history of 2004 prices, since the old values would have been updated with 2005 product information.Product<br /></p><p>Product ID(PK) Year Product Name Product Price Old Product Price Old Year<br />1 2006 Product1 $350 $250 2005</p><p> </p><p> </p><p> </p>Its For Techieshttp://www.blogger.com/profile/04854561330824512840noreply@blogger.com0tag:blogger.com,1999:blog-8737501305173930315.post-37372791708514685732008-04-14T23:44:00.000-07:002008-04-14T23:46:16.313-07:00<p> </p><p><strong><span style="font-size:130%;color:#993300;">What is BusinessObjects?</span></strong><br /><br /><a href="http://dwh-businessobjects.blogspot.com/">BUSINESS O</a><a href="http://dwh-businessobjects.blogspot.com/">BJECTS</a> is an integrated query, reporting and analysis solution for business professionals that allows you to access the data in your corporate databases directly from your desktop and present and analyze this information in a BUSINESS OBJECTS document.<br /></p><p>BUSINESS OBJECTS makes it easy to access this data, because you work with it in business terms that are familiar to you, not technical database terms like SQL. You don’t need any knowledge of the database structure or technology.<br /></p><p>Once you’ve used <a href="http://dwh-businessobjects.blogspot.com/">BUSINESS OBJECTS</a> to access the data you need, you can present the information in reports as simple as tables or as sophisticated as dynamic documents with drillable charts.<br /></p><p>You can then save those documents for your own personal use, send them to other users, or publish them to the corporate repository for potentially even broader circulation.</p>Its For Techieshttp://www.blogger.com/profile/04854561330824512840noreply@blogger.com0tag:blogger.com,1999:blog-8737501305173930315.post-9027457634985909042008-04-14T23:30:00.000-07:002008-04-14T23:34:26.146-07:00Data Modeling Overview<p> </p><p><strong><span style="color:#993300;">Data Modeling Overview:</span> </strong>A Data model is a conceptual representation of data structures(tables) required for a database and is very powerful in expressing and communicating the business requirements.</p><p>A data model visually represents the nature of data, business rules governing the data, and how it will be organized in the database. A data model is comprised of two parts logical design and physical design.</p><p><span style="color:#993300;"><a href="http://career-datamodeling.blogspot.com/">Data model</a></span> helps functional and technical team in designing the database. Functional team normally refers to one or more Business Analysts, Business Managers, Smart Management Experts, End Users etc., and Technical teams refers to one or more programmers, DBAs etc. Data modelers are responsible for designing the data model and they communicate with functional team to get the business requirements and technical teams to implement the database.</p><p>The concept of data modeling can be better understood if we compare the development cycle of a data model to the construction of a house.</p><p>For <a href="http://career-datamodeling.blogspot.com/">example </a>Company ABC is planning to build a guest house(database) and it calls the building architect(data modeler) and projects its building requirements (business requirements). Building architect(data modeler) develops the plan (data model) and gives it to company ABC. Finally company ABC calls civil engineers(DBA) to construct the guest house(database).Need for developing a Data Model:<br /></p><p>A new application for OLTP(Online Transaction Processing), ODS(Operational Data Store), data warehouse and data marts.<br /></p><p>Rewriting data models from existing systems that may need to change reports.<br />Incorrect data modeling in the existing systems.<br />A data base that has no data models.</p><p><strong><span style="color:#000099;">Advantages and Importance of Data Model</span></strong></p><p>The goal of a data model is to make sure that all data objects provided by the functional team are completely and accurately represented.<br /></p><p>Data model is detailed enough to be used by the technical team for building the physical database.<br /></p><p>The information contained in the data model will be used to define the significance of business, relational tables, primary and foreign keys, stored procedures, and triggers.</p><p><a href="http://career-datamodeling.blogspot.com/">Data Model </a>can be used to communicate the business within and across businesses. </p><p> </p>Its For Techieshttp://www.blogger.com/profile/04854561330824512840noreply@blogger.com0tag:blogger.com,1999:blog-8737501305173930315.post-34462781251829282612008-04-14T23:24:00.000-07:002008-04-14T23:28:39.167-07:00<p> </p><p><strong><span style="color:#660000;">Cognos & Business Intelligence:</span></strong> </p><p>"Cognos is the world leader in <a href="http://dwh-cognos.blogspot.com/">business intelligence</a> (BI) and performance planning software for the enterprise. Its solutions let companies improve and direct corporate performance by enabling all of the key steps in the management cycle—from planning and budgeting, to measuring and monitoring performance, to reporting and analysis.</p><p>Cognos is the only company to support all of these key management activities with a complete solution that spans all of the essential components of CPM—enterprise planning, scorecarding, and business intelligence."<br /></p><p><strong><span style="color:#993300;">Vendor:Cognos Products: Business Intelligence </span></strong></p><p>Cognos ReportNet<br />Cognos PowerPlay<br />Cognos DecisionStream<br />Cognos NoticeCast<br /><span style="color:#993300;"><a href="http://dwh-cognos.blogspot.com/">Cognos</a></span> Performance Applications<br /></p><p><span style="color:#006600;"><strong>ScoreCards and Dashboards:</strong></span><br />Cognos Metrics Manager<br />Cognos ReportNet<br /></p><strong><span style="color:#006600;"></span></strong><p><strong><span style="color:#006600;">Planning and Consolidation:<br /></span></strong>Cognos Planning<br />Cognos Controller<br />Cognos Finance </p><p> </p>Its For Techieshttp://www.blogger.com/profile/04854561330824512840noreply@blogger.com0tag:blogger.com,1999:blog-8737501305173930315.post-12554134815621919672008-04-02T23:44:00.000-07:002008-04-02T23:46:50.638-07:00What is SQL?<p><span style="font-weight: bold;">SQL</span> is an international standard language for manipulating relational databases. It is based on an IBM product. SQL is short for Structured Query Language. </p> <p>SQL can create schemas, delete them, and change them. It can also put data into schemas and remove data. It is a data handling language, but it is not a programming language. </p> <p>SQL is a DSL (Data Sub Language), which is really a combination of two languages.<br /></p> <p>These are the Data Definition Language (DDL) and the Data Manipulation Language (DML).<br /></p> <p>Schema changes are part of the DDL, while data changes are part of the DML.<br /></p> <p>We will consider both parts of the DSL in this discussion of SQL.</p><br /><p><br /></p><p style="color: rgb(255, 0, 0);"><b>What is SQL?</b> </p> <p><span style="color: rgb(0, 0, 0);">SQL stands for Structured Query Language and is the lingua franca in the database world. SQL is a standard that is used by all database vendors and programmers to define, extract and access the information that is stored in databases. SQL began life as an IBM creation but was standardized by the American National Standards Institute (ANSI) and the International Organization for Standardization (ISO) as ANSI/ISO SQL in 1988. Since then ANSI/ISO SQL standard continued to evolve. The ANSI-SQL group has since published three standards over the years:</span> </p> <p><span style="color: rgb(0, 0, 0);">1. SQL89 (SQL1)</span> </p> <p><span style="color: rgb(0, 0, 0);">2. SQL92 (SQL2)</span> </p> <p><span style="color: rgb(0, 0, 0);">3. SQL99 (SQL3)</span> </p> <p><span style="color: rgb(0, 0, 0);"><br /></span></p> <p><span style="color: rgb(0, 0, 0);">SQL is a query language. It is English-like and easy to use. However, although there are more than 90 SQL reserved words, most programmers seldom use more than the following handful of commands - SELECT, INSERT, UPDATE, DELETE, FROM, WHERE, HAVING, BETWEEN, LIKE, OR, AND, NOT, IN, ORDER, GROUP and BY.</span> </p> <p><span style="color: rgb(0, 0, 0);"><span style="color: rgb(255, 153, 0);">For example,</span> if you had a database table named "employees" and you wanted to retrieve all records where the employee has the last name "goodman", you would use the following SQL statement:</span> </p> <p><span style="color: rgb(0, 0, 0);">SELECT * FROM employees WHERE lastname = 'goodman';</span> </p> <p><span style="color: rgb(0, 0, 0);">There are many different categories of SQL statements but the basic ones which all programmers should be familiar with are the SQL statements that:</span> </p> <p><span style="color: rgb(0, 0, 0);">1. Create tables and manipulate their definitions</span> </p> <p><span style="color: rgb(0, 0, 0);">2. Query the table data</span> </p> <p><span style="color: rgb(0, 0, 0);">3. Manipulate the table data</span> </p> <p><span style="color: rgb(0, 0, 0);"><br /></span></p> <p><span style="color: rgb(0, 0, 0);">SQL is predominantly used by 2 types of users - programs and humans (keying in the commands through a database client) - to pass instructions to databases. SQL commands can be keyed into a database client like the MySQL Query Browser or the SQL Server Enterprise Manager and executed to either return a result or modify records in the database. SQL can also be used in conjunction with programming language or scripting language like Microsoft Visual Basic or PHP to communicate with the database.</span> </p> <p><span style="color: rgb(0, 0, 0);">Although SQL is a world standard, it is unfortunate that most database vendors have come up with different dialects and variations. This is because every database vendor wants to differentiate their database products from the crowd. One good example is Microsoft SQL Server's TRANSACT-SQL. TRANSACT-SQL is a superset of SQL and is designed for use only with Microsoft SQL Server.<br /></span></p> <p><span style="color: rgb(0, 0, 0);">Although it does make programming much easier for software developers, it is not compliant with other databases like Oracle or MySQL - making TRANSACT-SQL programs non database-portable. As such, although many of these features are powerful and robust, it is good practice to exercise caution and limit your SQL use to be compliant with the ANSI/ISO SQL standards and ODBC-Compliant.</span></p><p><span style="color: rgb(0, 0, 0);"><br /></span></p>Its For Techieshttp://www.blogger.com/profile/04854561330824512840noreply@blogger.com0tag:blogger.com,1999:blog-8737501305173930315.post-3309791875131952792008-04-02T23:41:00.000-07:002008-04-02T23:43:42.999-07:00Am I eligible for SAP?<span style="color: rgb(204, 102, 0);">Am I eligible for SAP? </span><br /><br /><span style="font-weight: bold; color: rgb(204, 102, 0);">SAP Functional:</span><br /><br />One must have at least graduation. A postgraduate degree would be an added advantage.Experience in any Domain. Here Domain is an Industry domain like Sales and Distribution, Materials Management and Finance etc.<br /><br />Must complete SAP training in respective module. Some companies are hiring individuals who are having very good experience in industry domains and providing SAP trainings.<br /><br /><br /><span style="font-weight: bold; color: rgb(204, 102, 0);">SAP Technical:</span><br /><br />One must have at least graduation. A postgraduate degree would be an added advantage.Exposure to any programming language is required.<br /><br />SAP is having its own programming language ABAP (Advanced Business Application Programming).Must know SAP ABAP programming language.<br /><br /><br /><span style="font-weight: bold; color: rgb(204, 102, 0);">SAP Administration:</span><br /><br />One must have at least graduation. A post-graduate degree would be an added advantage.For the people who are in networking and Administration side, SAP BASIS is very suitable.One must learn SAP BASIS.<br /><br /><br /><span style="font-weight: bold; color: rgb(204, 102, 0);">Types of SAP Projects:<br /><br /></span><br />We can divide the SAP projects into three categories.<br /><br />They are<br /><br />1) SAP Implementation Projects<br /><br />2) SAP Support Projects<br /><br />3) SAP Migration Projects<br /><br /><br /><span style="font-weight: bold; color: rgb(204, 102, 0);">1) SAP Implementation Projects: </span><br /><br />In this type of projects, Customers are moving towards SAP software. Previously they might be using some other software.<br /><br /><br /><span style="font-weight: bold; color: rgb(204, 102, 0);">2) SAP Support Projects </span><br /><br />Once SAP project is implemented, the consultants should support it in day-to-day business.<br />In Support projects, the support team helps the customer in day-to-day business.<br /><br /><br /><span style="color: rgb(204, 102, 0); font-weight: bold;">3) SAP Migration Projects</span><br /><br />As we see, SAP is continuously upgrading the R/3 software.<br /><br />Customers are moving from the older versions to new versions.<br /><br />When the customer decides to new version, it is called SAP Migration Projects.<br /><br />Now -a -days many customers are migrating from older versions like 4.5 or 4.6B, 4.6C to ECC 5.0 or ECC 6.0 versions.Its For Techieshttp://www.blogger.com/profile/04854561330824512840noreply@blogger.com0tag:blogger.com,1999:blog-8737501305173930315.post-36926030878415880222008-03-29T07:42:00.000-07:002008-03-29T07:44:58.585-07:00<strong><span style="color: rgb(0, 0, 153);">Tip #1</span></strong><br /><br />Be honest to answer technical questions, you are not expected to remember everything (for example you might know a few design patterns but not all of them). If you have not used a design pattern in question, request the interviewer, if you could describe a different design pattern.<br /><br /><br /><br /><strong><span style="color: rgb(0, 0, 153);">Tip #2</span></strong><br /><br />Every body is nervous for interviews and being a little nervous is natural. But if you are too nervous then you can overcome this by preparing for your interviews and by treating each interview as a free technical/behavioural training course. Have an attitude that even if you are not going to get the job, you are going to learn something good out of it. If you go with this attitude you will put yourself in a win/win situation and you might really get the offer. If you take this attitude you can learn a lot from your interviews. Also never think that you have to answer all the questions correctly. Do not get put off by a tricky or a difficult question. What really earns you a job is the combination of your knowledge + experience + attitude<br /><br /><br /><strong><span style="color: rgb(0, 0, 153);"></span></strong><br /><strong><span style="color: rgb(0, 0, 153);">Tip #3</span></strong><br /><br /><br />Where possible briefly demonstrate how you applied your skills/knowledge in the key areas like design concepts, transactional issues, performance issues, memory leaks, best practices etc as described in the book Java/J2EE Job Interview Companion along with your business skills and interpersonal skills. Find the right time to raise questions and answer those questions to show your strength in the technical key areas, business and interpersonal skills.<br /><br /><strong><span style="color: rgb(0, 0, 153);"></span></strong><br /><br /><strong><span style="color: rgb(0, 0, 153);">Tip #4</span></strong><br /><br />Tell me about yourself or about some of the recent projects you have worked with? What do you consider your most significant achievement? Why do you think you are qualified for this position?Above mentioned interview questions are very common and the interviewer will be mainly looking for 4 qualities:1. Passion.2. Ability to understand potential failures (transactional issues, concurrency issues, design issues etc).3. Ability to see things at a high level as well as drill down when required.4. Ability to think dynamically to deliver solutions to complex problems and ability to analyse “what if ” scenarios (What if I want to support a non Web client?, What if I want to support other types of products? etc).<br /><br /><br /><strong><span style="color: rgb(0, 0, 153);"></span></strong><br /><strong><span style="color: rgb(0, 0, 153);">Tip #5</span></strong><br /><br />What was the last Java related technical book or article you read? Which Java related website(s) or resource(s) do you use to keep your knowledge up to date beyond Google? What do you think of some of the emerging technologies/frameworks like AOP, IOC, Spring, Tapestry etc? What recent technology trends are important to enterprise development?The interviewer will be mainly looking for your:Curiosity to learn: How eager you are to learn new things and keep up to date with the technology.<br /><br /><br /><br />Learn the Java/J2EE Core Concepts/Key Areas with an easy to understand questions and answers approach.The best way to make an impression in any organizations is to understand and proactively apply and resolve the issues relating to 14 Key Areas covered in this book.Lulu books Top 100 best seller.Free Java J2EE Interview Q&A PDF download.<br /><br /><br />1. Language Fundamentals<br /><br />2. Specification Fundamentals<br /><br />3. Design Concepts<br /><br />4. Design Patterns<br /><br />5. Transactional Issues<br /><br />6. Concurrency Issues<br /><br />7. Performance Issues<br /><br />8. Scalability Issues<br /><br />9. Memory Issues<br /><br />10. Exception Handling<br /><br />11. Security<br /><br />12. Best Practices<br /><br />13. Software Development Process<br /><br />14. Coding<br /><br /><br />This book will assist all Java/J2EE practitioners to become better at what they do. Usually it takes years to understand all the core concepts and design/coding issues when you rely only on your work experience. The best way to fast track this is to read appropriate technical information and proactively apply these in your work environment. It worked for me and hopefully it will work for you as well. I was also at one stage undecided whether to name this book Java/J2EE core concepts and solving design/coding issues or Java/J2EE Job Interview Companion. The reason I chose Java/J2EE Job Interview Companion is because these core concepts and design/coding issues helped me to be successful in my interviews and also gave me thumbs up in code reviews.<br /><br /><br />Succeed in your Java J2EE Job interviews with the help of Java/J2EE Job Interview Companion<br />Over 400 frequently asked and popular Java J2EE Interview Questions with clear and concise answers. All answers are well supported with diagrams, examples, code snippets and cross referencing.Its For Techieshttp://www.blogger.com/profile/04854561330824512840noreply@blogger.com0tag:blogger.com,1999:blog-8737501305173930315.post-3928206196981804042008-03-23T08:21:00.000-07:002008-03-23T08:22:00.215-07:00Difference between the User Exit & Gap analysis.<br />Both are quiet a different and has a small relation.<br />User exits are standard gate ways provided by SAP to exit the standard code and we can write our own code with the help of ABAP workbench. its not new functionality which we are trying to build in sap but its slight enhancement within the same code.<br />Gap analysis is start point of Realization and once blue print is finished we have to find the realization of sap system for client requirment and there will be certain gaps when compared to system fit.<br />Those gaps can be closed either by re-engineering of business process to fit with SAP or we have to use USER exits in case of small deviations or complete enhancements with the help of ABAP to fit with the SAP system.Its For Techieshttp://www.blogger.com/profile/04854561330824512840noreply@blogger.com0tag:blogger.com,1999:blog-8737501305173930315.post-69947518760782107552008-03-23T08:14:00.000-07:002008-03-23T08:15:53.507-07:00<p> </p><p>SAP BDC Interview Questions And Answers<br />Difference between /N and /BEND ?/BEND terminates the batch input processing and sets the session to be failed./N terminates the current batch input transaction.<br />SM35 transaction . How to automate BDC ? After execution of batch input program , the session created is placed in the session queqe which can be viewed using SM35 transaction executing / Releseing the session will start the transfer of the data from the session into the database tables./<br />Update types in Call transaction method. What is the difference ? At present with SAP we have only modes of updation<br />1.Synchronus Update.<br />2.Asynchronous Update.<br />There is no more Local Update.<br />What are the table controls in BDC ? What is the difference between bdc andlsmw ? What is the difference between bdc and rfc ?<br />BDC - Batch data communication in which there are 2 processes<br />1. in bound<br />2. outbound<br /><a href="http://sap-career.blogspot.com/">RFC</a> - remote fucntion call(or) calling<br />Data conversion experience?<br /><a href="http://sap-career.blogspot.com/">DATA CONVERSIONS: </a><br />SAP HAS PROVIDED A TOOL NAMED LSMW WHICH CONVERTS THE LEGACY DATA INTO THE REQUIRED SAP FORMAT AND UPDATES THE DATABASE.<br />Open datasets, Read datasets ( Reading and writing data to files)?<br />Date Sets are nothing but files on Application Server,they can even be called as Sequential files.<br />Open Dataset<br />Is used to open required file on the application Server.<br />Read Dataset. Is used to read the contents required file on the application Server.<br />How to do back ground processing in BDC Session method ?<br /><a href="http://sap-career.blogspot.com/">Goto sm35 </a>select the option background process<br />Call transaction method, how to capture the errors ?<br />IN CALL TRANSACTION TO CAPTURE THE ERRORS WE SHOULD PERFORM THE FOLLOWING.<br />FIRST ME MUST DECLARE AN INTERNAL TABLE WITH THE STRUCTURE OF BDCMSGCOLL TABLE.<br />THEN WHILE WRITING THE CALL TRANSACTION STATEMENT WE SHOULD PUT THE 'E' MODE FOR CAPTURING ALL THE ERRORS.<br />THEN FINALLY THE CAPTURED ERRORS MUST TO SENT TO THE INTERNAL TABLE WHICH WE DECLARED IN THE BEGINNING WITH BDCMSGCOLL BY USING THE FUNCTION MODULE "FORMAT_MESSAGE"<br />AND THUS THE ERROR MESSAGES WILL BE SENT TO THE INTERNAL TABLE WHICH WE DECLARED AT THE BEGINNING.<br />How to load data from MS Excel sheet to SAP by using BDC method ?<br />KCD_EXCEL_OLE_TO_INT_CONVERT even takes care of blank cells and is available in older versions of SAP* Add values to internal table<br />SORT t_cells BY row col.<br />LOOP AT t_cells INTO wa_cells.<br />MOVE : wa_cells-col TO l_index.<br />ASSIGN COMPONENT l_index OF STRUCTURE itab TO ..f_value...<br />MOVE : wa_cells-value TO ..f_value..<br />AT END OF row.<br />APPEND itab<br />CLEAR itab.<br />ENDAT.<br />ENDLOOP.<br />What is the difference between call transaction and session method?<br />Session method: The records are not added to the database until the session is processed. sy-subrc is not returned. Error logs are created for error records. Updation in database table is always Synchronous.Call Transaction method: The records are immediately added to the database table. sy-subrc is returned to 0 if successful. Error logs are not created and hence the errors need to be handled explicitly. Updation in database table is either Synchronous or Asynchronous.<br />SM35 transaction . How to automate BDC ?<br />sm35 is used to play girls for better nightfalls.<br />What is the difference between Upload and WS_Upload ?<br />The diffrence between WS_Upload and Upload is when you use function Upload it prompts for a dailog box where in you need to key in the file location.Where as in case of WS_Upload you specify the file location in the function input parameters itself<br />If I want to execute a program only in background not in foreground is there any option for this?<br />The sm37 transaction can be used for running a program in the background. Also in the session method while processing the session you can specify the processing type as background or foreground.<br />What kind of BDC programs are written ?<br />There are five types of BDC methods available. They are 1.Batch input session 2.Call Transaction 3.Recording 4.Direct Input and 5.LSMW<br />How to read files and process BDCs automatically?<br />To read file from Presentation server use Upload or GUI Upload or WS upload and to read file from Application server use Opend Dataset,Read dataset and Close dataset<br />In session method sy-subrc is not returned whereas in call transaction method sy-subrc is returned . what does it mean?<br />While to transfer the data from the through if any errors occurs until the errors are the complete the data is not transfer to the SAP system.<br />The system compulsory shows the errors. that errors are stored into the error logs (Transaction is SM35).<br />so the session method should not return any value.<br />In call transaction method data is directly pass to the SAP system.<br />So its compulsory return the value.<br />Because of the call transaction is the function.<br />A function should return the value mandatory.<br />Recording Function<br />With recording, user can avoid manual search for fields and tables required in a program including screen numbers. SHDB is the transaction code.<br />BDC vs Direct Loads( have you used direct loads on SAP tables )<br />Direct loads is 5 times faster than uploading by normal BDC method. but some times while updating the database referential integrity is violated.<br />Have you set up a back ground job ? How to create a background job without a variant ?<br />Yes, user can create background job scheduling in two ways. 1. By calling the executable program RSBDCSUB<br />2. Transaction Code SM37</p>Its For Techieshttp://www.blogger.com/profile/04854561330824512840noreply@blogger.com0