What is the "File Repository" and how can we use that in the
Informatica ? Please give one example of the Process ?
waiting for Reply... Thank you .
Answer Posted / rabi mishra
Hi
as per my knowledge , indirect loading of more than one
source files with same meta data, needs a file repository
concept.
in which we create a new file , and stores the source
file absolute paths in that.we create one mapping with one
metadata. in session properties we give the source file
name as of the new file. and make the source load type
as 'indirect'.so as the session runs ,data from all the
files will be loaded with one go.
Hope this will satisfy ur Problem.
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
Does an informatica transformation support only aggregate expressions?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How an expression transformation differs from aggregator transformation?
How might one distinguish in the case of mapping is right or not without associating session?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
can we override a native sql query within informatica? How do we do it?
How can we store previous session logs?
Reusable transformation and shortcut differences
How do you handle two sessions in Informatica
What is a grid in Informatica?
What is rank transform?
which one is better performance wise joiner or look up
What is the different lookup cache(s)?
What is the meaning of decode in informatica?
what is the size ur source like(file system or database)? how many record daily come u r banking project?