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
- 14522 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sireesh
hiii, We can Import data from the Excel sheet If the Excel
ODBC drivers are installed (check the manual in Informatica
7.x). It Would be great to hear from some one regarding
splitting one column into two columns.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
While migrating the data from one environment to another environment how would you manage the connections?
Did u used latest transformations of 8.6.0? for what?
draw informatica architecture 8.6 ?
What is session task and command task?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
In informatics server which files are created during the session rums?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Differentiate between Load Manager and DTM?
What is the Rank index port in Rank transformation?
What is an expression transformation?
what is index?how it can work in informatica
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is Cognos script editor?
differences between service based and product based?
