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
- 14539 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / nagraju bhatraju
We can't import excel sheet directly in to informatica,
instead , we have to save that file in .csv(Comma Separated
Value Formatt) and then we can use or analyze in
informatica environment.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between STOP and ABORT options in Workflow Monitor?
How to implement security measures using repository manager?
How many numbers of sessions can one group in batches?
What is complex mapping?
How to create Target definition for flat files?
What is workflow? What are the components of the workflow manager?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is a sequence generator transformation?
Is it possible to revert a global repository to local one and why?
Is it possible to define a single node as a Gateway node as well as worker node?
What are the informatica performance improvement tips
What is repository manager?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How to generate sequence numbers using expression transformation?
How to load data in informatica ?
