without matching columns in two tables. how can you join
Answer Posted / manjunath
Case 1 : If we want to join two tables we need matching column based on condition.
Case 2 : If we join two tables without column then go for union T/R
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What do you mean by blocking transformation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Make a note of the quantity vaults made in informatica?
What are the different options available for update strategy?
Explain the mapping variable usage example in informatica
What is an active transformation?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is a rank transform?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is resilience time?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What do you understand by a term domain?
How can we use mapping variables in informatica? Where do we use them?
How to open an older version of an object in the workspace?