1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / sribyras

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 are reusable transformations in how many ways we can create them?

2 Answers  

what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,

Why update strategy and union transformations are active?

0 Answers  

Can you copy the session to a different folder or repository?

1 Answers  

How to recover sessions in concurrent batches?

1 Answers  




How do you manage the Parameter files while migrating your data from one environment to another environment?

0 Answers  

What are the reusable transforamtions?

2 Answers  

Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

4 Answers   TCS, Wipro,

Is it possible to update the target table with PK?

1 Answers   TCS,

tell me 5 session failure in real time how can you solve that in your project?

0 Answers   CSC,

How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.

3 Answers   Eureka Forbes,

source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.

4 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories