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 / sankar
FOR THOSE FLAT FILE WE CREATE A LIST FILE.IN THAT LIST FILE
WE CAN ENTER FLAT FILE DIRECTRIES.
THEN GO TO SESSION
SOURCE TYPE:INDERECT
SOURCE DIRECTOTRY:LIST DIRECTORY
SOURCE FILENAME:LIST.TXT
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is meant by a domain?
If informatica has its scheduler why using third party scheduler?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is an active transformation?
How to create or import flat file definition in to the warehouse designer?
What are batches?
What do you mean by channel change?
How many dimensions are there in informatica?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is the different lookup cache(s)?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is a sorter transformation?
Enlist the advantages of informatica.
generate date / time dimension in informatica
can any one explain about dataflow in the informatica project for bank domain....thanks is advance