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.

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.

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.

Answer / informatica-user

use excel driver

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

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

i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

3 Answers  

What are the Differences between static cache and dynamic cache?

1 Answers  

Differences between connected and unconnected lookup?

0 Answers  

From where we can start or use pmcmd?

3 Answers  

complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,

I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..

2 Answers   DELL,

What are active transformations.

0 Answers  

Can we get 1st record through Informatica(without sequence number).

0 Answers  

Which transformation should u need while using the cobol sources as source defintions?

2 Answers  

Difference Between ETL & ELT?

1 Answers   TCS,

what are the types of Data warehousing ?

1 Answers  

What are variable ports and list two situations when they can be used?

1 Answers