How many repositories can we create in Informatica?
Answers were Sorted based on User's Feedback
Answer / snu
A single global repository and any number of local
repositories.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / nagaraj.g
we can create 200 repositories in informatica
| Is This Answer Correct ? | 1 Yes | 0 No |
What is status code in informatica?
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is CDC? How to implement CDC?
how u know when to use a static cache and dynamic cache in lookup transformation.
Define joiner transformation?
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
Why do you use Mapping Parameter and mapping variable?
i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?