how to import multiple flat files in to single target where
there is no common column in the flat files
Answer Posted / ramana sreepathi
in workflow session properties in Mapping tab
in properties
choose Source filetype Indirect
Give the Source filename : <file_path>
This <file_path> file should contain all the multiple files
which you want to Load
Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
Is it possible to revert a global repository to local one and why?
Define joiner transformation?
I have a flat file, want to reverse the contents of the flat file
What are pre and post-session shell commands?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is the maplet?
What are the types of schemas we have in data warehouse.
What you know about transaction control transformation?
Differentiate between source qualifier and filter transformation?
difference between repository database and repository service?
What is a mapplet/worklet in informatica?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
tell me about your project functionality
How identifying bottlenecks in various components of informatica and resolving them?
What is target designer and target load order?