| Back to Questions Page |
| |
| 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" |
Rank |
Answer Posted By |
|
Question Submitted By :: Sreedhar |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | 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  |
| Kumar
|
| |
| |
| Answer | use TRANSLATE function
select
translate ('323-237-2323','0123456789-', '0123456789')
from table_name; |
| Bilas
|
| |
| |
| Answer | 2)if findc(emailid,'@','company.com')=0 then
emailid=emailid; |
| Erqf
|
| |
| |
|
|
| |
| Answer | replace ('323-237-2323','-', '') |
| Kumaravelu
|
| |
| |
| Answer | substr('TEST@COMPANY.COM',instr('TEST@COMPANY.COM','@')+1) |
| Kumaravelu
|
| |
| |
| Answer | select replace ('323-237-2323','-') from dual
select substr('abc@co.com',-7) from dual |
| Kkr
|
| |
| |
| Answer | select trim(replace('2-3-4','-',NULL)) from dual |
| Kuttu
|
| |
| |
| Answer | select substr('12132@dfsaf.com',
instr('12132@dfsaf.com', '@')+1,
length('12132@dfsaf.com'))
from dual |
| Again Kuttu!!
|
| |
| |
| Question |
we have 1 source table containing 100 records. now we have
to transfer first set of 1-10 (i.e1-10) records to one
target table and another set of 1-10(11-20) records to
other target table and continue like that till 100th record |
Rank |
Answer Posted By |
|
Question Submitted By :: Coolani |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | we can use the sql below to indicate the rownum.
then router the data according to the rownum from upstream.
select t.*,rownum rn from test t
where mod(floor(t.rn/10),2) =0 --get the rows whose rownum
between 1~9,20~29,etc.
|
| Zslstar
|
| |
| |
| Question |
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
|
Rank |
Answer Posted By |
|
Question Submitted By :: Amrita |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | The simplest thing U can do is
while importing the source flatfile using "Flat File Import
Wizard"
In Step1 choose-> FixedWidth
in the step2 -> click and create a column or tab on the
field then U can import them as 2 fields
1. 01/08/2008
2.(DD/MM/YYYY)
U can ignore the second column and use the first one.
second method is by taking only the date value in
Expression Transformation.
Hope this of any help
Kal |
| Kal
|
| |
| |
| Answer | In expression transfromation
to_date(datecolumnname,dd/mm/yyyy) and pass this link upto
target |
| Bhagya
|
| |
| |
| Answer | if you require only 5 rows in the target we can use 5
target aliases and acheive it. |
| Kuttu
|
| |
| |
|
| |
|
Back to Questions Page |
Site Map
