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
- 11073 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
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
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 to elaborate powercenter integration service?
What are the various types of transformation?
if we have a delimiters at unwanted places in a flat file how can we over come those.
can we override a native sql query within informatica? Where do we do it? How do we do it?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Define the various join types of joiner transformation?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How to do unit testing in informatica? How to load data in informatica ?
Please let me know how to make Data masking in informatica..
What are mapplets?
What is meant by pre and post session shell command?
What is rank transformation?
How to create or import flat file definition in to the warehouse designer?
