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
- 13437 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 |
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
what is the difference between static and dynamic
i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?
Explain informatica architecture - version 8 / 9
how we can update a target table without update strategy and update override?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
What are the mapping paramaters and mapping variables?
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.
What are the new features of informatica 9.x in developer level?
why we r using presql&postsql in source qualifier?
Teradata 
