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
- 14754 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What do you understand by term role-playing dimension?
What is meant by active and passive transformation?
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?
What is the use of transformation?
Is stop and abort are same in informatica?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is the benefit of partitioning a session?
What are the differences between joiner transformation and source qualifier transformation?
How to update a particular record in target with out running whole workflow?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Differentiate between router and filter transformation?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What do you mean incremental aggregation?
Explain the aggregator transformation?
EXL informatica Questions
