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
- 14819 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
Explain the different dimensions.
What is an unconnected transformation?
pmscmd startworkflow -sv
What is a filter transformation?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Enlist the advantages of informatica.
How can you generate reports in informatica?
What are the main issues while working with flat files as source and as targets ?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Define sessions in informatica etl?
What could be the possible resons of locks by user?
