In Joiner Transformation, how to identify the master and
detail tables if one is from Oracle and the other is from
Sybase.
Answer Posted / priyank
Its completely on a developer's discretion to decide which
source would be the master and which would be the detail.
Generally keeping in mind the performance factor, we tend to
make the source with less number of ports as the master.
| Is This Answer Correct ? | 11 Yes | 4 No |
Post New Answer View All Answers
What is aggregate cache in aggregator transformation?
Make a note of the quantity vaults made in informatica?
Tell me about MD5 functions in informatica
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
where to store informatica rejected data? How to extract the informatica rejected data?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Describe data concatenation?
How we can create indexes after completing the loan process?
Explain Dataware house architecture .how data flow from intial to end?
what is SDLC way of code development?
Explain the use of aggregator cache file?
What do you mean by blocking transformation?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
whats the logic to load the lower level of granularity of data to fact table.
What is Data Caches size?