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

What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,

What is joiner cache?

2 Answers   TCS,

What is Collect performance data in informatica and what is the use of it.

1 Answers   Informatica,

any body can say about all versions of informatica ?how many versions ?

2 Answers  

What is the Rank index port in Rank transformation?

0 Answers   Informatica,

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

2 Answers   Sapient,

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,

Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance

1 Answers  

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  

How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  

How you can differentiate between connected lookup and unconnected lookup?

0 Answers  

What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?

0 Answers   CTS, Wipro,