Interested to Buy Any Domain ? << Click Here >> for more details...
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??
- 9 Answers
- 14463 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / harish konda
Yes we can load all these flat files in a single session.
First create a txt file and in that give all the file names
along with their PATH.
Drag any one of the flat file into the mapping and link it
to the target acc. to your requirement.
And in the session properties give the file type as Indirect
and in Filename option, give the file name(along with the
path) of the file in which you gave all the paths.
Then run the mapping.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to load dimension table and fact table. plz tell me the steps.
how tokens will generate?
What are some examples of informatica etl programs?
Explain the shared cache and re-cache?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How we can create indexes after completing the loan process?
How to delete duplicate row using informatica?
How to implement security measures using repository manager?
Differentiate between a repository server and a powerhouse?
can you please explain me pre session and post session options?
What is the format of informatica objects in a repository?
permutations of mapplet
Is it possible to use a client with different version than that of its Informatica server?
Slowly changing dimensions, types and where will you use them
What are the types of lookup transformation?
