what is filelist concept in informatica

Answers were Sorted based on User's Feedback



what is filelist concept in informatica..

Answer / gsr

When you are using Flat File source you usually get the
header files separately from the data files. You may get
source data in more than one file. In such cases you give
the paths of all the data files in one file for eg say
list.txt. This file is called the list file. In the session
edit task window instead of giving the source filename you
enter the name of the list file - list.txt and in source
filetype you make it indirect.

Is This Answer Correct ?    15 Yes 0 No

what is filelist concept in informatica..

Answer / shweta

When we use Flat file as a source we give the path of
directory where we store the file in Workflow.
But if we want data from multiple flat files then we put
the names of all flat files in a single file called as file
list.
In workflow mapping we give the path of list file and mark
the source filetype as INdirect as we are indirectly
accessing all the flat files.

Is This Answer Correct ?    6 Yes 0 No

what is filelist concept in informatica..

Answer / arockia

In File list is it possible to create seperate target files
for each input file?? Ex: My list.yxy contains :
datafile1.dat,datafile2.dat. I want target file needs to be
created as datafile1.out, datafile2.out..

Please help...

Is This Answer Correct ?    2 Yes 0 No

what is filelist concept in informatica..

Answer / shashiall

may b it is the path where our flat file is residing.we
have to give the total path at the place of the file
list...
plz...correct me if am wrong...

Is This Answer Correct ?    2 Yes 8 No

Post New Answer

More Informatica Interview Questions

What are the different transaction levels available in transaction control transformation?

0 Answers   Informatica,


How do you load first and last records into target table?

0 Answers  


How to configure mapping in informatica?

0 Answers  


What are set operators in Oracle

3 Answers   Deloitte, Wipro,


what type of problem you faced insales project or insurance project

1 Answers   Sony,






The question was on time stamp. what is the difference between HH and HH24 when to use when.

0 Answers   Nationwide,


can a port in expression transf be given the name DISTINCT

3 Answers  


What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers  


How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,


How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

7 Answers   iNautix,


How we can create indexes after completing the load process?

0 Answers  


What are the new features in Informatica 5.0?

1 Answers  


Categories