There are n numbers of flatfile of exactly same format are
placed in a folder .Can we load these flatfile's data one
by one to a single relational table by a single session??

Answer Posted / srinu

Hi,,,TCS,,,
Have you attend Recently for TCS,,,?

You need to load 10flatfiles to One relational source,,?
You can keep 10flat files in a single folder.Just assign
the folder path as a Source path in SESSION PROPERTIES.
it will make it 1 flatfile source.
By a simple Mapping,make it single Relational source.

Any corrections,,,,,srinu.srinuvas@gmail.com

Is This Answer Correct ?    4 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of an aggregator cache file?

699


Where can we find the throughput option in informatica?

611


Performance tuning in UNIX for informatica mappings?

2158


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1328


Whats the difference between informatica powercenter server, repositoryserver and repository?

692






How do you load only null records into target? Explain through mapping flow.

1516


How many dimensions are there in informatica?

640


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1707


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1065


Define the various join types of joiner transformation?

569


What are the types of data warehouses?

956


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1511


What is the sequence generator transformation in informatica?

625


What happens when a session fails and you click on recover?

669


What is status code in informatica?

594