Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between repository & Intergration service
- 1 Answers
- 4460 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
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Explain the use of aggregator cache file?
what is $$$$?
How to elaborate tracing level?
As union transformation gives UNION ALL output, how you will get the UNION output?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Clarify the utilization of aggregator cache record?
I have a flat file, want to reverse the contents of the flat file
Can informatica load heterogeneous targets from heterogeneous sources?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is the need of an ETL tool?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
