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
- 11343 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
What is session task and command task?
Performance tuning in UNIX for informatica mappings?
Mention a few design and development best practices for informatica?
How you know when to use a static cache and dynamic cache in lookup transformation?
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
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How to generate sequence numbers?
Why update strategy and union transformations are active?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the transformations that are not supported in mapplet?
Define mapplet?
What is rank index in rank transformation?
Explain incremental aggregation in informatica
explain abt ur project architecture?
Define joiner transformation?
