what is the difference between repository & Intergration service
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 are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
explain about session partitions ?
How do you handle decimal places while importing a flatfile into informatica?
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
What is the use of an aggregator cache file?
Can we insert and update a target table without using update strategy transformation?How?
What are the connected or unconnected transforamations?
what is lookup chache?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
What is the advantage of persistent cache? When it should be used.
How do you set a varible in incremental aggregation
if soource is having 10 records how will u insert 20 records to target