Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 6 Answers
- 11365 Views
- Accenture, I also Faced
- E-Mail Answers
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
Is it possible to revert a global repository to local one and why?
my source is junk data how will u remove that junk data by using unix please any one replay me
How we can create indexes after completing the load process?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How to load the data from people soft hrm to people soft erm using informatica?
Explain the etl program with few examples.
How to update or delete the rows in a target, which do not have key fields?
explain about unit testing? in real time?
Name the different lookup cache(s)?
what is degenerated dimension?
What are the measure objects?
Explain pushdown optimization and types in informatica
Why update strategy and union transformations are active? Explain with examples.
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is a difference between complete, stop and abort?
