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


Please Help Members By Posting Answers For Below Questions

How do you convert single row from source into three rows into target?

904


what is SDLC way of code development?

1811


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

881


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1850


Explain what are the different versions of informatica?

899


Explain the code page compatibility?

867


COM components can be used in Informatica

2137


can any one give some examples for pre sql and post sql(Except dropping and creating index).

3809


What is the cumulative sum and moving sum?

991


What are the new features of informatica 9.x in developer level?

805


Whats the difference between informatica powercenter server, repositoryserver and repository?

958


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6939


What does role playing dimension mean?

842


How can we handle two sessions in informatica?

831


What are the advantages of using informatica as an etl tool over teradata?

808