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?
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
What is an unconnected transformation?
Why union transformation is an active transformation?
Clarify the aggregator change?
What are the differences between joiner transformation and source qualifier transformation?
What all are steps in up gradation of Informatica server?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
In development project what is the process to follow for an etl developer from day1
What are the settings that you use to configure the joiner transformation?
What is aggregator transformation in informatica?
What is the use of target designer?
Is it possible to revert a global repository to local one and why?
What is the use of code page?
Explain the pipeline partition with real time example?
What is informatica? Why do we need it?
what is the Default Source Option For Update Strategy Transformation?