Interested to Buy Any Domain ? << Click Here >> for more details...
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...
- 6 Answers
- 14528 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
What are the mapping parameters and mapping variables?
How can you access the remote source into your session?
What are the active and passive transforamtions?
what are the types of facts with Examples?
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
In target table how to display the system time
is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?
what is procedure to use mapping variable in source qualifier transformation? with example
Router T/R is active but some people are saying it is also passive which is exactly right?
HOW DO YOU CONNECT TO REMOTE SERVER ?
According to his methodology what all you need before you build a datawarehouse
Teradata 
