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 / 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
Which means the first record should come as last record and last record should come as first record and load into the target file?
What are the various types of transformation?
What are the components of Informatica? And what is the purpose of each?
What is domain and gateway node?
In informatica workflow manager, how many repositories can be created?
How do you load only null records into target? Explain through mapping flow.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is a transaction control transformation?
What will be the approach?
Separate from a database, an information bazaar, and an information stockroom?
how to load dimension table and fact table. plz tell me the steps.
How to do unit testing in informatica? How to load data in informatica ?
What you know about transaction control transformation?
explain one complex mapping with logic? sales project?
What is sq transformation?