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 |
What is the default join that source qualifier provides?
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
What are your source in project and how you import in informatica? How can i explain abt this?
1 Answers Accenture, Unisoft Infotech,
What is meant by lookup transformation? Explain the types of lookup transformation?
how to through logic of informatica using the push down optimization into oracle.
What is predefined event?
How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?
How you load distinct records into one target and duplicate records into another target?
Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation
What is informatica etl tool?
What is a candidate key?
wat s mapping parameter and mapping variable? how do you set that in a mapping?