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

Explain the different lookup methods used in informatica?

0 Answers  

---

How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 Answers  

---

What is checksum termnology in informatica? Where do you use it ?

3 Answers   Chase, Cognizant, Deloitte,

---

without using rank transformation how can we rank items by using some other transformations

2 Answers  

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

0 Answers  

---

---

What is an active transformation?

0 Answers   Informatica,

---

how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,

---

In session log thier should not be a single error how will u do

3 Answers   HCL,

---

What are the reusable transforamtions?

2 Answers  

---

How can you run a session without using server manager?

1 Answers  

---

What are the out put files that the informatica server creates during the session running?

2 Answers  

---

How to create or import flat file definition in to the warehouse designer?

0 Answers   Informatica,

---