without matching columns in two tables. how can you join
Answer Posted / sarthak
U can't join two tables (without matching columns) through
UNION T/f.It requires matching columns for UNION.
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is data transformation manager process?
How would you join a node to the already existing domain?
What is the use of transformation?
What are the mapping parameters and mapping variables?
Differentiate between source qualifier and filter transformation?
What is a mapplet/worklet in informatica?
What is main use of mapplet?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Different sorts of metadata that stores in the storage facility?
What is a repository manager?
Performance tuning( what you did in performance tuning)
How to call shell scripts from informatica?
What are the informatica performance improvement tips