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

What is the fact table?

0 Answers  

---

How will you update the first four rows and insert next four rows in a mapping?

5 Answers   CTS,

---

How many ways are there to do 'remove duplicate records in informatica'?

0 Answers  

---

what is the difference between static and dynamic

4 Answers   TCS, Wipro,

---

How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers  

---

---

How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

1 Answers   Wipro,

---

wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,

---

insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 Answers  

---

1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers   Cap Gemini,

---

connected and unconnected lookups?

4 Answers  

---

tell me 7.x and 8.x diferrencess(but not transformations)

1 Answers  

---

If there are more than one sessions running parallel in a worklet, which will be the last session ?

2 Answers  

---