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

Howmany ways yoU can update a relational source defintion and what are they?

1 Answers  

how to run the batch using pmcmd command

2 Answers   Wipro,

Explain sessions. Explain how batches are used to combine executions?

0 Answers  

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,

How will u pas the data with out debugger?

4 Answers  




Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?

1 Answers  

server hot-ws270 is connect to Repository B. What does it mean?

0 Answers   Cognizant,

How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

0 Answers   HCL,

Which kind of index is preferred in DWH?

2 Answers  

In which transformation you cannot drag ports into it?

0 Answers   Informatica,

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

2 Answers   CTS,

For more Informatica Interview Questions Click Here
Categories