Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between repository & Intergration service
- 1 Answers
- 4610 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
Reusable transformation and shortcut differences
tell me 5 session failure in real time how can you solve that in your project?
what is the Default Source Option For Update Strategy Transformation?
What is olap (on-line analytical processing?
Why do we need informatica?
Where can we find the throughput option in informatica?
What are active transformations.
What is the Rank index port in Rank transformation?
permutations of mapplet
explain one complex mapping with logic? sales project?
How would you join a node to the already existing domain?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is an Integration service in Informatica?
What are the restrictions of union transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
