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 / amarnath
create a file list which is nothing but simple .txt file
which contains the name of the each file u want to load and
in session properties make source file as "indirect" and
give the path of the file list that u have created and run
the wkf
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain what are the different versions of informatica?
Explain incremental aggregation in informatica
What does reusable transformation mean?
What is the difference between writing a joiner query in ANSI style and THETA style?
Explain what transformation and how many are there in informatica?
without table how to come first record only in oracle?
How do you migrate data from one environment to another?
What are the prerequisite tasks to achieve the session partition?
What is joiner transformation?
explan ur project architecture?
Where can we find the throughput option in informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is transformation?
How to call shell scripts from informatica?
How to create Target definition for flat files?