what is the difference between repository & Intergration service
- 1 Answers
- 3686 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
Please let me know how to make encryption and decryption with example?
what is INFORMATICA TESTING process
Enlist the tasks for which source qualifier transformation is used.
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Explain the etl program with few examples.
if we have a delimiters at unwanted places in a flat file how can we over come those.
How to differentiate between the active and passive transformations?
How can we use mapping variables in informatica? Where do we use them?
What is different between the data warehouse and data mart?
Briefly define a session task?
What is data transformation manager process?
What are different types of transformations available in informatica?
How to update source definition?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How union transformation is used?
