ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  ETL
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question 
CAN ANY ONE SEND ME THE CODE FOR THE BELOW
1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD 
DISPLAY OUT PUT AS "323237232"
2). NEED TO ONLY "COMPANY.COM" FROM EMAIL 
FILED "TEST@COMPANY.COM"
 Question Submitted By :: Sreedhar
I also faced this Question!!     Rank Answer Posted By  
 
  Re: CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD DISPLAY OUT PUT AS "323237232" 2). NEED TO ONLY "COMPANY.COM" FROM EMAIL FILED "TEST@COMPANY.COM"
Answer
# 1		 
Use trim(columnname,'_','a') to remove the '-' values from 
the columns

2) use field function: field(columnname,'@'2) to get the 
company.com

Thanks
Kumar
 
Is This Answer Correct ?    1 Yes 4 No
Kumar
 
  Re: CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD DISPLAY OUT PUT AS "323237232" 2). NEED TO ONLY "COMPANY.COM" FROM EMAIL FILED "TEST@COMPANY.COM"
Answer
# 2		 
use TRANSLATE function

select 
translate ('323-237-2323','0123456789-', '0123456789') 
from table_name;
 
Is This Answer Correct ?    1 Yes 2 No
Bilas
 
 
 
  Re: CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD DISPLAY OUT PUT AS "323237232" 2). NEED TO ONLY "COMPANY.COM" FROM EMAIL FILED "TEST@COMPANY.COM"
Answer
# 3		 
2)if findc(emailid,'@','company.com')=0 then 
emailid=emailid;
 
Is This Answer Correct ?    0 Yes 2 No
Erqf
 
  Re: CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD DISPLAY OUT PUT AS "323237232" 2). NEED TO ONLY "COMPANY.COM" FROM EMAIL FILED "TEST@COMPANY.COM"
Answer
# 4		 
replace ('323-237-2323','-', '')
 
Is This Answer Correct ?    2 Yes 0 No
Kumaravelu
 
  Re: CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD DISPLAY OUT PUT AS "323237232" 2). NEED TO ONLY "COMPANY.COM" FROM EMAIL FILED "TEST@COMPANY.COM"
Answer
# 5		 
substr('TEST@COMPANY.COM',instr('TEST@COMPANY.COM','@')+1)
 
Is This Answer Correct ?    1 Yes 0 No
Kumaravelu
 
  Re: CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD DISPLAY OUT PUT AS "323237232" 2). NEED TO ONLY "COMPANY.COM" FROM EMAIL FILED "TEST@COMPANY.COM"
Answer
# 6		 
select replace ('323-237-2323','-') from dual

select substr('abc@co.com',-7) from dual
 
Is This Answer Correct ?    3 Yes 2 No
Kkr
 
  Re: CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD DISPLAY OUT PUT AS "323237232" 2). NEED TO ONLY "COMPANY.COM" FROM EMAIL FILED "TEST@COMPANY.COM"
Answer
# 7		 
select trim(replace('2-3-4','-',NULL)) from dual
 
Is This Answer Correct ?    1 Yes 0 No
Kuttu
 
  Re: CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD DISPLAY OUT PUT AS "323237232" 2). NEED TO ONLY "COMPANY.COM" FROM EMAIL FILED "TEST@COMPANY.COM"
Answer
# 8		 
select substr('12132@dfsaf.com',
              instr('12132@dfsaf.com', '@')+1,
              length('12132@dfsaf.com'))
  from dual
 
Is This Answer Correct ?    2 Yes 0 No
Again Kuttu!!
 

 
 
 
Other ETL Interview Questions
 
  Question Asked @ Answers
 
Eliminating of duplicate records without using dynamic lookups  1
CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD DISPLAY OUT PUT AS "323237232" 2). NEED TO ONLY "COMPANY.COM" FROM EMAIL FILED "TEST@COMPANY.COM"  8
when should one create lookup transformation ?  1
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.  1
Which type or t/s is used to convert rows into column & column into rows Infosys6
how do u implement scheduling in Informatica?  1
How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)  1
what is the indicator file and where it is used?  1
if u can't find what you are looking for in lookup table, how do you handle?  1
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.  2
When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.  3
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.  1
without using ETL tool can u prepare a Data warehousing and maintaining?  2
what is meant by drill through?(Mascot)  1
what are the different Reporting and ETL tools available in the market?  2
Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks  3
what are Lookup caches options? Including persistent caches.  1
Where can i get informatica certification Exam dumps and details? please forward it to emailid: krisboppana@yahoo.com NexGen157
what are the facilities provided by OLAP to analytical users?  1
Eliminating of duplicate records without using dynamic lookups IBM3
 
For more ETL Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com