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


Please Help Members By Posting Answers For Below Questions

Is it possible to revert a global repository to local one and why?

615


Define joiner transformation?

596


I have a flat file, want to reverse the contents of the flat file

695


What are pre and post-session shell commands?

741


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?

1240






What is the maplet?

622


What are the types of schemas we have in data warehouse.

531


What you know about transaction control transformation?

559


Differentiate between source qualifier and filter transformation?

1000


difference between repository database and repository service?

626


What is a mapplet/worklet in informatica?

692


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?

1467


tell me about your project functionality

1868


How identifying bottlenecks in various components of informatica and resolving them?

587


What is target designer and target load order?

659