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
- 12922 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
How to delete duplicate row using informatica?
How can you differentiate between powercenter and power map?
What are the different options available for update strategy?
What is repository manager?
What is intricate mapping?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
Partition, what happens if the specified key range is shorter and longer
What is meant by lookup transformation? Explain the types of lookup transformation?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Explain the different kinds of facts.
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
