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 .
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kasi g
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.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / tomar
Hi ,
file repository concept having simple meaning that meta
data information can be stored in flat file nstead of
relational tables.ABINITIO is the first ETL tool in which
repository can be a flat file .Informatica 8x and own wards
having this facility
| Is This Answer Correct ? | 2 Yes | 6 No |
Is it possible to define a single node as a Gateway node as well as worker node?
How to improve the performance of Aggregate transformation?
What is mapping debugger?
normalizer transformation
what is the mechanism of the Master-Detail joining condition?
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.
Tell me one complex query in oracle ?
how to join the 2 different table with different columns in informatica?
what is the use of Data Mart?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?
Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks