Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between repository & Intergration service
- 1 Answers
- 4712 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 |
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
how to join the 2 different table with different columns in informatica?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Differentiate between reusable transformation and mapplet.
What is souce qualifier transformation it is active or passive
We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??
Define joiner transformation?
How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 Answers TCS, Tech Mahindra,
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
what is the diff b/w cached and unchaed look ups
What are the tasks that can be performed using sq?
what is difference between dimention table and fact table?
Teradata 
