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
- 13260 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what is size of u r database?
How does a sorter cache works?
How many numbers of sessions can one group in batches?
Different qualification between a related rotate toward the sky and isolates look upward?
Explain sessions?
What is meant by target load plan?
In which transformation you cannot drag ports into it?
design of staging area?
what is the size of u r source(like file or table)?
What is the difference between STOP and ABORT options in Workflow Monitor?
How are the sources and targets definitions imported in informatica designer?
What is informatica etl tool?
Define filter transformation?
How do you load alternate records into different tables through mapping flow?
How to partition the Session?
