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...

Answers were Sorted based on User's Feedback



I've an excel sheet, in which one column contains data about the location like "City, Sta..

Answer / sandya

hi
if it is excel sheet, save as in CSV format, while importing
csv file in informatica designer, check 'Singlequotes' under
Text qualifier. it separates as both city and state in to
two columns which is in one column. after that double quotes
appear on the top of city and column. we can remove using
trim.previously i have tried this and got result.

Is This Answer Correct ?    7 Yes 0 No

I've an excel sheet, in which one column contains data about the location like "City, Sta..

Answer / 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

I've an excel sheet, in which one column contains data about the location like "City, Sta..

Answer / 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

I've an excel sheet, in which one column contains data about the location like "City, Sta..

Answer / informatica-user

use excel driver

Is This Answer Correct ?    0 Yes 0 No

I've an excel sheet, in which one column contains data about the location like "City, Sta..

Answer / 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

I've an excel sheet, in which one column contains data about the location like "City, Sta..

Answer / abhishek

hey friend
as i know we can not import excel sheet in informatica.
your qustion is this or something else?please elaborate
this

Is This Answer Correct ?    0 Yes 7 No

Post New Answer

More Informatica Interview Questions

what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,


Can we update a target table (without primarykey) by using update strategy transformation?

4 Answers   TCS,


Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?

1 Answers  


What are set operators in Oracle

3 Answers   Deloitte, Wipro,


While importing the relational source defintion from database,what are the meta data of source U import?

1 Answers  






Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?

4 Answers  


what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  


What are Dimensions and various types of Dimensions?

3 Answers   PayPal, TCS,


how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,


i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  


what are the perameter and variable?

3 Answers   IBM,


I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,


Categories