1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

my source contain data like this
cno cname sal
100 rama@gmail.com 1000
200 karuna@yahoo.com 2000
i want load my data to the target is
cno cname sal
100 rama 1000
200 karuna 2000
plz send the answer

Question Posted / sravanthirao64@gmail.com

Answers were Sorted based on User's Feedback



my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yaho..

Answer / krishna

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

Is This Answer Correct ?    19 Yes 3 No

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yaho..

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

Is This Answer Correct ?    3 Yes 0 No

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yaho..

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

Is This Answer Correct ?    0 Yes 0 No

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yaho..

Answer / shweta123

In the expression transformation use the following
function :

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

Is This Answer Correct ?    0 Yes 0 No

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yaho..

Answer / c

In the expression transformation use the following:

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

Is it possible to revert a global repository to local one and why?

0 Answers  

What is lookup transformation?

0 Answers  

who is the best faculty for informatica in hyderabad ameerpet?

1 Answers  

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

0 Answers  

What are the uses of a Parameter file?

3 Answers   CSC,




Explain constraint based loading in informatica

0 Answers   Informatica,

What is Data Caches size?

0 Answers   Informatica,

What are the challenges you have faced in your project?

1 Answers   Cognizant, Infosys,

What is an unconnected transformation?

0 Answers   Informatica,

how will you get 21 to 30 record from 50 records?

6 Answers  

on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

4 Answers   Fidelity,

Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar

11 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories