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

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?

3 Answers   HP,

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

0 Answers  

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

how to run 2 workflows sequentially. plz respond what is the process?

9 Answers   Cap Gemini, Target,

What do you understand by term role-playing dimension?

0 Answers  

If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 Answers  

How the facts will be loaded? explain

2 Answers   HCL,

error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.

4 Answers  

my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,

what is diff b/t sorter t/r and agg have the option sorter property...

0 Answers  

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.

1 Answers   IBM,