Answer Posted / pr
The default join is inner join. But we can override it by using the SQL overide query and can perform any joins
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the guidelines to be followed while using union transformation?
What is the difference between a repository server and a powerhouse?
Explain the use of aggregator cache file?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is informatica? Why do we need it?
What is sequence generator transformation in informatica?
Differentiate between sessions and batches?
What all join we can perform in LOOKUP transformation?
How do you load unique records into one target table and duplicate records into a different target table?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is expression transformation?
What is meant by active and passive transformation?
How to generate sequence numbers?
What is the function of look up transformation?
have u done any performance tuning? how u ll do?