-
Write a query for split one column to multiple columns
I have a source table with one column of 15 characters and I want output like divide the 15 chars column into multiple of 3 columns like every column 5 chars source empnoorderprdct target empno order prdct
-
Object to generate XML
What are the various methods provided by the dataset object to generate XML? Note:- XML is one of the most important leap between classic ADO and ADO.NET.So this question is normally asked more generally how can we convert any data to XMLformat. Best answer is convert in to dataset and use the below methods. vReadXMLRead’s a XML document in to Dataset. vGetXMLThis is a function which returns the...
-
Touch Potential
what determines touch potential
-
how to explain sales project in interview.
how to explain sales project in interview.could u tell me modules or dim table with some column names and facts how to move data from dim to facts.and give me what logic u implement in that projects
-
-
-
How to export the contents of a combo box to the table?
I want to export the contents of a combo box to the data table so that i can parametrize the test using the data present in the combo box. Thanks in advance Roli
-
-
-
-
-
-
Tiny, large, huge memory models
I need the above said memory types explanation. Please tell me any one.
-
-
Properties in C#
What are properties in C#? What are the advantages of using Properties ?
-
-
-
SIT testing
what should be responsibility and scope for system integration testing
-
-
-
-
how to solve soc 7 error.?
non numeric data transfer to numeric causes soc 7.but i want with reference to .....XREF,LINE number,..
-
-
Message error
How can I get off a error message oracle form A0001 ask me to save the record when I change a record to other ?
-
What is Clustered Table in Oracle? Difference between Clustered Table and View?
A cluster is a schema object that contains data from one or more tables, all of which have one or more columns in common.
-
Extract Statement
What does the extract statement do in ABAP program?
-
Domain and data element
What do you define in domain and data element?
-
-
-
-
Write function vowels to count the vowels and letters
Write function vowels to count the vowels and letters in free text given as string. Then print out the number of occurrences of each of the vowels a, e, i, o and u in the string, the total number of letters, and each of the vowels as an integer percentage of the letter total. Suggested output format is: Numbers of characters: a 3 ; e 2 ; i 0 ; o 1 ; u 0 ; rest 17 Percentages of total: a 13%; e...
-
Write a function reverse which takes a strings as a parameter and prints it out in reverse.
Example:reverse (hello) prints out (olleh)
-
-
-
-
ETL Testing in Informatica
As an ETL tester what are the things to test in Informatica tool. What are the types of testing has to do in informatica and the things to test in each type? If there is any documents on ETL testing
-
What are Oracle Hints and How do you use them ?
Explain the real-time situation where would you use Oracle Hits
-
-
How to generate Systemutil.run command automatically while recording?
I have QTP 9.2(Mercury) when i record a test the scripts are generated but the very first line (i.e)systemutil.run is not generated and while running the test i get the message as cannot find all programs object parent.
-
What is Index Property in descriptive programming?
Could you explain, Why is it bad practice to use index property in Descriptive Programming?
-
How to hide the files with Vbscript ?
Hi, i want code in vbscript that make all (files and folders) : a- if there are some (files and folders) not hidden make them hidden and if there are other (files and folders) hidden stay hidden without any change.
-
Database Driver
How to find which type driver used in Java or J2EE applications? Which type used commonly?
-
-
Informatica ERROR REP_12014 : Error occured while accessing the Registry
HiIam learning informatica 8.1 ( which is what i could get my hands on)..I am connecting to oracle 10g.I created 2 connections to the DB using Connection --> Relational Connection Browser.The Source and Target are the same db in this case, just diff table names. But created 2 separate connections .I 1st created the TUTORIAL_SOURCE and then copied it to TUTORIAL_TARGET and gave it a new name. then...
-
-
Insert method in ASP.NET
how an insert method of the sqldata source control works in asp .net
-
shared object repository
How to get local repository as shared repository?
-
BPT framework
how to drag the QTP code(Actions) to QC BPT components
-
Ordinance in Correlation
what is the significance of ordinance in web_reg_save_param during correlation?
-
MPFI
How does MPFI works? & explain me the mechanism of it? What is the purpose of it ?
-
-
-
locality of reference
what does locality of reference mean in term of operating system
-
Vertical and Horizontal Cluster
What are the advantages & disadvantages of vertical cluster & horizontal cluster? Which is the best? Why?
-
Alternative to TK Prof in oracle 11g
Hi, What is alternative to TK prof (used in oracle 9i) in 10g and 11g? Regards, Shashi
-
-
Hybrid Automation Framework Structure
I was been asked to write the Hybrid Framework Structure in an interview. Could you please let me know the Hybrid Framework Structure.
-
How to create pivot table ?
Explain with an example which situation that pivot tables can save time compared to any other reporting tools available
-
Internet connection Issue
If someone finds that their Internet connectivity is down, how would you fix the problem?:
-
High Water Mark
what is high water mark? Give an example where it can be useful ?
-
Importance of java.lang.obj
What is the significance of java.lang.object class?
-
MySql Query problem
I have two Table A and B.With table A I fired a query to get a count, and a query with table B to get a count.now I want total of both count.But I want to this all in one query.Example:- I fired tqo queries as-1- select DATE(Today_DATE), count(1) from table DAY1 group by DATE(Today_DATE);2- Select DATE(Yesturday_DATE), count(1) from table DAY2 group by DATE(Yesturday_DATE);Here both table give separate...
-
Sort_area_size usage
Why we use Sort_area_size parameter in init.ora file?Kindly let me know?
-
Difference between Data abstraction, schema and instance
Difference between the three levels of data abstraction, and between a schema and instances.. Consider a two dimensional integer array of size n*m that is to be used in your favorite programming language. Using the array as an example, illustrate the difference (a) between the three levels of data abstraction, and (b) between a schema and instances.
-
-
Invoice discrepancy
How do you resolve a Invoice discrepancy that you discover
-
ROM Image
Define ROM image and explain each section of a ROM image in an exemplary system?
-
Run PL/SQL Block from SQL Server
how do you run PL/SQL block from SQL Server
-
VLAN Trunking
What is VLAN trunking? How does it work?
-
Quality and Productivity Measures
The individual who supports in preparing metrics need to have working knowledge of quality and productivity measuresA TrueB False
-
Delete Entire Linked List
How to delete a entire linked list?
-
IP VPN and Internet VPN
What is the difference between IP VPN and Internet VPN ? Does both comes with static IP adress?
-
Knowledge Brokering
Hi All,What are the tools or the softwares required or used by knowledge brokers in knowledge mangement sytem for their processing?Thanks,Avinash
-
EIM
When you run an EIM job using configuration file(ifb). if you get an error and the log says invalid file name. what will you do?
-
Connectivity Troubleshooting
A user in a corporate network contacts service desk saying he/she has lost network connectivity: How will you troubleshoot the issue? What are the steps to followed?
-
Entity Relationship
Explain a one-to-many strong vs. one-to-many weak entity relationship.
-
Kernel Package
Why is Oracle called kernel package?
-
Labyrinth Sseal
List different types of Labyrinth Seals How to measure Labyrinth Seal Clearrence?What is the allowable clearence?
-
-
Before Operating Systems
Before the introduction of operating systems what concept was used in computer?
-
Covering Indexes
List down the advantage and disadvantages of Covering indexes.
-
Earthing Cable Size
Calculate the size of earthing conductor between earth pit & 2000 KVA generator.
-
Recovery Catalog
How will you find-out if your database is using recovery catalog or not?
-
Relationship Between Database and Data Warehouse
What is the relationship between a company's databases and its data warehouse?
-
Representing SQL Server Objects
How do represent objects in SQL Server? Is it possible? If yes, how?If not? Why?
-
Framework Manager Dimensions
How to create Regular and measure dimensions? How we will use these dimensions in the report?
-
Control Accounting
What is Control Accounting? What is the use of it?
-
Gift Items Depreciation
What is the treatment of Depreciation on Gift Items?
-
Measure Dimension
What is Measure Dimension?
-
Response Time
How to calculate response time in Client-Server technology?
-
Conductor Resistivity
When a small amount of Cu is added to a Ni conductor, then the?a) Resistivity of Ni will decrease at all temperatures because Cu is better conductor than Nib) Residual resistivity of Ni at low temperatures will increase as Cu atoms acts as defect centersc) Resistivity of Ni will increase at all temperatures as Cu destroys the periodicity of Ni and acts as defectsd) Resistivity of Ni remains unaltered...
-
Retail Invoice vs. Tax Invoice
What difference between retail invoice and tax invoice?
-
Cost Control
What is cost control? what are the duties of a cost controller?
-
-
Resource Manager Parameters
What are the parameter of Resource Manager?
-
Cost Reporting
Explain the process of cost reporting
-
Stacktrace Server Error Log
What should you do when you find a stacktrace in the server errorlog?
-
Online Redo Logs
Outline the steps for recovery with missing online redo logs?
-
-
high raised building construction
soil density test, bearing capacity of soil?
-
Improve Hard Disk Transfer Rate
How to increase transfer rate of an hard disk?
-
-
Seeded Invoice in Accounts Payable
What is Seeded Invoice?
-
How to write script using Database
Hello, I have imported log file into MS access with columns server,date,time,url.I need to write VB script in VB editor for accessing rows in between given date and time.It's urgent.please can any body help with this.Thanks
-
What is folder form?
Definitions, Usage and its Information in Oracle forms 9i
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
What is the role for a manual tester
Hi, i am planing to get a job in manual testing. can any help me in what a manual tester does from initiation of the project to end of the project.what are his role from base.Thanks,priya
-
Group Discussion in Recruitment process
Respected Sir, I am doing my M.C.A.I want to know which I.T companies are conducting Group Discussion in their recruitment process? Sir Plz kindly inform me the recruitment process of different companies(Like Which Phases we need to face,percentage cutoff). Thanking You Sir yours sincerely
-
What is your Short and long term goals ?
An interviewer asks me,what's your short and long term goal? What should I answer to impress him?
-
-
-
Finding job with backlog subjects
Hai, I am ravindra form padmashri dr B.V.RAJU institute of technology,i am having a backlog in my 3-ii semester as i was absent for that exam ,will it be any problem for me for my jobs which i apply?
-
What does an extract statement do in the ABAP program?
Once you have declared the possible record types as field groups and defined their structure, you can fill the extract dataset using the following statements: EXTRACT . When the first EXTRACT statement occurs in a program, the system creates the extract dataset and adds the first extract record to it. In each subsequent EXTRACT statement, the new extract record is added to the dataset EXTRACT HEADER....
-
What is a batch input session?
BATCH INPUT SESSION is an intermediate step between internal table and database table. Data along with the action is stored in session ie data for screen fields, to which screen it is passed, program name behind it, and how next screen is processed.