Interested to Buy Any Domain ? << Click Here >> for more details...
what is filelist concept in informatica
- 4 Answers
- 19769 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 r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
What do you mean by worklet?
How to delete the (flat file) data in the target table after loaded.
disable caching in a lookup transformation?
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?
100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
What is lookup change?
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
Explain the scenario which compels informatica server to reject files?
IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?
Teradata 
