for union t/f tables structures should be same, i mean columns and data t

I am having two tables,say table1 having cols
Empid,firstname,lastname,middlename and table2 having
Empid,firstname,lastname can i union them using Union t/f?

Question Posted / ganithi anil

6 Answers
11342 Views
Accenture, I also Faced
E-Mail Answers

Answer Posted / ganithi anil

for union t/f tables structures should be same, i mean
columns and data types should besame then only you use
union t/f

Is This Answer Correct ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is meant by lookup transformation? Explain the types of lookup transformation?

952

What are the types of lookup transformation?

1081

Explain dynamic target flat file name generation in informatica

1056

Explain in detail about scd type 1 through mapping.

1555

What is DR strategy for Informatica project?

1190

Explain the different kinds of facts.

984

Plz can any one say me how to get the informatica certification materials and dumps

2050

What are the different options available for update strategy?

1005

How to implement security measures using repository manager?

1182

Could you explain what is enterprise data warehouse?

1148

Which files are created during the session rums by informatics server?

1181

difference between repository database and repository service?

1156

can you please explain me pre session and post session options?

7574

How to extract sap data using informatica? What is abap? What are idocs?

1183

Write the different tools in the workflow manager?

1070