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 |
in which situations do u go for sequence generator ?
In warehouses how many schemas are there?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How many types of sessions are there in informatica.please explain them?
if the session fails after 100 records agian we have to starts the session or we go for recovery session
What do you mean by enterprise data warehousing?
What are two types of processes that informatica runs the session?
What are the guidelines to be followed while using union transformation?
What is decode in static cache?
Is there any model difference between ODS and DWH
Which will beter perform IIf or decode?
how to duplicates from expression transformation without using sorter before that