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

Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers  

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  

Major difference between SQL override and Lookup Sql override

1 Answers  

I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

4 Answers   HCL,

One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?

2 Answers  

How You Pull the records on daily basis into your ETL Server.

2 Answers   TCS,

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

3 Answers  

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

4 Answers  

Are there any types of Dynamic Caches in informatica

4 Answers   Accenture,

what is work of PUSH DOWN option

2 Answers   Wipro,

one source to target loading insert new rows and update existing rows?

3 Answers   Polaris,

what is filelist concept in informatica

4 Answers