Explain what is power center repository?
Answer / Rajesh Singh Rana
PowerCenter Repository is a database used by Information Server PowerCenter, a data integration and transformation tool developed by Informatica. The repository stores metadata related to the sources, targets, transformations, sessions, and workflows.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain when do we analyze the tables? How do we do it?
How can we run the graph? What is the procedure for that?
What is the difference between mapping parameter & mapping variable in data warehousing?
What is an error log table in informatica occurs and how to maintain it in mapping?
What is the metadata extension?
What is perform recovery?
What are the design methods of data warehousing?
What is difference between query studio and report studio?
Can any one explain the hierarchies level data warehousing.
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
What are the fundamental elements of the data warehouse?
What is loop in data warehousing?