Interested to Buy Any Domain ? << Click Here >> for more details...
what is filelist concept in informatica
- 4 Answers
- 19958 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
What the difference is between a database, a data warehouse and a data mart?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
what is bridge tables in informatica
how to duplicates from expression transformation without using sorter before that
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
Explain the features of connected and unconnected lookup.
Insert else update option in which situation we will use
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
Mention few power centre client applications with their basic purpose?
Teradata 
