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 |
What is update strategy transform?
What is best approach to load 100 different source files (Different structure) to differet target tables ?
what is data driven?
What is the difference between router and filter?
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.
How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
Which kind of index is preferred in DWH?
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project
Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?
What are the rank caches?