Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between repository & Intergration service
- 1 Answers
- 4603 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 rank transformation?
What are connected or unconnected transformations?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
define galaxy repository in informatica
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How would you join a node to the already existing domain?
What is the use of code page?
Please let me know how to make Data masking in informatica..
where to store informatica rejected data? How to extract the informatica rejected data?
How to open an older version of an object in the workspace?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain direct and indirect flat file loading (source file type) - informatica
Can we get 1st record through Informatica(without sequence number).
lookup transformation with screenshots
Can we create multiple integration service on single repository?
