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
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How does a rank transform differ from aggregator transform functions max and min?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How an expression transformation differs from aggregator transformation?
have u done any performance tuning? how u ll do?
What is informatica etl tool?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Explain pushdown optimization and types in informatica
What is sorter transformation?
Is it possible to revert a global repository to local one and why?
whats the logic to load the lower level of granularity of data to fact table.
Why update strategy and union transformations are active? Explain with examples.
Can we create a node as a gateway node and the same node can be assigned to a grid?
What are the databases that informatica can connect to windows?
Explain the different dimensions.