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 / 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
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
4 yrs etl devloper roles and responsibilities?any body give solutions
How you know when to use a static cache and dynamic cache in lookup transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is the need of an ETL tool?
What are the new features of Power Center 5.0?
What are the different components of powercenter?
What will be the approach?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is session task and command task?
How does a rank transform differ from aggregator transform functions max and min?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Explain the mapping variable usage example in informatica
What is lookup transformation?
How do you promote a non-reusable transformation to reusable transformation?