Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between repository & Intergration service
- 1 Answers
- 4568 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 |
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?
What are the different tools in workflow manager?
What are the different types of olap? Give an example?
Different qualification between a related rotate toward the sky and isolates look upward?
can we generate reports in informatica ? How?
following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
Which transformation should we use to normalize the COBOL and relational sources?
4 Answers DELL, IBM, Lehman Brothers,
Which means the first record should come as last record and last record should come as first record and load into the target file?
why we use datawarehouse
Can we have a Mapping without a Source Qualifier?
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
Teradata 
