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 / pavana
Yes , we can created 2 input groups with 4 columns . For 1st
input group pass all columns from table 1 ,for 2nd input
group pass all 3 columns from table 2, 4th column from in
2nd group remain unconnected.
Session executes successfully. output will be the union of 2
tables. The 4th column from 2nd table will be populated as
null in output.
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what is index?how it can work in informatica
Slowly changing dimensions, types and where will you use them
Explain how many types of dimensions are available in informatica?
What are the performance considerations when working with aggregator transformation?
How to partition the Session?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
what is the size of your data warehousing?
How would you copy the content of one repository to another repository?
Mention some types of transformation?
Reusable transformation and shortcut differences
Why do we need informatica?
What are the differences between joiner transformation and source qualifier transformation?
What's the layout of parameter file (what does a parameter file contain?)?
What could be the possible resons of locks by user?
How might you approve all mappings in the archive all the while?