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

How does a sorter cache works?

0 Answers  

Difference between Target-based loading and constraint-based loading?

0 Answers  

in a table it has 200 rows the query is select 150 from tablename.whats the output

2 Answers   Cap Gemini,

how many data models u have done in informatica project?

2 Answers   TCS,

What did you do in source pre load stored procedure

1 Answers  

how do the project develops? pls specify right from the start to end in step by steps.

0 Answers   ITC Infotech,

What is the difference between router and filter?

0 Answers  

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,

I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.

3 Answers   Amdocs,

Reusable transformation and shortcut differences

0 Answers  

two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

10 Answers   HP, Patni,

In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?

4 Answers