Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between repository & Intergration service
- 1 Answers
- 4615 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 |
what is a junk dimension ?
14 Answers Atos Origin, Cognizant, HS, NIIT, TCS,
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
explain about unit testing? in real time?
What does refresh system mean, and what are its distinctive choice?
Separate from a database, an information bazaar, and an information stockroom?
Is snow flake or star schema used? If star schema means why?
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
A session S_MAP1 is in Repository A. While running the session error message has displayed
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is the difference between router and filter?
where to store informatica rejected data? How to extract the informatica rejected data?
What are the different types of schemas?
Teradata 
