Answer / ram pothineni

select replace('"TCS"MUMBAI"','"',' ') from tab;

Answer / bob

Repacechr(1,""TCS"MUMBAI",'"',null)

Answer / chanakya123

Dear Chow,thanks for ur reply, the SQ reading "" only from
""TCS"MUMBAI",the rest of the part truncated,then how can u
use ltrim and rtrim, i tried it creating a mapping.

Answer / ramesh

replacechar(columnname,instr(columnname,'"',1,2),' ')

the instr function finds the position of the char i.e. " in the second occurence and 'replacechar' replaces it with null.

Answer / chow

we can do using ltrim and rtrim and concat two words

4 yrs etl devloper roles and responsibilities?any body give solutions

0 Answers   TCS,

what is difference between dimention table and fact table?

1 Answers  

What is the difference between informatica 7.0 and 8.0?

0 Answers  

Implementation methodology

0 Answers  

I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?

1 Answers   IBM,

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  

Define maping and sessions?

3 Answers  

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers   Polaris, Zensar,

if i have a delimited file as source so how can we seperate this file into three diff targets?

2 Answers   TCS,

Using Expression transformation how to remove duplicate records from a relational source?

4 Answers  

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

6 Answers   Accenture,

how to convert the .doc docs into .txt format using informatica

4 Answers