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

Under what conditions selecting sorted input in aggregator will still not boost session performance?

0 Answers  

one source to target loading insert new rows and update existing rows?

3 Answers   Polaris,

How to create the source and target database connections in server manager?

0 Answers   Informatica,

what is mapping parameter and mapping variables

1 Answers   BirlaSoft,

What are the types of data that passes between informatica server and stored procedure?

1 Answers   Informatica,

In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

2 Answers  

What is difference macros and prompts?

2 Answers  

Can you start a session inside a batch individually?

2 Answers  

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

0 Answers   TCS,

What are the mapping paramaters and mapping variables?

1 Answers  

Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....

2 Answers  

my session have to run Monday to Saturday not run sunday how to sedule in informatica level?

1 Answers   Infinite Computer Solutions,