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

Answer Posted / informatica-user

use excel driver

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to load rows into fact table in data warehouse

634


How can we delete duplicate rows from flat files?

733


Partition, what happens if the specified key range is shorter and longer

2026


What are the different components of powercenter?

575


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

532






What is the surrogate key?

627


What are the steps involved in the migration from older version to newer version of Informatica Server?

1572


What are the basic requirements to join two sources in a source qualifier transformation using default join?

609


hi real timers . iam waiting for ur reply regarding ETL TESTING

1798


can u give example for factless fact table

5505


What are the features of complex mapping?

635


What is an expression transformation in informatica?

513


differences between service based and product based?

1560


What is a node in Informatica?

615


What are the modules in Power Center

1218