Interested to Buy Any Domain ? << Click Here >> for more details...
I have a source as flat file and having data like
""TCS"MUMBAI" and i want output like TCS MUMBAI,the length
of the data in the rows is variable.how can you fix it?
- 5 Answers
- 13583 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ram pothineni
select replace('"TCS"MUMBAI"','"',' ') from tab;
| Is This Answer Correct ? | 13 Yes | 3 No |
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
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.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / chow
we can do using ltrim and rtrim and concat two words
| Is This Answer Correct ? | 0 Yes | 4 No |
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
Why we require dwh in particular projects?
How to update a particular record in target with out running whole workflow?
Can you copy the session to a different folder or repository?
How to recover sessions in concurrent batches?
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?
Explain about Informatica server process that how it works relates to mapping variables?
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?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are the measure objects?
Teradata 
