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
- 12918 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 are the limitations of joiner transformation?
What is a difference between complete, stop and abort?
What are the main features of Oracle 8i with context to datawarehouse?
While migrating the data from one environment to another environment how would you manage the connections?
Whats there in global repository
Describe an informatica powercenter?
What are the informatica performance improvement tips
What are the new features of Power Center 5.0?
Enlist few areas or real-time situations where informatica is required.
What is dimensional table?
How would you copy the content of one repository to another repository?
What are ETL Tools?
Explain the code page compatibility?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What does command task mean?
