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
- 11527 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
list out all the transformations which use cache?
What is intricate mapping?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What are the tasks that can be performed using sq?
Explain sql transformation in script mode examples in informatica
What is the difference between a connected look up and unconnected lookup?
How are indexes created after completing the load process?
What is meant by incremental aggregation?
Briefly define reusable transformation?
How does a rank transform differ from aggregator transform functions max and min?
difference between repository database and repository service?
How can we use mapping variables in informatica? Where do we use them?
How do you load only null records into target? Explain through mapping flow.
What is joiner change?
Reusable transformation and shortcut differences
