what types of repositories we can create in informatica?
in real time in which type of repository we will work on?
Answers were Sorted based on User's Feedback
Answer / prasanthi
There are two types of repositories
LOCAL REPOSITORY:The metadata can be shared within the
repository.
GLOBAL REPOSITORY:The metadata can be sharable across the
repositories.
In real time we will work on global repositories
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / harish
There are 2 types of repositories
1)Globel
in n tire arcth Globel repositories aer used
2)local
which is Configured for single system only
| Is This Answer Correct ? | 2 Yes | 1 No |
In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
what is the advantage of persistent cache? when it should be used?
Explain about the data integration suite features?
what are the different Reporting and ETL tools available in the market?
what is different between sequential batch and concurrent batch and which is recommended and why?
what are the concerns of OLTP and DSS systems?
How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
Can u access a repository created in previous version of Informatica?
Do we need an ETL tool? When do we go for the tools in the market?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance