what is filelist concept in informatica
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 |
if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
what is the difference between Informatica7.1 & informatica 8.1
how to create user defined function (udf) in informatica
Explain the shared cache and re-cache?
Differnce between filter and router?
Name 4 output files that informatica server creates during session running?
Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve
What are the data movement modes in informatcia?
How many number of sessions that u can create in a batch?
Explain scd type 3 through mapping.
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?