how many repositories can v create in informatica .
Answer Posted / amarnath
2 types of repositories can be created
1. standalone
2. Shared or Global repository
| Is This Answer Correct ? | 12 Yes | 4 No |
Post New Answer View All Answers
Explain lookup transformation in informatica
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Differentiate between source qualifier and filter transformation?
Difference between Target-based loading and constraint-based loading?
What is option by which we can run all the sessions in a batch simultaneously?
What is an active transformation?
Explain about Informatica server process that how it works relates to mapping variables?
Can you use flat files in Mapplets.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
scenario where i can use only concurrent execution of workflow.
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the format of informatica objects in a repository?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?