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 .
- 4 Answers
- 11775 Views
- I also Faced
- E-Mail Answers
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 |
Target increases every day even though no new record was inserted
What is an unconnected transformation?
How can we store previous session logs?
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
Different qualification between a related rotate toward the sky and isolates look upward?
Whats there in global repository
How can yoU create or import flat file definition in to the warehouse designer?
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
how to identify new and old values in source qualifier or any other transformations using informatica
What do you mean by filter transformation?
What are the join types in joiner transformation?
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
Teradata 
