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 |
Which one is better performance wise connected/un-connected lkp?why?
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
What is the role of informatica in project ?Like i showed financial projects?
What are the different components of powercenter?
Difference Between ETL & ELT?
what is index?how it can work in informatica
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
How do you change a non-reusable transformation to reusable transformation?
How can i set break points in debugging mode ? can explain steps please?
Differentiate between a database and data warehouse?
How the informatica server increases the session performance through partitioning the source?