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
- 13422 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ram pothineni
select replace('"TCS"MUMBAI"','"',' ') from tab;
| Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
Mention some types of transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Sequence generator, when you move from develoment to production how will you reset
Which transformation is needed while using the Cobol sources as source definitions?
What is workflow monitor?
EXL informatica Questions
What are the main features of Oracle 8i with context to datawarehouse?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What will be the approach?
What is complex mapping?
Can we get 1st record through Informatica(without sequence number).
How to generate sequence numbers without using the sequence generator transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is aggregate cache in aggregator transformation?
Please let me know how to make Data masking in informatica..
