Define informatica repository?
Answers were Sorted based on User's Feedback
Answer / j.david sukeerthi kumar
Hi
Informatica repository is a central meta-data storage place,
which contains all the information which is necessary to
build a data warehouse or a data mart.
Meta-data like source def,target def,business
rules,sessions,mappings,workflows,mapplets,worklets,database
connections,user information, shortcuts etc
Is This Answer Correct ? | 15 Yes | 0 No |
What is the commit type if you have a transaction control transformation in the mapping?
tell me 5 session failure in real time how can you solve that in your project?
Explain sessions and how many types of sessions are there?
can we override a native sql query within informatica? Where do we do it? How do we do it?
WHAT IS FACT TABLES?
During the running session, output files are created by informatica server. Enlist few of them.
how many ways can we implement SCD2?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is Datadriven?
Can we create out put ports in source qualifier t/r?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Which kind of index is preferred in DWH?