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
- 14817 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / krishna
for importing data from an excel file you have to open the
excel file and define it first. then from informatica you
can invoke import from excel option. but the question is
something like how to divide a column data into two viz.,
city and state. probably you have to use a function like
to_char to convert the data or trim to cut the state part
and so on.........
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How can we remove the duplicates from flat file source?
Define pmcmd command?
What is aggregator transformation in informatica?
What is a filter transformation and why it is an active one?
What is sequence generator transformation in informatica?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Can you generate sequence numbers without using the sequence generator transformation?
Different qualification between a related rotate toward the sky and isolates look upward?
What is meant by incremental aggregation?
What are connected or unconnected transformations?
What do think which one is the better joiner or look up?
What are the designer tools for creating transformations?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Clarify the aggregator change?
Explain sql transformation in script mode examples in informatica
