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...
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
Define enterprise data warehousing?
What is union transformation in informatica?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Explain constraint based loading in informatica
What are the different lookup cache(s)?
What is rank index in rank transformation?
When do you use sql override in a lookup transformation?
What are mapplets? How is it different from a Reusable Transformation?
EXL informatica Questions
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Enlist the differences between database and data warehouse.
In informatics server which files are created during the session rums?
How do you load only null records into target?
wf dont have integration severances how you can run?
What is a snowflake schema?