GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Tech FAQs  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 259 of 300    Print  
What will be the output?

Select 'a' from table1 UNION select 1 from table2;

  
Total Answers and Comments: 1 Last Update: November 29, 2007     Asked by: arunkumar 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
November 29, 2007 09:59:22   #1  
gdngajudn Member Since: November 2007   Contribution: 1    

RE: What will be the output?Select 'a' from table1 UNION select 1 from table2;
Execution of this query will give an error.
We will get error in this Case as the the out put for table 1 is a string where as the the return of table 2 is a number and both are of different datatype.

 
Is this answer useful? Yes | No

 Related Questions

When i was running workflow manager i.e, when i right click the task icon and clicking start workflow from task, i am getting a message like 'cannot connect to the server'. Can any body guide me, how to get the output.Thanks
Read Answers (4) | Asked by : bn

I created one mapping successfully but not getting output (database connection is okay) can anybody suggest me?
Read Answers (4) | Asked by : vinay

When we use only Aggregator transformation in our mapping for approx 5 milion records it takes 40-42min time but when we use it with a sorter transformation, the time reduces to 12 -13 min. We have also noticed that throughput of select statement from source was also very high. It aggregates grouped data quickly is ok but why throughput of select statement was also higher using sorter transformation?

if you have column name as f_name in which the data is "john&","97edward","do__nna" . you want to remove/replace the special characters and then send the output as "john","edward","donna" 
View Question | Asked by : abc

It can be possible by using %a in Session Components POST SESSION EMAIL tab. 
View Question | Asked by : N SRIRAM K

I have a requirement to convert date format.my requirement is as followsi hav date column in my source.my source data in date columnv_date10-11-200619-aug-199925-dec-05null11-5-05like thismy requirement 
Latest Answer : Simple use expression transformation and make all the inputs into the date format given. Add a condition like IIF(ISNULL(V-date),SYSDATE(),IIF(IS_DATE(v-date),TO_DATE(v_date,'dd-mon-yy'),'Invalid Date')This is my idea. It helps you hopefully....thx ...

I am getting this error "ORA-14050: invalid ALTER INDEX MODIFY PARTITION option" while running a procedure through informatica session. But the same procedure is executed successfully and doing 
View Question | Asked by : ravi

How to perform cummulative sum in Mapping For eg,Id Amt1 102 203 30The output should beId Amt1 102 303 60
Read Answers (1) | Asked by : Irshad

I have a requirement to lookup the same table twice with different keys one after another. If the first lookup fails then only the second lookup should be done. And, i have to use connected lookup to return 
View Question | Asked by : Raj

Latest Answer : Execution of this query will give an error.We will get error in this Case as the the out put for table 1 is a string where as the the return of table 2 is a number and both are of different datatype. ...
Read Answers (1) | Asked by : arunkumar


 Sponsored Links

 
Related Articles

C++ Standard Input Output Stream

C Standard Input Output Stream In this C tutorial you will learn about standard input stream and standard output stream explained along with syntax and examples C programming language uses the concept of streams to perform input and output operations using the keyboard and to display information on
 

How To Select The Best CRM Solution For Your Business

How To Select The Best CRM Solution For Your Business When most people talk about Customer relationship management they use the term in a context that is connected to large corporations However the costs of CRM systems have continued to fall in the last few years and it is now in the price range of
 

C Programming - Managing Input and Output Operations

C Programming Managing Input and Output Operations In this tutorial you will learn about Single character input output String input and output Formatted Input For Scanf Input specifications for real number Input specifications for a character Printing One Line Conversion Strings and Specifiers Speci
 

SQL Server 2000: Creating Stored Procedure with Input and Output Parameters

This tutorial explains how to create and use Stored Procedures with Input Parameters and output parameters along with the screen shots and sample code Creating Stored Procedure with Input Parameters mosgoogle Input Parameters in Stored Procedures are placeholders for data that the user needs to send
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape