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
- 11122 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / ganithi anil
for union t/f tables structures should be same, i mean
columns and data types should besame then only you use
union t/f
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / pavana
Yes , we can created 2 input groups with 4 columns . For 1st
input group pass all columns from table 1 ,for 2nd input
group pass all 3 columns from table 2, 4th column from in
2nd group remain unconnected.
Session executes successfully. output will be the union of 2
tables. The 4th column from 2nd table will be populated as
null in output.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ravikumar2614
Yes we can.
create one more colomn in table-2 with same data type and assaign null values to that colom, then we can union two tables.
please correct if am wrong.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
how remove 1st 3 records & last 3 records in informatics
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
What does cheating measurement mean?
Name the different lookup cache(s)?
how do u use sequence created in oracle in informatica? Explain with an simple example
Teradata 
