Answer / krishna

select substr(cname,1,instr(cname,'@')-1) from table name

Answer / abhinaw prakash

1.Pass the coulmns to an expression transformation.
2.Create a variable port and use INSTR function to find the
location of @.
(INSTR(CNAME,'@')-1)
3.Create an output port and use SUBSTR function to extract
the substring from the string.
SUBSTR(CNAME,1,v_CNAME)
4.Pass it to the output port

Answer / sehaj

DO ONE THING....
CREATE AN EXTRA PORT FOR THAT.
IN THE EXPRESSION EDITOR,WRITE

REPLACESTR(0,cname,(SUBSTR(cname,INSTR(cname,'@'),INSTR(cname,'m',-1,1)),'')

PASS THIS PORT TO THE OUTPUT PORT......


SEHAJ-7204719446

Answer / shweta123

In the expression transformation use the following
function :

substr(name,1,(length(name) - instr(name,@,-1,1)))

Answer / c

In the expression transformation use the following:

select cno,substr(cname,1,position('@' in cname)-1)as cname,sal from sample

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

0 Answers   HCL,

How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 Answers  

where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  

What are the designer tools for creating transformations?

0 Answers   Informatica,

Insert else update option in which situation we will use

4 Answers   HCL,

what is diff between IN and EXIT commands

1 Answers   HCL, Schneider,

tell me about your project functionality

0 Answers  

What do mean by local and global repository?

0 Answers  

can we override a native sql query within informatica? How do we do it?

0 Answers  

What are the joiner caches?

3 Answers   Informatica,

What is the reusable transformation?

0 Answers  

what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers