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
- 11071 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / sudheer
No need to create any dummy column(table-2) and make it as null...
Just create 2 groups as u have 2 tables and create 4 group ports like below Empid,firstname,lastname,middlename.
-Drag respective columns from src to union.
-Don't make any link for middle name from table as we don't have any column but drag all columns from table 2 and save the mapping and run the session.....This will work as i have tested.Thanks......
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
draw informatica architecture 8.6 ?
Define mapping and session?
Is there any way to read the ms excel datas directly into informatica?
what is degenerated dimension?
What are the new features of informatica 9.x in developer level?
What is the need for an etl tool?
What is the difference between Active and Passive transformation?
How many numbers of sessions can one group in batches?
what is mean by complex business rule ?
What are session parameters ? How do you set them?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Performance tuning in UNIX for informatica mappings?
Different circumstance which drives informatica server to expel records?
write a query to retrieve the latest records from the table sorted by version(scd)
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
