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
- 14497 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
list out all the transformations which use cache?
Difference between Data and Index Caches?
What is a transaction control transformation?
tell me the rules and responsblites in our project(my project is development)
To import the flat file definition into the designer where should the flat file be placed?
Differentiate between sessions and batches?
Partition, what happens if the specified key range is shorter and longer
How can we delete duplicate rows from flat files?
What is informatica? Why do we need it?
What is data transformation manager process?
What do you mean by channel change?
What is a stored procedure transformation?
Differentiate between a database and data warehouse?
Can we create multiple integration service on single repository?
Scheduling properties,whats the default (sequential)
