how many repositories can v create in informatica .
Answers were Sorted based on User's Feedback
Answer / manju
In Informatica 8.6 and above there can be mulitilple
repositories can be created under node.
The domain can have multiple nodes
| Is This Answer Correct ? | 29 Yes | 2 No |
Answer / amarnath
2 types of repositories can be created
1. standalone
2. Shared or Global repository
| Is This Answer Correct ? | 12 Yes | 4 No |
Answer / pankaj pandey
It will equal to limit of ports we can enter while creating
any repository. I dont remember limit but answer is
correct :)
| Is This Answer Correct ? | 3 Yes | 1 No |
scd methodology?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is fact table? Explain the different kinds of facts.
WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?
EXL informatica Questions
Did u used latest transformations of 8.6.0? for what?
scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS
How to start a workflow using pmcmd command?
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
In a table, 4 person having same salary. How to get Third person record only?
how much memory (size) occupied by a session at runtime
how can one eliminate dupliacte data with out using distinct option?