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
- 14988 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
What is enterprise data warehousing?
What are the differences between a connected lookup and unconnected lookup?
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 ?
Where do we use mapping variables in informatica?
How you prepared reports for OLAP?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How do you load only null records into target? Explain through mapping flow.
How to create Target definition for flat files?
Differentiate between source qualifier and filter transformation?
What do you mean by worklet?
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. ?
Have you worked with/created Parameter file
How to call shell scripts from informatica?
What is Data Caches size?
what are the deliverables?in your project?
