Interested to Buy Any Domain ? << Click Here >> for more details...
I've an excel sheet, in which one column contains data about
the location like "City, State" and few columns contains
only "State". Now I wanna load into my target City and State
into two different columns. Pls help me out...
- 6 Answers
- 14540 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sandya
hi
if it is excel sheet, save as in CSV format, while importing
csv file in informatica designer, check 'Singlequotes' under
Text qualifier. it separates as both city and state in to
two columns which is in one column. after that double quotes
appear on the top of city and column. we can remove using
trim.previously i have tried this and got result.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is the difference between stop and abort in informatica
tell me the rules and responsblites in our project(my project is development)
In informatics server which files are created during the session rums?
Enlist some properties of sessions.
Which means the first record should come as last record and last record should come as first record and load into the target file?
What could be the possible resons of locks by user?
What are the new features of informatica 9.x in developer level?
Which transformation is needed while using the Cobol sources as source definitions?
Differentiate between joiner and lookup transformation?
without table how to come first record only in oracle?
What is the function of aggregator transformation?
What is incremental aggregation?
What is meant by query override?
Quickly characterize reusable change?
How to delete duplicate row using informatica?
