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
- 9388 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / sreenu
It is not possible to put both in Union directly,
The group coming to Union must have same number of columns
and its data type must be compatible.
In this case first table has 4 columns and the second table
has 3 only.
alternatively you can follow the below logic to pass to
union transformation
Because the 2nd table has only 3 columns, create dummy
column for the 2nd flow and pass null in that port, so that
you can connect them to Union
| Is This Answer Correct ? | 30 Yes | 4 No |
Post New Answer View All Answers
How can informatica be used for an organization?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What do you understand by term role-playing dimension?
What is a repository manager?
Informatica settings are available in which file?
What is confirmed fact in dataware housing?
Is it possible to define a single node as a Gateway node as well as worker node?
How can we improve session performance in aggregator transformation?
Mention some types of transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Write the unconnected lookup syntax?
How can we remove the duplicates from flat file source?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Define filter transformation?
What is the difference between STOP and ABORT options in Workflow Monitor?
