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


Please Help Members By Posting Answers For Below Questions

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2082


What do you mean by blocking transformation?

786


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.

891


Make a note of the quantity vaults made in informatica?

783


What are the different options available for update strategy?

779


Explain the mapping variable usage example in informatica

864


What is an active transformation?

848


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1699


What is a rank transform?

866


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1688


What is resilience time?

849


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

1764


What do you understand by a term domain?

882


How can we use mapping variables in informatica? Where do we use them?

845


How to open an older version of an object in the workspace?

856