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
Explain pmcmd command usage in informatica
What are the components of the workflow manager?
Explain Dataware house architecture .how data flow from intial to end?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How does the aggregator transformation handle null values?
how to load rows into fact table in data warehouse
What are active and passive transformations?
what is size of u r database?
define galaxy repository in informatica
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Explain the scenario which compels informatica server to reject files?
What are the tasks that can be performed using sq?
What is a dimensional model?
draw informatica architecture 8.6 ?
What is the procedure for creating independent data marts from informatica 7.1?