How many repositories can we create in Informatica?
Answer Posted / snu
A single global repository and any number of local
repositories.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Whats there in global repository
State the differences between sql override and lookup override?
What is primary and backup node?
What can we do to improve the performance of informatica aggregator transformation?
How can informatica be used for an organization?
What is the need for an etl tool?
Explain what are the different versions of informatica?
Explain in detail scd type 2 through mapping.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How do you promote a non-reusable transformation to reusable transformation?
How do you load first and last records into target table?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?