Why you use repository connectivity?
Answers were Sorted based on User's Feedback
Answer / swetha
When you edit, schedule the sesion each time, informatica
server directly communicates the repository to check whether
or not the session and users are valid. All the metadata of
sessions and mappings will be stored in repository.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / satishkumar kundeti
When you edit, schedule the sesion each time, informatica
server directly communicates the repository to check whether
or not the session and users are valid. All the metadata of
sessions and mappings will be stored in repository.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ravi
The repository is a relational database that stores
information or metadata used by the informatica server and
client tools. The metadata stores the information regarding
mappings,mapplets,sessions,batches,shortcuts,source
definitions,target definitions and many more...
| Is This Answer Correct ? | 0 Yes | 5 No |
Why should we use star schema in datawarehouse design?
i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.
How might one distinguish in the case of mapping is right or not without associating session?
generate date / time dimension in informatica
What is an aggregator transformation?
What is a poling?
What are the advantages of informatica?
hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?
In dimension and fact table? which one holds big data?
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
How the Informatica Server reads perameter file?
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 ?