Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between repository & Intergration service
- 1 Answers
- 4569 Views
- I also Faced
- E-Mail Answers
Answer Posted / skg
what is the difference between repository & Integration service?
Repository: consist of original data base tables which are also called as system tables and metadata objects.
Ex:Actual source data (customers data,employee data,sales data)
Repository service: Repository service is responsible for inserts,updates,deletes and retrieve metadata from Repository. so it will work like mediator between the Repository and Integration Service(client components).
Ex: if you want to extract the data from Repository(actual data) at run time through Integration service you'll get an error because IS doesn't understand the System tables directly so you will need Repository service to handle inserts,updates,deletes and retrieve the data from Repository.
Integration Service: IS is responsible for executing the ETL Objects and performs Extraction,Transformation and Loading at Run time(while executing the session).IS needs Original database objects using objects we can move the data from source to target as per the requirements.
Ex: if you have a business requirements like calculations and conversions all these done by the IS.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the use of target designer?
What are the tasks that can be performed using sq?
What are the main features of Oracle 8i with context to datawarehouse?
What are the settings that you use to configure the joiner transformation?
What are the mapping parameters and mapping variables?
How many numbers of sessions can one group in batches?
What is a repository? And how to add it in an informatica client?
How can repository reports be accessed without sql or other transformations?
server hot-ws270 is connect to Repository B. What does it mean?
What are the different components of powercenter?
What is domain in terms of informatica?
what are 3 tech challenges/ common issues you face?
scenario where i can use only concurrent execution of workflow.
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Explain Dataware house architecture .how data flow from intial to end?
