Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between repository & Intergration service
- 1 Answers
- 4459 Views
- I also Faced
- E-Mail Answers
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 |
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
What are mapplets?
wht target override?wht advantages it has compare to target update?
What is sql query override? When did u use sql query override?
wf dont have integration severances how you can run?
If informatica has its scheduler why using third party scheduler?
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
What is a mapplet/worklet in informatica?
What is Session and Batches?
Parameter and variable differences
Why is sorter an active transformation?
Are there any types of Dynamic Caches in informatica
Teradata 
